Oracle 11g
- 89 Pushing Subquery, View Merging, Pushdown 2024.02.21
- 88 Hash Join, unnest, eliminate_join, SEMI JOIN, ANTI JOIN 2024.02.20
- 87 Nested Loop Join, Sort Merge Join 2024.02.19
- 86 PGA, Sort Operation, Join, Table Prefetch, Batch I/O 2024.02.16
- 85 Row Chaining, Row Migration, B*tree, Bitmap Index, session_cached_cursors 2024.02.15
- 84 Serial direct read, Cluster Factor 2024.02.14
- 83 Explain Plan, AutoTrace, v$sql_plan, Buffer Pinning, SQL TRACE 2024.02.13
- 82 TX LOCK, Full Table Scan, Rowid Scan, Index Scan 2024.02.08 1
- Alert Log File 2024.02.07
- sqlplus 환경설정 2024.02.07
- 81 Trans, Lock, Redo, Append Hint 2024.02.07 1
- 80 Data Buffer Cache, Buffer Busy Wait, LRU, LRUW 2024.02.06 1
- 79 Shared Pool, Library Cache 2024.02.05 1
- 78 SGA, Shared Pool, Select 2024.02.02
- 77 Backup&Recovery, FBDA, RVWR, DBVerify, RMAN Validate, Offline Backup 2024.01.31