![The performance teeter-totter part 2: Toad® Turnpike [Finding indexes]](https://s38063.pcdn.co/wp-content/uploads/2025/09/fi-ToadTurnpikeExit_CorrectAspectRatio-1-300x194-1.png)
Finding new, effective indexes to improve database performance is hard. How hard? Take a short quiz at the end of this blog. Remember, Toad® Turnpike is about real people doing real things with Toa...
Please vote for Quest products like SharePlex®, Toad®, Foglight® and Spotlight®. Don’t read this or do what it says (just kidding, totally do what it says) In an election year, it’s tempting to ...
Did you know that you can predict the future performance for individual SQL statements and use these predictions to mitigate future performance issues using the Toad® for Oracle Spotlight® on Oracle f...
I'm pleased to announce the second release of Toad for Oracle this year which went GA on October 18. This is a brand new feature that addresses the needs of DBAs concerned about data privacy with the...
Real stories. Real people. Real situations. With Toad solutions. Blind-sided. Again. It’s another beautiful day in Southern California. I am on site at an insurance company for a one-day proof-of...
As a former DBA, I don’t like surprises. DBAs always want to know ahead of time if an issue is about to occur or is occurring, and we never want to be surprised by hearing there is an issue. When a de...
Disks for redo devices When a transaction is committed, the redo log entry in the redo log buffer must be written to disk. The characteristics of the redo log writes are very different from that of...
There are two possible states for archive logging, either off or on. If archive logging is on there are two possible states, either automatic or manual. These are controlled via the initialization par...
Oracle V11.1 Description Example >>──CREATE─┬──────────────────┬─TABLE──schema.──table──┬─relational_table─┬─> └─GLOBAL TEMPORARY─┘ ├─object_table─────┤ ...
The DBMS_JOB package is actually an API into an Oracle subsystem known as the job queue. The Oracle job queue allows for the scheduling and execution of PL/SQL routines (jobs) at predefined times and/...
This topic documents the initialization parameters used to configure the multi-threaded server (MTS). Only the currently recommended parameters are described here. Parameters that were made obsolete w...
Fragmentation in a tablespace is thought to be a performance killer. This has been proven to be a myth. Fragmentation by itself does not cause performance problems in a multi-user Oracle database. Wha...
