Performance Tuning By Example|Powerpoint模板

Performance Tuning By Example

How to use oracle 
Know The database
How Oracle Store the data
How Oracle Access the data
How Oracle manage concurrency
How Oracle Do Select/DML
Know the application
How application use the data
Store/Manage the data as it is used
How oracle store the data
Data is stored in tables
Heap table (Most commonly used)
Partitioned table
Index organized table
Cluster
Hash Cluster
Index
Materialized View
External Tables
How oracle access the data
Single Table Access Path
Full Table Scan
ROWID unique scan
Index unique scan
Index range scan
Index (fast) full scan
Bitmap Index
Index and-equal
Table Join
Hash Join
Nested loop join
Sort-merge join

How oracle manage concurrency
Row Level Lock
SCN(System Change Number) and rollback segment
Readers don’t block writers
Writers don’t block readers
Writers don’t block writers (not the same row) --Row Level Lock
Support tens of thousands of users