대문

EXEM Knowledge Base

Jump to: navigation, 찾기


그림 : 위키_하단3.jpg


10104 Trace SampleADDM AUTO ENABLE
ALWAYS ANTI JOINALWAYS SEMI JOINARCHIVE LAG TARGET
ASH DISK FILTER RATIOASH DISK WRITE ENABLEASH ENABLE
ASH SAMPLING INTERVALASSMAdd column
Aster's Oracle Event TourAsynchronous I/O
Automatic Diagnostic RepositoryBACKGROUND DUMP DESTBCI
BUMP HIGHWATER MARK COUNTB TREE BITMAP PLANSBind Mismatch
Block ClassBlock DumpBloom filtering
Buffer busy waits
Buffer deadlockBuffer exterminateCARDINALITY
CMS Collector GC Log SampleCOMMIT WRITE
COMPLEX VIEW MERGINGCURSOR BIND CAPTURE AREA SIZECURSOR BIND CAPTURE INTERVAL
CURSOR SPACE FOR TIMECompilerThread
Concurrent GC
Control file parallel writeDBMS Internals Vol1
DBMS SHARED POOL.KEEPDBMS SHARED POOL.PURGEDBMS SPACE.SPACE USAGE
DBMS STATS.GATHER DICTIONARY STATSDB CACHE ADVICEDB FILE DIRECT IO COUNT
DB FILE EXEC READ COUNTDB FILE MULTIBLOCK READ COUNTDB FILE OPTIMIZER READ COUNT
DDL WAIT FOR LOCKSDFS lock handleDISABLE LOGGING
DISK ASYNCH IODUALDb file parallel read
Db file parallel writeDb file scattered readDb file sequential read
Db file single writeDbms stats.convert raw valueDdl trigger
Delayed block cleanoutDion Cho Scripts
Direct path I/ODirect path read
Direct path read/write(lob)Direct path read/write temp
Direct path write
Dynamic samplingEnhanced I/O Statistics
Enhanced Partition Pruning CapabilitiesEnq: CI - contentionEnq: DX - contention
Enq: HW - contentionEnq: RO - contentionEnq: SQ - contention
Enq: ST - contentionEnq: TC - contentionEnq: TM - contention
Enq: TX - allocate ITL entryEnq: TX - index contentionEnq: TX - row lock contention
Enq: UL - contentionEnq: US - contentionEnqueue
Enqueue PEExplicit GCFAILED LOGIN ATTEMPTS
FIX CONTROLFLMFREELISTS
Free buffer waitsGATHER PLAN STATISTICSGC AFFINITY LIMIT
GC DumpGarbage Collector
Gc buffer busyGc cr/current block 2-wayGc cr/current block 3-way
Gc cr/current block busyGc cr/current block congestedGc cr/current grant 2-way
Gc cr/current grant busyGc cr/current grant congestedGc cr/current multi block request
Gc cr/current request
Gc current split
Gcs log flush syncGes enter server mode
Global cache busyGlobal cache null to s
Global cache null to xGlobal cache open sGlobal cache open x
Global cache s to xGranuleHProf
Health Monitor
Hex to decimalHidden parameter
INDEX RSINDEX RS ASC
INDEX RS DESCIndex SplitJVM Options
JavaJava.hprof.txt
Java ThreadJava ToolsJava source:query result cache.java
KKS USE MUTEX PIN
Kksfbc child completionLOBLOG BUFFER
Latch: cache buffers chainsLatch: cache buffers lru chainLatch: in memory undo latch
Latch: library cacheLatch: redo allocationLatch: redo copy
Latch: redo writingLatch: shared poolLatch free
Latch free(simulator lru latch)Library cache: mutex XLibrary cache lock
Library cache pinLog buffer spaceLog file parallel write
Log file sequential read
Log file switch completionLog file sync
MAX COMMIT PROPAGATION DELAYMINIMAL STATS AGGREGATIONMONITOR
Memory LeakMonitorNO QUERY TRANSFORMATION
NUMA
OOMEOPEN CURSORSOPTIMIZER ADAPTIVE CURSOR SHARING
OPTIMIZER CAPTURE SQL PLAN BASELINESOPTIMIZER COST BASED TRANSFORMATIONOPTIMIZER FEATURES ENABLE
OPTIMIZER IGNORE HINTSOPTIMIZER INVALIDATION PERIODOPTIMIZER PUSH PRED COST BASED
OPTIMIZER SECURE VIEW MERGINGOPTIMIZER SKIP SCAN ENABLEDOPTIMIZER TRANSITIVITY RETAIN
OPTIMIZER USE SQL PLAN BASELINESOPTIM PEEK USER BINDSOPT ESTIMATE
OPT PARAMOptimizing oracle optimizerOracle 11g new feature
Oracle DumpOracle EventsOracle Hint Template
Oracle Parameter TemplateOracle ParametersOracle Redo Log
Oracle View TemplateOracle ViewsOracle Virus
Oracle is madOradebug
PARALLEL INSTANCE GROUPPGA AGGREGATE TAREGET
PGA AGGREGATE TARGETPGA MAX SIZEPOWI Season1
PUSH JOIN PREDICATEParallel Collector GC Log Sample
Parallel queryPerformance in depth
Print tableQB NAME
Query Result CacheREMOVE AGGR SUBQUERYREWRITE OR ERROR
Read by other sessionReason Code
Row Cache LockRun stats
SESSION CACHED CURSORSSESSION WAIT HISTORYSMM MAX SIZE
SORT AREA RETAINED SIZESORT AREA SIZE
STAR TRANSFORMATION ENABLEDSWAP JOIN INPUTSSYS.OPTSTAT HIST CONTROL$
Segment PartitioningSerial Collector GC Log Sample
Show space
Sun HotSpot JVMSun HotSpot JVM:Heap ManagementSun HotSpot JVM Heap Management
Thread Dump
To decTransactionTransaction internals
UNNEST SUBQUERYUndo Header DumpUsergroup:sysop
V$LOCKV$SQL BIND CAPTURE
V$SQL BIND DATAV$SQL SHARED CURSORWITH SUBQUERY
Wait Event TemplateWrite complete waits
대문마스터노드찾기