Ixora Answers - Archive for September 2000

	01-Sep-2000 00:42	Parallel execution latches
	01-Sep-2000 02:08	Log 'sync cost ratio' again
	01-Sep-2000 02:31	Fast full index scan vs. Unique index scan
	01-Sep-2000 03:41	Bitmap-Index and Optimizer
	01-Sep-2000 10:31	Asynchronous I/O for LGWR
	01-Sep-2000 13:43	Library cache latch contention
	01-Sep-2000 22:48	'CPU used by this session' and 'buffer busy waits'
	02-Sep-2000 10:13	Redo space wait ratio
	04-Sep-2000 14:37	X$ tables and keeping
	05-Sep-2000 00:15	8i DBWn changes
	05-Sep-2000 02:02	Why do the autotrace statistics show extra sorts?
	05-Sep-2000 02:41	High-end storage systems
	05-Sep-2000 08:05	X$ Tables
	05-Sep-2000 09:52	Fast-start checkpointing
	05-Sep-2000 15:58	Does it help if a temporary tablespace is NOLOGGING?
	05-Sep-2000 20:55	Maximum number of rows in a block
	06-Sep-2000 11:29	Invalidations in the sql area namespace
	06-Sep-2000 12:48	Index updates
	06-Sep-2000 13:22	Export, import and next extent size
	06-Sep-2000 13:47	sparse_indexes.sql
	06-Sep-2000 17:28	New APT script: child_sleeps.sql
	06-Sep-2000 23:02	New APT scripts: dump_logfile.sql and redo_time.sql
	06-Sep-2000 23:59	log_small_entry_max_size
	07-Sep-2000 00:18	'table scan (long tables)'
	07-Sep-2000 00:40	Drop table performance
	07-Sep-2000 22:50	log file single write and log file parallel write
	07-Sep-2000 23:44	NLS performance implications
	07-Sep-2000 23:52	Can db_check.sh detect a hung listener?
	08-Sep-2000 00:22	Quick I/O and priority_paging on Solaris
	08-Sep-2000 00:31	Strange internal error
	08-Sep-2000 02:17	Do the autotrace statistics include PLAN_TABLE blocks?
	08-Sep-2000 09:33	20 invalidations per hour
	08-Sep-2000 10:29	How to prevent DUAL having more than 1 row
	08-Sep-2000 11:27	How to find "mysterious" table and column names
	08-Sep-2000 11:59	Why "rows waited on: no row" in this deadlock?
	08-Sep-2000 12:33	PRAGMA SERIALLY_REUSABLE
	08-Sep-2000 13:18	buffer busy waits on undo header and index blocks
	08-Sep-2000 15:06	Operating system concepts book
	08-Sep-2000 20:12	Tuning for an intensively scanned table
	11-Sep-2000 11:36	Copyright permission
	11-Sep-2000 17:00	Parallel query and direct reads
	11-Sep-2000 17:45	cache_size_threshold and 8i
	12-Sep-2000 09:49	Top-N with a twist
	12-Sep-2000 20:59	Disabling DML locks
	12-Sep-2000 21:51	DG/UX page faults
	12-Sep-2000 22:15	Cache hit rate keeps falling
	13-Sep-2000 05:48	system_space_invaders.sql
	13-Sep-2000 07:07	Do FK indexes with concatenated columns prevent shared locks?
	13-Sep-2000 12:43	No subselect in explain plan
	14-Sep-2000 15:07	Placement of RULE hint in INSERT SELECT
	14-Sep-2000 17:18	Java memory usage data in 8.1.6
	14-Sep-2000 21:40	Building tablespaces concurrently in Version 7
	15-Sep-2000 10:16	CPU used by this session and involuntary context switches
	15-Sep-2000 12:19	What is answers@ixora.com.au?
	15-Sep-2000 13:38	trace_file_name.sql
	15-Sep-2000 15:22	ORA-4030: Out of process memory
	15-Sep-2000 15:37	Hash partitioning skew?
	15-Sep-2000 16:53	_trace_files_public
	15-Sep-2000 23:34	Undo header waits
	16-Sep-2000 00:03	_release_insert_threshold
	16-Sep-2000 00:30	Multiple datafiles per tablespace vs. one datafile per tablespace
	18-Sep-2000 12:57	ORA-4030 after OPS upgrade to 8.0.5
	18-Sep-2000 15:39	Multiple full table scans on the same object in the same query
	18-Sep-2000 17:12	Parallel query slower than serial
	18-Sep-2000 23:41	Event 10053
	20-Sep-2000 06:14	Checkpoints
	20-Sep-2000 12:59	Current SCN
	21-Sep-2000 01:36	SELECT FOR UPDATE on parent table does not prevent conflicting DML against child
	21-Sep-2000 21:08	Stripe element size for OLTP on raw
	21-Sep-2000 22:26	Buffer busy waits reason code 1016
	21-Sep-2000 22:50	INLIST ITERATOR or CONCATENATION
	22-Sep-2000 00:41	Set operators and query transformation
	22-Sep-2000 08:44	Parallelism forces cost-based optimization
	22-Sep-2000 09:45	Reverse key indexes
	22-Sep-2000 11:16	Solaris semaphore mechanism
	22-Sep-2000 11:19	Reverse key index data density
	22-Sep-2000 12:36	IOT range scan selectivity computation
	22-Sep-2000 17:48	Striping, partitions, EMC disks and parallel processing
	22-Sep-2000 19:57	log_buffer size
	23-Sep-2000 00:02	Interpreting lgwr_stats.sql
	23-Sep-2000 12:09	Latch wait posting
	23-Sep-2000 12:27	Explanation of rollback wraps statistic
	23-Sep-2000 13:32	PARSE_CALLS and EXECUTIONS in V$SQLAREA
	25-Sep-2000 10:47	Should NUMBER datatype be given scale and precision?
	25-Sep-2000 11:22	Ixora Answers announcement
	27-Sep-2000 23:46	Can a shared cursor be immediately discarded?