모든 문서

EXEM Knowledge Base

Jump to: navigation, 찾기
모든 문서 목록

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 valueDelayed block cleanout
Dion Cho ScriptsDirect path I/O
Direct path readDirect path read/write(lob)
Direct path read/write tempDirect path write
Dynamic samplingEnhanced I/O StatisticsEnhanced Partition Pruning Capabilities
Enq: CI - contentionEnq: DX - contentionEnq: HW - contention
Enq: RO - contentionEnq: SQ - contentionEnq: ST - contention
Enq: TC - contentionEnq: TM - contentionEnq: TX - allocate ITL entry
Enq: TX - index contentionEnq: TX - row lock contentionEnq: UL - contention
Enq: US - contentionEnqueueEnqueue PE
Explicit GCFAILED LOGIN ATTEMPTSFIX CONTROL
FLMFREELISTSFree buffer waits
GATHER PLAN STATISTICSGC AFFINITY LIMITGC Dump
Garbage CollectorGc buffer busy
Gc cr/current block 2-wayGc cr/current block 3-wayGc cr/current block busy
Gc cr/current block congestedGc cr/current grant 2-wayGc cr/current grant busy
Gc cr/current grant congestedGc cr/current multi block requestGc cr/current request
Gc current split
Gcs log flush syncGes enter server modeGlobal cache busy
Global cache null to sGlobal cache null to x
Global cache open sGlobal cache open xGlobal cache s to x
GranuleHProfHealth Monitor
Hex to decimal
Hidden parameter
INDEX RSINDEX RS ASCINDEX RS DESC
Index SplitJVM OptionsJava
Java.hprof.txtJava Thread
Java ToolsJava source:query result cache.java
Kksfbc child completionLOB
LOG BUFFERLatch: cache buffers chainsLatch: cache buffers lru chain
Latch: in memory undo latchLatch: library cacheLatch: redo allocation
Latch: redo copyLatch: redo writingLatch: shared pool
Latch freeLatch free(simulator lru latch)Library 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 TRANSITIVITY RETAINOPTIMIZER USE SQL PLAN BASELINES
OPTIM PEEK USER BINDSOPT ESTIMATEOPT PARAM
Optimizing oracle optimizerOracle 11g new featureOracle Dump
Oracle EventsOracle Hint TemplateOracle Parameter Template
Oracle ParametersOracle Redo LogOracle View Template
Oracle ViewsOracle VirusOracle is mad
Oradebug
PGA AGGREGATE TAREGETPGA AGGREGATE TARGETPOWI Season1
PUSH JOIN PREDICATEParallel Collector GC Log Sample
Parallel queryPerformance in depth
Print tableQB NAME
Query Result CacheREMOVE AGGR SUBQUERYRead by other session
Reason CodeRow Cache Lock
Run statsSESSION CACHED CURSORS
SESSION WAIT HISTORYSORT AREA RETAINED SIZESORT AREA SIZE
STAR TRANSFORMATION ENABLEDSYS.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 CURSORWait Event Template
Write complete waits대문
마스터노드찾기