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...
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...
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/...
Oracle V11.1 Description Example >>──CREATE─┬──────────────────┬─TABLE──schema.──table──┬─relational_table─┬─> └─GLOBAL TEMPORARY─┘ ├─object_table─────┤ ...
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...
Toad offers cool feature called make/strip code. It allows you to copy code from, say, C# or Java into Toad, turn it into simple SQL, optimize it, then send it back to the original format for inclusio...
Yes. In Editor, right-click and choose Refactor: convert to/from ANSI join. The query builder also offers this functionality. For example, you can send Editor contents to the query builder to "see" yo...
Q: Is there a way to understand why indexes aren't being used, even if they are referenced in the WHERE? A: Not really. For example, suppose WHERE GENDER = 'M' and I know there is an index in the col...
Q: I assume that the indexing in Exadata is not as important due to cell storage. Generally speaking, “full table scans” are not to be avoided as with non-Exadata databases. Exadata has numerous mecha...
A: No. The 64-bit version simply allows your program to use more memory. There is no real advantage to 64-bit unless you want to fetch a one-billion-row table all into memory on your PC within a Toad ...
A: Not necessarily. Actually, we recommend that, instead of the DBA role, you grant discrete privileges; that grants everything! Within Toad, we try to use USER_ and/or ALL_ where possible, but a few ...
A: Aside from privileges to connect, of course, some of the Schema Browser features might require access to the Data Dictionary views. Within Toad, we try to use USER_ and/or ALL_ where possible, but ...
