Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN:  0-9823061-2-1
ISBN13: 978-0-9823061-2-3
Library of Congress Number:
2009934294
200 pages
Perfect bind - 9x7
PD 0511
Shelving:  Databases/Oracle Oracle In-Focus Series #35

  Exploring Oracle Internals
Tips and Tricks for the Oracle DBA

Ben Prusinski

Retail Price $29.95
/  £24.95 

Order now at 30% off and get access to the code depot! Only $20.95
 
     
Key Features About the Author Table of Contents
Index Reader Comments Errata

Until now, Oracle database internals have been available previously only to internal Oracle support engineers and not available to outside of the Oracle Corporation database internals support group. This text explains hot issues for resolving the most difficult performance and recovery issues for Oracle 11g databases. It will allow the experienced Oracle professional to become an expert on how the Oracle database engine really works and provide the Oracle beginner with the solid core knowledge of the theory and practice behind the Oracle database.


Most experienced Oracle DBAs are familiar with the standard utilities found within the Oracle database server environment such as RMAN, export and import and Grid Control. However, when it comes down to how the actual database engine works under the hood, the internal workings of Oracle are poorly documented or hidden from plain view of the working DBA. Are you a senior level Oracle professional who wants to learn the secret workings of the Oracle 11g database engine to be able to solve tricky database issues?  

This timely and expert guide will cover many of the little known and undocumented features within the newest release of Oracle database for Oracle 11g. It will be a perfect capstone to mastering the keys to the kingdom of the Oracle 11g engine. Move from the average Oracle DBA to become an expert level DBA with the help of this exciting new guide from an Oracle guru! 

Topics will include a detailed discussion of the latest Oracle 11g database internals which previously have been undocumented and internal to only the Oracle server development team. In addition, tools and utilities that have been previously neglected such as how to use internal tools for database issues such as oradebug and tkprof will be explored for tuning difficult issues with the Oracle 11g database.

This book distills the very complex nature of Oracle 11g database internals using undocumented tools and features that have not been covered so that database professionals can gain mastery over solving the most difficult and challenging issues for Oracle 11g.

 
Key Features

*  Get real world advice for resolving the most difficult Oracle 11g performance and recovery issues.

 

*  Covers little known and undocumented Oracle 11g features.

 

*  Use internal tools for database issues - including oradebug and tkprof.

 

*  Take your skill level from average to expert with the help of this Oracle guru.

 

About the Author:

 
Ben Prusinski

 

Ben Prusinski has 10 years of full-time experience as a database administrator and has written numerous articles and white papers on database management. Ben is also an active member of the San Diego and Orange County Oracle and IBM DB2 User Group community, and he has published various articles for customers and user groups on data management.

Ben has been working with databases including Oracle, Microsoft SQL Server, IBM DB2 UDB, Informix, MySQL, and PostgreSQL since 1996 and has accumulated over a decade of practical knowledge and experience with complex database migrations and support on how to best achieve results with large database migrations to the Oracle platform.

Ben enjoys training in martial arts and tai chi as well as travel to exotic locations in his free time outside of working on Oracle databases.  He has traveled to over 15 countries in Latin America and Asia and has a passion for learning new foreign languages as well as cultural traditions.

Table of Contents:

 

Chapter 1:  Introduction to Oracle 11g Database Insider Secrets

 

Chapter 1:  Introduction

Chapter 2:  Oracle 11g Memory

Chapter 3:  Locks with Oracle 11g

Chapter 4:  Latches and Oracle 11g

Chapter 5:  Hidden and Undocumented Oracle 11g Parameters

Chapter 6:  Exploring V$ and the Oracle 11g Data Dictionary

Chapter 7:  X$ Tables for Oracle 11g

Appendices

New Features Overview for Oracle 11g Release

New Feature:  Invisible Index

Partitioning New Features

System Partitioning

Interval Partitioning

Virtual Column Based Partitioning

Reference Partitioning

New Feature:  Active Data Guard

New Feature: ADR Monitoring Tools

Automatic Memory Management

Oracle 11g Internals Summary

The Oracle 11g Kernel Architecture

Undocumented Tools

Poorly Documented Tools

Summary

 

Chapter 2:  Oracle 11g Database Insider Secrets:  Memory

 

Oracle 11g Memory

Oracle 11g Database Architecture

Inside the Oracle 11g System Global Area (SGA)

Automatic Memory Management (AMM)

Oracle 11g Advisors for SGA and PGA Memory

Shared Pool

Streams Pool

Large Pool

Java Pool

Other Components Within the Oracle 11g SGA

Inside the Oracle 11g Program Global Area (PGA)

Semaphores and Oracle 11g

Mutexes and Oracle 11g

Wait Events and Mutexes for Oracle 11g

How Mutexes in Oracle 11g Differ from Operating System Mutexes

Windows Memory and Threads and Oracle 11g

UNIX and Linux Shared Memory and Oracle 11g

Stack Traces for Oracle 11g Shared Memory

Understanding the Oracle 11g Memory Call Stack

Summary

 

Chapter 3:  Insider Secrets:  Locks and Oracle 11g

 

Introduction

What Are Locks?

Database Isolation Levels and Serialization for Transactions

Types of Locks within Oracle 11g

DML Locks

Lock Management and Escalation

Lock Management for Oracle RAC Environments

Locking Mechanism for Oracle 11g RAC

Enhancements to Lock Management with Oracle 11g

Serializing Locks with Oracle 11g

Locking Tables Explicitly

Useful Tips and Tricks for Locking Problems

Oracle 11g Database Waits: Insufficient  ITL Slots

Avoiding Deadlock Conditions

Lock Contention Issues and Solutions

Summary

 

Chapter 4:  Insider Secrets:  Latches

 

What are Latches?

How Do Latches Work with Oracle 11g?

Types of Latches within Oracle 11g

Exploring Latches with Dynamic Performance Views

How Latches Differ From Locks

Tips for Latch Contention Issues with Oracle 11g

Tuning Latch Contention Issues for LRU Chain Latches

Additional Tips for Tuning Oracle 11g Latches

Summary

 

Chapter 5:  Hidden Parameters in Oracle 11g

 

Purpose of Hidden Parameters for Oracle 11g

How to Locate Hidden Parameters for Oracle 11g

Explanation of Key Hidden Parameters for Oracle 11g

New Features for 11g and Hidden Parameters

Summary

 

Chapter 6:  Exploring New v$ Tables in Oracle 11g

 

New Features for the v$ Tables and Oracle 11g Data Dictionary

Purpose of v$ Views for Oracle 11g

Categories for Oracle 11g Database Administration with v$ Views

General Oracle 11g Database Administration

Performance Tuning Oracle 11g

Comprehensive Listing of Oracle 11g Dynamic v$ Performance Views

Investigating Oracle 11g Internals with V$ Views

Scripts and Tips for v$ and Data Dictionary - Oracle 11g

Summary

 

Chapter 7:  Inside the x$ Tables of Oracle 11g

 

Classification of x$ Tables

Exploring Oracle 11g Database Internals with x$ Tables

Oracle 11g New Features – Useful x$ Tables

Using the X$ Tables for Oracle 11g Analysis            

Scripts using X$ Tables with Oracle 11g

Summary

 

Book Conclusion

 

Appendix A:  Internal Tools for Oracle 11g

 

DBX

Using DBX for Debugging Oracle

Using DBX for Tracing Oracle 11g Memory Process:

Truss

 

Appendix B:  Oracle 11g Trace Events

 

Oracle 11g Database Trace Level Events

 

Appendix C:  ORA-0600 Troubleshooting

 

Appendix D:  References

 

Chapter 1: Introduction

Chapter 2: Oracle 11g Memory

Chapter 3: Database Locks

Chapter 4: Database Latches

Chapter 5: Hidden Oracle 11g Parameters

Chapter 6: V$ Views

Chapter 7: X$ Tables for 11g

Appendix A: Oracle 11g Database Internal Toolkit

Appendix B: Oracle 11g Trace Events

Appendix C: ORA-0600

Appendix E: Strace

Appendix F: Using GDB for Oracle 11g

Appendix G: Orakill for Windows and Oracle 11g

 

Appendix E:  Using Strace

 

Strace for Oracle 11g and Linux

Command Options for Strace with Linux for Oracle 11g

 

Appendix F:  Using GDB with Oracle 11g

 

Introduction to GDB with Oracle 11g

Oracle 11g Trace Stack with GDB

 

Appendix G:  Orakill for Windows

 

Orakill for Windows

  

Index:

$
$database_block_corruption          
   

/
/dev/shm         

_
_diag_hm_tc_enabled
_hang_detection
_hang_resolution
_hm_analysis_oradebug_node_dump_level
_hm_analysis_output_disk

1
11g ASM
11g Concurrency and SQL Tuning
11g Data Guard
11g Health Monitor
11g Memory Tuning             
11g Streams
11gRAC

A
ACID model
ADR Memory Monitor
adrci
adrci> show home
alert.log 
alert.log file
alter index…invisible
alter index…visible              
archive control latches
attach
Automatic Diagnostic Database Monitor
Automatic Diagnostic Repository
automatic segment space management             
Automatic Workload Repository

B
background_dump_dest
Backup and Recovery
block media recovery
bt

C
cache buffers chain latch
cache buffers LRU chain latch            
catalog.sql
catldr.sql               
core_dump_dest
Cost Based Optimizer
cpu_count
cursor:mutex
cursor:pin             

D
data dictionary
data dictionary cache
Data Guard
Data Recovery Advisor
database buffer cache
database locks
db_block_buffers
db_block_hash_buckets
db_block_lru_latches
db_block_size
db_cache_size
dba_extents
dba_hist_latch
dba_objects.object_id
dba_segments
dbms_repair
dbms_xplan
DBVERIFY
DBWR
DBX
ddl_lock_timeout
deadlock
diag_adr_auto_purge
diag_adr_enabled
diag_adr_test_param
diag_hm_rc_enabled
diagnostic_dest
dirty reads
DML locks
dra_bmr_number_threshold
dra_bmr_percent_threshold
dra_enable_offline_dictionary
dumpsga               

E
EM Support Workbench
Enterprise Manager             
exclusive               
explicit locking

F
fk_empno              
flashback memory buffer
fuzzy reads

G
GDB       
global cache services
global enqueue services
global lock conflicts
gv$dlm_latch
gv$latch
gv$lock 
gv$resource       

H
health monitor
help
help extended
hm_analysis_oradebug_sys_dump_level

I
index-organized tables
initrans  
interested transaction list    
interprocess communication model
interval partitioning
invisible index
ipc
ipcs
ips create package               
ips show       

J
Java pool buffer    

K
Kernal Database Layers       
Kernel Access
Kernel Cache
Kernel Compilation              
Kernel Data
Kernel Distributed Transaction
Kernel Execution
Kernel Generic
Kernel Locking
Kernel Query
Kernel Security
Kernel Services
Kernel Transactions
kgl_latch_count
kgllkreq 
kglnaobj

L
large pool buffer
large_pool_size
latch contention issues
latch hit ratio
latch request mode              
latch_wait_posting               
latches
Latches
level
library cache
library cache latch
local lock conflicts
Locally Managed Tablespaces
lock escalation
lock table               
locks
log.xml  
log_buffer              
log_small_entry_max_size
long wait latches
LRU
LRU chain latches

M
Maximum Availability Architecture
maxtrans               
memory management
Memory Management Units
memory_max_target
memory_target
mutex
mutex_type
mutexes 

N
Network Attached Storage
NFS configuration
nowait
no-wait mode
null         

O
optimizer_use_invisible_indexes
ORA-0600
Oracle Call Interface
Oracle SGA
Orakill    

P
pct_free 
pct_used               
pga_aggregate_target
pga_target
phantom reads
physical address area
pk_emp invisible
pmap
PMON process
Program Global Area
prop_old_enabled               
pstack

Q
qslice.exe              
Quickslice             

 

R
Recovery Manager               
redo allocation latches
Redo copy latch   
redo copy latches
redo log buffer      
reference partitioning
reference_emp
result cache
row cache objects latch
row exclusive
row share              
row-level locks

S
serialization mechanisms
sga_max
sga_max_size
sga_target
share
share locks
share row exclusive
shared pool
shared pool latches             
Short wait latches
show alert
spin count
spin_count
SQL*Plus               
SQL*Plus interface               
statistics_level
Storage Area Network
Strace tool
Streams Pool
streams_pool_size               
SYS level privileges             
sysresv  
System Global Area
system partitioning              

T
table locks
Trace Level Events
transaction locks
Truss

U
undocumented parameters
User Program Interface
user_dump_dest
user_part_tables
user_tab_partitions

V
v$ dynamic performance views
v$ views
v$db_cache_advice
v$diag_info
v$fixed_table
v$fixed_view_definition
v$ir_repair
v$java_pool_advice
v$javapool
v$latch   
v$latchholder
v$latchname
v$library_cache_memory
v$librarycache      
v$lock    
v$memory_dynamic_components
v$memory_target_advice
v$mutex_sleep      
v$mutex_sleep_history        
v$pgastat
v$rowcache
v$segment_statistics           
v$sga_target_advice            
v$shared_pool_advice        
v$streams_pool_advice      
virtual     
virtual column based partitioning       

W
wait events
willing-to-wait request mode
Windows Virtual Memory Manager

X
x$ tables
x$dbgalertext
x$dbgdirext
x$diag_info
x$ir_repair_option
x$kcbfwait
x$kgllk   
x$kglpn
x$kq       
x$kqfvi   
X$KS      
x$ksmsp
x$ksppi 
x$kzspr  
x$kzsrt   

Y
yearly_sal

Reviews:

From the series Editor:

Errata:

 

Hit Counter

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks