대문

EXEM Knowledge Base

Gracelee (토론 | 기여) 사용자의 2009년 7월 23일 (목) 04:15 버전

(차이) ←이전 버전 | 현재 문서 (차이) | 다음 버전→ (차이)

10104 Trace Sample	ADDM AUTO ENABLE	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	Ask exem 1
Aster's Oracle Event Tour	Asynchronous I/O	Automatic Diagnostic Repository
BACKGROUND DUMP DEST	BCI	BUMP HIGHWATER MARK COUNT
B TREE BITMAP PLANS	Bind Mismatch	Block Class
Block Dump	Bloom filtering	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: FB – 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	ITL	Index.php
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	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 Trouble Shooting	Oracle View Template
Oracle Views	Oracle Virus	Oracle is mad
Oracle qna	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	Redo synch writes
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	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/%EB%8C%80%EB%AC%B8’