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