모든 문서

EXEM Knowledge Base

10104 Trace Sample	ADDM AUTO ENABLE	AIO
ALWAYS ANTI JOIN	ALWAYS SEMI JOIN	ARCHIVE LAG TARGET
ASH DISK FILTER RATIO	ASH DISK WRITE ENABLE	ASH ENABLE
ASH SAMPLING INTERVAL	ASSM	Add column
Aster's Oracle Event Tour	Asynchronous I/O	Asynchronous IO
Automatic Diagnostic Repository	BACKGROUND DUMP DEST	BCI
BUMP HIGHWATER MARK COUNT	B TREE BITMAP PLANS	Bind Mismatch
Block Class	Block Dump	Bloom filtering
Bloom filtring	Book optimizer	Buffer busy waits
Buffer deadlock	Buffer exterminate	CARDINALITY
CMS Collector	CMS Collector GC Log Sample	COMMIT WRITE
COMPLEX VIEW MERGING	CURSOR BIND CAPTURE AREA SIZE	CURSOR BIND CAPTURE INTERVAL
CURSOR SPACE FOR TIME	Commit	CompilerThread
Compiler Thread	Concurrent Full GC	Concurrent GC
Concurrent Generational Collector	Control file parallel write	DBMS Internals Vol1
DBMS SHARED POOL.KEEP	DBMS SHARED POOL.PURGE	DBMS SPACE.SPACE USAGE
DBMS STAS	DBMS STATS.GATHER DICTIONARY STATS	DB CACHE ADVICE
DB FILE DIRECT IO COUNT	DB FILE EXEC READ COUNT	DB FILE MULTIBLOCK READ COUNT
DB FILE OPTIMIZER READ COUNT	DDL WAIT FOR LOCKS	DFS lock handle
DISABLE LOGGING	DISK ASYNCH IO	DUAL
Db file parallel read	Db file parallel write	Db file scattered read
Db file sequential read	Db file single write	Dba dml locks
Dbms stats.convert raw value	Ddl trigger	Delayed block cleanout
Dfs lock handle	Dion Cho Scripts	Direct path I/O
Direct path read	Direct path read(lob)	Direct path read/write(lob)
Direct path read/write temp	Direct path read temp	Direct path write
Direct path write(lob)	Direct path write temp	Disable JIT Compiler
Dynamic sampling	EXEM	Enhanced I/O Statistics
Enhanced Partition Pruning Capabilities	Enq: CI - contention	Enq: DX - contention
Enq: HW - contention	Enq: RO - contention	Enq: SQ - contention
Enq: ST - contention	Enq: TC - contention	Enq: TM - contention
Enq: TX - allocate ITL entry	Enq: TX - index contention	Enq: TX - row lock contention
Enq: UL - contention	Enq: US - contention	Enqueue
Enqueue PE	Explicit GC	FAILED LOGIN ATTEMPTS
FAST START MTTR TARGET	FIX CONTROL	FLM
FREELISTS	Free buffer waits	GATHER PLAN STATISTICS
GC AFFINITY LIMIT	GC Dump	Garbage Collect
Garbage Collector	Gc buffer busy	Gc cr/current block 2-way
Gc cr/current block 3-way	Gc cr/current block busy	Gc cr/current block congested
Gc cr/current grant 2-way	Gc cr/current grant busy	Gc cr/current grant congested
Gc cr/current multi block request	Gc cr/current request	Gc cr block 2-way
Gc cr block 3-way	Gc cr block busy	Gc cr block congested
Gc cr grant 2-way	Gc cr grant busy	Gc cr grant congested
Gc cr multi block request	Gc cr request	Gc current block 2-way
Gc current block 3-way	Gc current block busy	Gc current block congested
Gc current grant 2-way	Gc current grant busy	Gc current grant congested
Gc current multi block request	Gc current request	Gc current split
Gc dump	Gc log	Gcs log flush sync
Ges enter server mode	Global cache busy	Global cache cr/current request
Global cache null to s	Global cache null to x	Global cache open s
Global cache open x	Global cache s to x	Granule
HProf	Health Monitor	Heap
Heap dump	Hex to decimal	Hidden parameter
How to find master node in RAC	Hprof	INDEX RS
INDEX RS ASC	INDEX RS DESC	Index Split
JVM Options	Java	Java.hprof.txt
Java Dump	Java Performance Fundamental	Java Thread
Java Tools	Java performance fundamental	Java source:query result cache.java
Jvm options	KAIO	KKS USE MUTEX PIN
Kksfbc child completion	LOB	LOG BUFFER
Latch: cache buffers chains	Latch: cache buffers lru chain	Latch: in memory undo latch
Latch: library cache	Latch: redo allocation	Latch: redo copy
Latch: redo writing	Latch: shared pool	Latch free
Latch free(simulator lru latch)	Library cache: mutex X	Library cache lock
Library cache pin	Log buffer space	Log file parallel write
Log file sequential read	Log file switch (archiving needed)	Log file switch (checkpoint incomplete)
Log file switch (private strand flush incomplete)	Log file switch completion	Log file sync
MAX COMMIT PROPAGATION DELAY	MINIMAL STATS AGGREGATION	MONITOR
Memory Leak	Monitor	NO QUERY TRANSFORMATION
NUMA	Numa	OOM
OOME	OPEN CURSORS	OPTIMIZER ADAPTIVE CURSOR SHARING
OPTIMIZER CAPTURE SQL PLAN BASELINES	OPTIMIZER COST BASED TRANSFORMATION	OPTIMIZER FEATURES ENABLE
OPTIMIZER IGNORE HINTS	OPTIMIZER INVALIDATION PERIOD	OPTIMIZER PUSH PRED COST BASED
OPTIMIZER SECURE VIEW MERGING	OPTIMIZER SKIP SCAN ENABLED	OPTIMIZER TRANSITIVITY RETAIN
OPTIMIZER USE FEEDBACK	OPTIMIZER USE SQL PLAN BASELINES	OPTIM PEEK USER BINDS
OPT ESTIMATE	OPT PARAM	Optimizing oracle optimizer
Oracle 11g new feature	Oracle Dump	Oracle Events
Oracle Hint Template	Oracle Parameter Template	Oracle Parameters
Oracle Redo Log	Oracle View Template	Oracle Views
Oracle Virus	Oracle is mad	Oracle virus
Oradebug	OutOfMemory	OutOfMemoryError
Out Of Memory Error	Outofmemoyrerror	PARALLEL INSTANCE GROUP
PGA AGGREGATE TAREGET	PGA AGGREGATE TARGET	PGA MAX SIZE
POWI Season1	PUSH JOIN PREDICATE	Parallel Collector
Parallel Collector GC Log Sample	Parallel query	Performance in depth
Pga aggregate target	Powi1	Print table
QB NAME	Query Result Cache	REMOVE AGGR SUBQUERY
REWRITE OR ERROR	Read by other session	Reason Code
Response Time Collector	Row Cache Lock	Row level lock
Run stats	SESSION CACHED CURSORS	SESSION WAIT HISTORY
SMM MAX SIZE	SORT AREA RETAINED SIZE	SORT AREA SIZE
SQ lock	STAR TRANSFORMATION ENABLED	SWAP JOIN INPUTS
SYS.OPTSTAT HIST CONTROL$	Segment Partitioning	Serial Collector
Serial Collector GC Log Sample	Shared pool	Show space
Subpool Collector	Sun HotSpot JVM	Sun HotSpot JVM:Heap Management
Sun HotSpot JVM Heap Management	TAIO	Thread Dump
Throughput Collector	To dec	Transaction
Transaction internals	UNNEST SUBQUERY	Undo Header Dump
Undo segment	Usergroup:sysop	V$CURRENT BLOCK SERVER
V$LOCK	V$SQL BIND CAPTURE	V$SQL BIND DATA
V$SQL SHARED CURSOR	WITH SUBQUERY	Wait Event Template
Write complete waits	다중 버퍼 풀	대문
마스터노드찾기	비동기식 I/O

원본 주소 ‘http://wiki.ex-em.com/index.php/%ED%8A%B9%EC%88%98%EA%B8%B0%EB%8A%A5:Allpages’