性能調査が加速する日本エクセムのMaxGauge

Oracle Knowledge

AsterくんがガイドするOracle Event Tour
Oracle Knowledge
“Scene1 同一行の変更による TX Enqueue”...
2015/07/30
Oracle Knowledge
“Scene2 SQLの解析”...
2015/08/07
Oracle Knowledge
“Scene3 SQLの作成”...
2015/08/07
Oracle Knowledge
“Scene4 Enq:SQ-Contention”...
2015/08/07
Oracle Knowledge
“Scene5 ラッチ:Cache Buffers Chains”...
2015/08/07
Oracle Knowledge
“Scene6 Multi Block I/O”...
2015/08/07
Oracle Knowledge
“Scene7 db file sequential read”...
2015/08/07
Oracle Knowledge
“Scene8 Enq: US-Connection2”...
2015/08/07
Oracle Knowledge
“Scene9 Log File Sync”...
2015/08/07
Oracle Knowledge
“Scene10 library cache pin”...
2015/08/07
Oracle Knowledge
“Scene11 Log Buffer Space”...
2015/08/07
Oracle Knowledge
“Scene12 Read By Other Session”...
2015/08/07
Oracle Knowledge
“Scene13 direct path read temp”...
2015/08/07
Oracle Knowledge
“Scene14 direct path write”...
2015/08/07
Oracle Knowledge
“Scene15 write complete waits”...
2015/08/07
Oracle Knowledge
“Scene16 latch: cache buffers lru chain”...
2015/08/07
Oracle Knowledge
“Scene17 enq:TM-contention”...
2015/08/07
Oracle Knowledge
“Scene18 latch: shared pool (bind mismatch)”...
2015/08/07
Oracle Knowledge
“Scene19 Enq: TX – index contention”...
2015/08/07
Oracle Knowledge
“Scene20 latch: library cache（関数コールによる遂行回数増加）”...
2015/08/07
Oracle Knowledge
“Scene21 log file switch conpletion”...
2015/08/07
Oracle Knowledge
“Scene22 Enq:HW-Contention”...
2015/08/07
Oracle Knowledge
“Scene23 – gc buffer busy”...
2015/08/07
Oracle Knowledge
“Scene24 – Free buffer waits”...
2015/08/07
Oracle Knowledge
“Scene25 – SGA： allocation forcing Component growth”...
2015/08/07
Oracle Knowledge
“Scene26 – Enq:TC-Contention”...
2015/08/07
Oracle Knowledge
“Scene27 – gc cr/current block 2/3-way”...
2015/08/07
Oracle Knowledge
“Scene28 – db file parallel write”...
2015/08/07
Oracle Knowledge
“Scene29 – SQL*Net more data from/to client”...
2015/08/07
Oracle Knowledge
“Scene30 – Cursor pin S wait on X”...
2015/08/07
Oracle Knowledge
“Scene31 – gc current sprit”...
2015/08/07
Oracle Knowledge
“Scene32 – gc cr failure”...
2015/08/07
Oracle Knowledge
“Scene33 – gc cr/current multiblock request”...
2015/08/07
Oracle Knowledge
“Scene34 – enq:ST – contention”...
2015/08/07
Oracle Knowledge
“Scene35 – enq:TX-allocate ITL entry”...
2015/08/07
Oracle Knowledge
“Scene36 – kksfbc child completion”...
2015/08/07
Oracle Knowledge
“Scene37 – db file parallel read”...
2015/08/07
Oracle Knowledge
“Scene38 – Control file parallel write”...
2015/08/07
Oracle Knowledge
“Scene39 – Child LCO 生成”...
2015/08/07
Oracle Knowledge
“Scene40 – gc cr/current grant 2 way”...
2015/08/07
Oracle Knowledge
“Scene41 – log file parallel write”...
2015/08/07
Oracle Event 解説
Oracle Knowledge
Gc cr/current block 2-way...
2019/04/19
Oracle Knowledge
Gc cr/current block 3-way...
2019/03/22
Oracle Knowledge
Gc cr/current block busy...
2019/02/28
Oracle Knowledge
Gc cr/current block congested...
2019/02/14
Oracle Knowledge
Gc cr/current grant busy...
2019/02/07
Oracle Knowledge
Gc cr/current grant congested...
2019/01/25
Oracle Knowledge
Gc current split...
2019/01/16
Oracle Knowledge
Ges enter server mode...
2018/12/21
Oracle Knowledge
DFS lock handle...
2018/12/06
Oracle Knowledge
Latch: in memory undo latch...
2018/11/07
Oracle Knowledge
Global cache busy...
2018/11/07
Oracle Knowledge
Enq: DX – contention...
2018/10/24
Oracle Knowledge
Latch: redo copy...
2018/10/10
Oracle Knowledge
Global cache null to s...
2018/10/04
Oracle Knowledge
Enq: CI – contention...
2018/10/04
Oracle Knowledge
Enq: HW – contention...
2018/09/25
Oracle Knowledge
Latch: redo allocation...
2018/09/19
Oracle Knowledge
Global cache open s...
2018/09/13
Oracle Knowledge
Enq: TC – contention...
2018/09/13
Oracle Knowledge
Db file parallel read...
2018/09/05
Oracle Knowledge
Latch: redo writing...
2018/08/31
Oracle Knowledge
Global cache s to x...
2018/08/31
Oracle Knowledge
Enq: ST – contention...
2018/08/24
Oracle Knowledge
Db file single write...
2018/08/24
Oracle Knowledge
Latch free...
2018/08/01
Oracle Knowledge
Global cache null to x...
2018/08/01
Oracle Knowledge
Enq: TM – contention...
2018/07/26
Oracle Knowledge
Oracle Events...
2018/07/12
Oracle Knowledge
Latch free(simulator lru latch)...
2018/07/04
Oracle Knowledge
Global cache null to x...
2018/06/27
Oracle Knowledge
Enq: UL – contention...
2018/06/20
Oracle Knowledge
Library cache: mutex X...
2018/05/09
Oracle Knowledge
Library cache pin...
2018/03/08
Oracle Knowledge
Enqueue PE...
2018/02/08
Oracle Knowledge
Direct path read/write(lob)...
2018/01/31
Oracle Knowledge
Buffer exterminate...
2018/01/24
Oracle Knowledge
Row Cache Lock...
2017/12/27
Oracle Knowledge
Log file sequential read...
2017/12/06
Oracle Knowledge
Direct path write...
2017/11/08
Oracle Knowledge
Enqueue...
2017/11/07
Oracle Knowledge
Control file parallel write...
2017/11/01
Oracle Knowledge
Write complete waits...
2017/10/25
Oracle Knowledge
Latch: shared pool...
2017/09/13
Oracle Knowledge
Kksfbc child completion...
2017/09/13
Oracle Knowledge
Gc cr/current request...
2017/08/30
Oracle Knowledge
Enq: SQ – contention...
2017/08/23
Oracle Knowledge
Free buffer waits...
2017/07/19
Oracle Knowledge
read by other session...
2015/08/16
Oracle Knowledge
log file sync...
2015/08/16
Oracle Knowledge
log file parallel write...
2015/08/16
Oracle Knowledge
log buffer space...
2015/08/16
Oracle Knowledge
Library cache lock...
2015/08/16
Oracle Knowledge
latch shared pool...
2015/08/16
Oracle Knowledge
latch: library cache...
2015/08/16
Oracle Knowledge
latch：cache buffers lru chain...
2015/08/16
Oracle Knowledge
latch cache buffers chains...
2015/08/16
Oracle Knowledge
gc buffer busy...
2015/08/15
Oracle Knowledge
enq: TX – Index contention...
2015/08/15
Oracle Knowledge
enq: US – contention...
2015/08/15
Oracle Knowledge
enq: TX – row lock contention...
2015/08/15
Oracle Knowledge
enq: TX – allocate ITL entry...
2015/08/15
Oracle Knowledge
enq: SQ – contention...
2015/08/15
Oracle Knowledge
enq: RO – contention...
2015/08/15
Oracle Knowledge
db file sequential read...
2015/08/15
Oracle Knowledge
db file scattered read...
2015/08/14
Oracle Knowledge
db file parallel write...
2015/08/14
Oracle Knowledge
direct path read/write temp...
2015/08/14
Oracle Knowledge
buffer busy waits...
2015/08/10
Oracle Other Knowledge
Oracle Knowledge
CMS Collector GC Log Sample...
2019/04/09
Oracle Knowledge
Serial Collector GC Log Sample...
2019/04/09
Oracle Knowledge
Parallel Collector GC Log Sample...
2019/04/09
Oracle Knowledge
GC Dump...
2019/04/09
Oracle Knowledge
GATHER PLAN STATISTICS...
2019/03/28
Oracle Knowledge
DBMS SHARED POOL.PURGE...
2019/03/28
Oracle Knowledge
GATHER PLAN STATISTICS...
2019/03/15
Oracle Knowledge
DBMS SHARED POOL.PURGE...
2019/03/15
Oracle Knowledge
DBMS SHARED POOL.KEEP...
2019/02/21
Oracle Knowledge
DBMS SPACE.SPACE USAGE...
2019/02/14
Oracle Knowledge
DBMS STATS.GATHER DICTIONARY STATS...
2019/01/31
Oracle Knowledge
DBMS STATS...
2018/12/12
Oracle Knowledge
Enhanced Partition Pruning Capabilities...
2018/12/06
Oracle Knowledge
Enhanced I/O Statistics...
2018/11/21
Oracle Knowledge
DUAL...
2018/09/25
Oracle Knowledge
OPT ESTIMATE...
2018/08/13
Oracle Knowledge
CARDINALITY...
2018/08/13
Oracle Knowledge
Ddl trigger...
2018/07/26
Oracle Knowledge
Health Monitor...
2018/06/27
Oracle Knowledge
Dbms stats.convert raw value...
2018/06/20
Oracle Knowledge
ASSM...
2018/04/11
Oracle Knowledge
V$SQL BIND DATA...
2018/04/05
Oracle Knowledge
SYS.OPTSTAT HIST CONTROL$...
2018/03/28
Oracle Knowledge
REWRITE OR ERROR...
2018/03/22
Oracle Knowledge
Parallel query...
2018/03/22
Oracle Knowledge
Oracle Redo Log...
2018/03/14
Oracle Knowledge
MONITOR...
2018/03/14
Oracle Knowledge
INDEX RS...
2018/02/28
Oracle Knowledge
INDEX RS DESC...
2018/02/28
Oracle Knowledge
INDEX RS ASC...
2018/02/21
Oracle Knowledge
Hex to decimal...
2018/02/14
Oracle Knowledge
Granule...
2018/02/14
Oracle Knowledge
Add column...
2018/01/24
Oracle Knowledge
V$SQL BIND CAPTURE...
2018/01/17
Oracle Knowledge
SWAP JOIN INPUTS...
2017/12/27
Oracle Knowledge
QB NAME...
2017/12/20
Oracle Knowledge
Print table...
2017/12/20
Oracle Knowledge
Oradebug...
2017/12/13
Oracle Knowledge
NO QUERY TRANSFORMATION...
2017/12/13
Oracle Knowledge
ITL...
2017/11/23
Oracle Knowledge
Buffer deadlock...
2017/11/01
Oracle Knowledge
Automatic Diagnostic Repository...
2017/10/25
Oracle Knowledge
V$SQL SHARED CURSOR...
2017/10/18
Oracle Knowledge
Undo Header Dump...
2017/10/18
Oracle Knowledge
Transaction...
2017/10/11
Oracle Knowledge
Show space...
2017/10/10
Oracle Knowledge
Run stats...
2017/10/04
Oracle Knowledge
Query Result Cache...
2017/10/04
Oracle Knowledge
Index Split...
2017/09/06
Oracle Knowledge
Segment Partitioning...
2017/08/30
Oracle Knowledge
FLM（Free List Management）...
2017/08/23
Oracle Knowledge
Dynamic sampling...
2017/08/16
Oracle Knowledge
Block Dump...
2017/08/09
Oracle Knowledge
Oracle Dump...
2017/07/20
Oracle パラメータ
Oracle Knowledge
OPEN CURSORS...
2019/03/22
Oracle Knowledge
OPTIMIZER CAPTURE SQL PLAN BASELINES...
2019/02/28
Oracle Knowledge
OPTIMIZER ADAPTIVE CURSOR SHARING...
2019/02/21
Oracle Knowledge
OPTIMIZER FEATURES ENABLE...
2019/02/07
Oracle Knowledge
OPTIMIZER IGNORE HINTS...
2019/01/31
Oracle Knowledge
DB CACHE ADVICE...
2019/01/25
Oracle Knowledge
OPTIMIZER COST BASED TRANSFORMATION...
2019/01/16
Oracle Knowledge
DB FILE EXEC READ COUNT...
2019/01/09
Oracle Knowledge
DB FILE OPTIMIZER READ COUNT...
2019/01/09
Oracle Knowledge
DB FILE MULTIBLOCK READ COUNT...
2018/12/26
Oracle Knowledge
OPTIMIZER SECURE VIEW MERGING...
2018/12/26
Oracle Knowledge
DDL WAIT FOR LOCKS...
2018/12/21
Oracle Knowledge
OPTIMIZER INVALIDATION PERIOD...
2018/12/12
Oracle Knowledge
OPTIMIZER TRANSITIVITY RETAIN...
2018/11/28
Oracle Knowledge
LOG BUFFER...
2018/11/28
Oracle Knowledge
Gcs log flush sync...
2018/11/21
Oracle Knowledge
DISK ASYNCH IO...
2018/11/14
Oracle Knowledge
OPTIMIZER PUSH PRED COST BASED...
2018/11/14
Oracle Knowledge
DISABLE LOGGING...
2018/10/24
Oracle Knowledge
OPTIMIZER SKIP SCAN ENABLED...
2018/10/10
Oracle Knowledge
OPTIMIZER USE SQL PLAN BASELINES...
2018/09/19
Oracle Knowledge
OPTIMIZER USE FEEDBACK...
2018/09/05
Oracle Knowledge
OPT PARAM...
2018/08/10
Oracle Knowledge
SESSION WAIT HISTORY...
2018/08/10
Oracle Knowledge
COMPLEX VIEW MERGING...
2018/07/18
Oracle Knowledge
BACKGROUND DUMP DEST...
2018/07/18
Oracle Knowledge
SESSION CACHED CURSORS...
2018/07/12
Oracle Knowledge
MINIMAL STATS AGGREGATION...
2018/07/04
Oracle Knowledge
CURSOR SPACE FOR TIME...
2018/06/14
Oracle Knowledge
B TREE BITMAP PLANS...
2018/06/14
Oracle Knowledge
ARCHIVE LAG TARGET...
2018/06/06
Oracle Knowledge
V$LOCK...
2018/06/06
Oracle Knowledge
STAR TRANSFORMATION ENABLED...
2018/05/30
Oracle Knowledge
REMOVE AGGR SUBQUERY...
2018/05/25
Oracle Knowledge
PUSH JOIN PREDICATE...
2018/05/25
Oracle Knowledge
COMMIT WRITE...
2018/05/16
Oracle Knowledge
Oracle Parameter Template...
2018/05/16
Oracle Knowledge
MAX COMMIT PROPAGATION DELAY...
2018/05/09
Oracle Knowledge
Hidden parameter...
2018/05/01
Oracle Knowledge
Global cache open x...
2018/05/01
Oracle Knowledge
Direct path read...
2018/04/25
Oracle Knowledge
CURSOR BIND CAPTURE AREA SIZE...
2018/04/18
Oracle Knowledge
CURSOR BIND CAPTURE INTERVAL...
2018/04/18
Oracle Knowledge
Bind Mismatch...
2018/04/11
Oracle Knowledge
OPTIM PEEK USER BINDS...
2018/04/05
Oracle Knowledge
FAILED LOGIN ATTEMPTS...
2018/02/08
Oracle Knowledge
WITH SUBQUERY...
2018/01/17
Oracle Knowledge
UNNEST SUBQUERY...
2018/01/10
Oracle Knowledge
Transaction internals...
2018/01/10
Oracle Knowledge
KKS USE MUTEX PIN...
2017/11/29
Oracle Knowledge
FIX CONTROL...
2017/11/15
Oracle Knowledge
PGA AGGREGATE TARGET...
2017/09/26
Oracle 性能管理 Tips
Oracle Knowledge
Oracleの待機指標とアーキテクチャーの位置づけをまとめた資料「WaitEvent_Che...
2015/08/07
Oracle Knowledge
Oracle待機イベントによるパフォーマンス・チューニングポイント(PDF)...
2015/08/07
Oracle Knowledge
Oracleの待機イベント解説 － enqueue-ST (PDF)...
2015/08/07
Oracle Knowledge
「プロが教える現場ワザ、第３弾！Oracle性能管理Tips　索引＆SQL編」 DBマガ...
2015/08/07
Oracle Knowledge
「現場の運用管理にすぐに役立つ！Oracle性能遅延解消のための特選Tips集」...
2015/08/07
Oracle Knowledge
「エキスパートが明かすOracle性能改善Tips」 DBマガジン2009年9月号掲載記事(...
2015/08/07
Oracle Knowledge
「ボトルネックを見極めて最大限の効果を狙うDB性能改善テクニック」 DB...
2015/08/07
Oracle Knowledge
「性能改善＆障害対策に効く、OWI基礎と実践」 DBマガジン2007年9月号掲載...
2015/08/07
Oracle Knowledge
OWI(Oracle Wait Interface)の概要(PDF)...
2015/08/07
お問い合わせ
エクセムラボ
facebook twitter
Oracleのsqlやセッションをツールで洩れなく収集　Oracleのことなら日本エクセム
プライバシーポリシー
会社情報
©EXEM JAPAN Corp. All Rights Reserved.