Advanced Questions and Answers

Ixora is pleased to host a public forum for questions and answers about the internals and performance of Oracle on Unix.

Questions?

To ask a question by email, please email questions@ixora.com.au.

Answers

Subscription to the "Ixora Answers" mailing list has been disabled. Some questions are still being answered directly, but the answers are no longer being posted below.

Old Answers

November 2001
October 2001
July 2001
May 2001
April 2001
March 2001
February 2001
January 2001
December 2000
November 2000
October 2000
September 2000
August 2000

Older Answers

SQL Optimization Tracing  
Access paths  
Join mechanisms  
Gathering statistics  
Optimizer internals  
Partitioning  
Parallel execution  
 
Sorts Sort area size  
Disk sorts  
Sort locks   Sort I/O  
 
I/O RAID  
Mirroring  
Striping  
Block size  
Asynchronous I/O  
Direct I/O  
Raw  
 
Files Controlfiles  
Logfiles  
Datafiles  
Headers  
Structure  
Contents  
 
Space Management Tablespaces  
Extents  
Space transactions  
Temporary space  
Housekeeping  
 
Data Blocks and Freelists Block headers  
Datatype encoding  
PCTFREE and PCTUSED  
Row migration and chaining  
Data block waits  
Process and transaction freelists  
Freelist groups  
INITRANS  
 
Indexes Types  
Structure  
Size   Maintenance  
 
Buffer Cache Cache hit rate  
Buffer pools  
LRU lists  
Hash chains  
Buffer cache latches  
Block classes and buffer states  
Buffer locks  
Buffer busy waits  
Table scans  
Multiblock reads  
Read I/O statistics  
 
Database Writer (DBWn) Write bandwidth  
Dirty and auxiliary lists  
Free buffer waits  
Write complete waits  
Checkpoints  
Write I/O statistics  
 
Redo Generation Redo records  
Log buffer  
Log block size  
Redo latches  
Log switches  
Commits  
Log file I/O  
LGWR tuning  
Log miner  
Redo dumps  
Nologging operations  
 
Rollback Segments Extent Size  
Concurrency  
Transaction tables  
Undo dumps  
Rollback segment I/O  
Dynamic extension  
Shrinks  
Wraps  
Optimal  
Undo header waits  
Undo block waits  
Distributed transactions  
Corruption  
Deferred rollback segments  
 
Read Consistency Multi-version concurrency  
Isolation levels  
ORA-1555  
Commit cleanout  
Delayed block cleanout  
Transaction table rollback  
 
Latches Latch statistics   General latch tuning   Minor latches  
 
Locks and Deadlocks DML table locks  
Row-level locks  
ITL entry shortages  
ORA-60  
ORA-2049  
ORA-4020  
Lock cleanup  
Minor enqueues  
 
Memory SGA contents  
PGA contents  
Physical memory   Swap space and paging  
 
Shared Pool Sizing  
Fragmentation  
Latch contention  
LRU lists  
Flushing  
ORA-4031  
Reserved pool  
Keeping  
 
Library Cache Parsing  
Hash values  
Namespaces  
Subheaps  
Cursor sharing  
Invalidations  
Synonyms  
Latch contention  
Hash table  
Locks and pins  
Instantiations  
Dictionary cache  
 
Data Dictionary Contents  
Views  
Performance  
Hacks  
SQL.BSQ  
 
CPU Usage Usage modes  
Scheduling  
Semaphores  
Latencies  
Real-time  
Processor binding  
 
Waits and Statistics Wait statistics  
System statistics  
Tracing waits  
Idle waits  
Wait tuning  
 
X$ Tables Contents   Querying   Interpretation  
 
Internal Errors ORA-600 errors  
ORA-7445 errors  
OSD errors  
Crashes  
Corruptions  
Workarounds  
 
Parameters Hidden parameters  
Other parameters  
Default values   Tuning  
 
Setting Events Syntax   Levels   Trace file contents  
 
Backup and Recovery Strategy  
Hot  
Cold  
Export  
Import  
Archiving  
Hot Standby  
Internals  
 
PL/SQL Supplied packages   Internals   Performance  
 
Miscellaneous Undocumented syntax  
Background processes  
State objects  
Parallel server  
Network tuning  
Shell scripting  
SQL*Plus  
Documentation  
Training  
Database monitoring  
Security  
More  
 
Copyright Ixora Pty Ltd Home