Index
A
- adaptive cursor sharing
- for bind variable peeking / Introducing Adaptive Cursor Sharing for bind variable peeking, How to do it..., How it works..., There's more...
- about / There's more...
- ADDM
- about / Analyzing data using Automatic Database Diagnostic Monitor (ADDM)
- used, for analyzing data / Analyzing data using Automatic Database Diagnostic Monitor (ADDM), Getting ready, How it works..., There's more..., See also
- running, in database mode / How to do it...
- running, in partial mode / How to do it...
- ADMINISTER SQL MANAGEMENT OBJECT privilege / Getting ready
- Advice button / How to do it...
- alert log
- used, for diagnosing performance issues / Diagnosing performance issues using the alert log, How it works...
- ALL_OBJECTS view / ALL_OBJECTSALL_OBJECTS view
- ALL_ROWS / There's more...
- ALTER INDEX REBUILD command / There's more...
- ALTER OUTLINE statement / There's more...
- ALTER SYSTEM FLUSH SHARED_POOL command / There's more...
- ANALYZE command / How it works...
- ANALYZE_DATABASE procedure / Procedures
- ANALYZE_DB procedure / Procedures
- ANALYZE_INST procedure / Procedures
- ANALYZE_SCHEMA procedure / Procedures
- anti-join query / How it works...
- APPEND / There's more...
- APPEND procedure / Procedures
- array processing
- about / Array processing and bulk-collect
- demonstrating / How to do it...
- working / How it works..., There's more...
- arrays
- about / Introducing arrays and bulk operations
- used for inserting data, in tables / How to do it..., How it works...
- direct path load, using / When to use direct path load
- asynchronous I/O
- about / Using asynchronous I/O
- using / How to do it..., How it works..., There's more...
- working / How it works...
- FILESYSTEMIO_OPTIONS parameter / There's more...
- AUTOALLOCATE option / Optimal storage parameters for temporary tablespaces
- Automatic Database Diagnostic Monitor / There's more…
- Automatic Memory Management (AMM) / How to do it...
- Automatic Memory Management enhancement / There's more...
- AUTOMATIC policy
- about / How it works...
- Automatic Segment Space Management (ASSM) / PctFree, PctUsed, and FREELISTs
- AWR
- used, for analyzing data / Analyzing data using Automatic Workload Repository (AWR), How to do it..., How it works...
B
- B-Tree Index / There's more...
- index entries / There's more...
- leaf nodes / There's more...
- batch processing
- about / Batch processing
- BEFORE INSERT trigger / How it works...
- BIG_ROWS table / How it works...
- bind variable peeking
- adaptive cursor sharing / Introducing Adaptive Cursor Sharing for bind variable peeking, How to do it..., How it works..., There's more...
- bind variables
- using / Using bind variables
- testing / How to do it...
- working / How it works..., How it works..., There's more...
- security / Security issues
- about / Using bind variables and parsing, How to do it...
- used, for minimizing latches / Minimizing latches using bind variables, How to do it..., How it works..., There's more...
- BIND_VARIABLE procedure / Procedures
- bitmap indexes
- using / Using bitmap indexes, How to do it...
- working / How it works...
- FULL TABLE SCAN operation / How it works...
- CUST_GENDER column / There's more...
- bitmap join index / Bitmap join index
- bitmap join index / Bitmap join index
- BLOB field / There's more...
- BROKEN procedure / Procedures
- Buffer Cache hit ratio / How it works...
- buffer cacher
- tuning / Tuning the Buffer Cache
- tuning, steps / How to do it...
- working / How it works...
- KEEP buffer cache / How it works...
- Buffer Cache hit ratio / How it works...
- KEEP pool / There's more...
- RECYCLE pool / There's more...
- bulk-collect
- about / Array processing and bulk-collect
- working / How it works..., There's more...
C
- CACHE (table_name) / There's more...
- Cache buffers (LRU) chain latches / There's more...
- checkpoint
- about / Tuning checkpoints
- tuning / How to do it...
- working / How it works...
- checkpoint queue / There's more...
- checkpoint queue / There's more...
- CHUNK parameter / There's more...
- CLEAR_USED procedure / Procedures
- client-side result cache
- used, for caching results / Caching results with the client-side result cache, Getting ready, How it works..., There's more...
- configuring / Configuring the client-side result cache, See also
- CLIENT_RESULT_CACHE_LAG / Configuring the client-side result cache
- CLIENT_RESULT_CACHE_SIZE / There's more...
- CLIENT_RESULT_CACHE_SIZE parameter / Getting ready, How it works...
- CLOSE procedure / Procedures
- CLOSE_CURSOR procedure / Procedures
- cluster
- about / Using index clusters
- size / Cluster size
- index / Cluster index
- and truncating / Clustering and truncating
- CLUSTER (table_name) / There's more...
- clusters / There's more...
- CL_DEPARTMENTS table / How it works...
- CL_EMPLOYEES table / How it works...
- composite partitioning / Composite partitioning
- COMPRESS parameter / There's more...
- COND_FIELD parameters / There's more...
- configuration, temporary tablespaces / How to do it...
- connection management
- optimizing / Optimizing connection management
- optimizing, steps / How to do it...
- working / How it works...
- dedicated server versus shared server / Dedicated server versus shared server
- control file / How it works...
- control parameter / How it works...
- COUNT() function / How it works...
- COUNT(*) function / How it works...
- COUNTRY_ID attribute / How it works...
- CREATE CLUSTER statement / Custom hash function
- CREATE INDEX command / There's more...
- create table
- using, as select / Using create table as select, How it works...
- CREATE TABLE AS SELECT statement / How it works...
- CREATE_BASELINE procedure / Procedures
- CREATE_EDIT_TABLES procedure / Procedures
- CREATE_INDEX_COST procedure / Procedures
- CREATE_SNAPSHOT procedure / Procedures
- CREATE_SQLSET procedure / Procedures
- CREATE_STAT_TABLE procedure / How it works..., Procedures
- CREATE_TABLE_COST procedure / Procedures
- CREATE_TUNING_TASK procedure / How it works..., Procedures
- CROSSCHECK COPY command / How it works...
- cursor management, performance issues / Poorly designed cursor management
- CURSOR_SHARING, parameter / Poorly designed cursor management
- CURSOR_SHARING parameter / How to minimize misses
- about / See also
- CUSTOMERS table / How to do it...
- CUSTOMERS_YOB_BIX bitmap index / How it works..., How it works...
- c_file BLOB field / There's more...
D
- data
- acquiring, data dictionary used / Acquiring data using a data dictionary and dynamic performance views, How it works..., There's more...
- analyzing, Statspack report used / Analyzing data using Statspack reports, How to do it..., How it works...
- collecting / Collecting different amounts of data
- analyzing, AWR used / Analyzing data using Automatic Workload Repository (AWR), How to do it..., How it works...
- analyzing, ADDM used / Analyzing data using Automatic Database Diagnostic Monitor (ADDM), Getting ready, How it works..., There's more..., See also
- loading, SQL*Loader used / Loading data with SQL*Loader and Data Pump, Getting ready, How it works..., There's more...
- loading, data pump used / Loading data with SQL*Loader and Data Pump, Getting ready, How it works..., There's more...
- database
- sort operations, managing / There's more...
- database memory architecture
- about / There's more...
- database request
- reducing, stored procedures used / Reducing the number of requests to the database using stored procedures, How to do it..., How it works...
- reducing, sequences used / Reducing the number of requests to the database using sequences, How to do it..., How it works..., There's more...
- reducing, materialized views used / Reducing the number of requests to the database using materialized views, How it works...
- data compression / There's more...
- data dictionary
- used, for acquiring data / Acquiring data using a data dictionary and dynamic performance views, How it works..., There's more...
- datafile parameter / Getting ready
- Data Manipulation Language (DML) / Introduction
- data pump
- used, for loading data / Loading data with SQL*Loader and Data Pump, Getting ready, How it works..., There's more...
- URL / There's more...
- DBA_BLOCKERS dynamic performance view / How it works...
- DBA_BLOCKERS view / DBA_BLOCKERSDBA_BLOCKERS view
- DBA_DATA_FILES view / DBA_DATA_FILESDBA_DATA_FILES view
- DBA_EXTENTS view / DBA_EXTENTSDBA_EXTENTS view
- DBA_INDEXES view / DBA_INDEXESDBA_INDEXES view
- DBA_SEQUENCES view / DBA_SEQUENCESDBA_SEQUENCES view
- DBA_SQL_PLAN_BASELINES view / DBA_SQL_PLAN_BASELINESDBA_SQL_PLAN_BASELINES view
- DBA_TABLES dictionary view / How it works...
- DBA_TABLESPACES view / DBA_TABLESPACESDBA_TABLESPACES view
- DBA_TABLES view / DBA_TABLESDBA_TABLES view, Fields
- DBA_TAB_HISTOGRAMS view / DBA_TAB_HISTOGRAMSDBA_TAB_HISTOGRAMS view, Fields
- DBA_TEMP_FILES view / DBA_TEMP_FILESDBA_TEMP_FILES view
- DBA_VIEWS view / DBA_VIEWS
- DBA_WAITERS dynamic performance view / How it works...
- DBA_WATERS view / DBA_WAITERSdynamic performance viewsDBA_WAITERSDBA_WATERS view, See also
- DBMS_ADDM package
- about / DBMS_ADDM
- procedures / Procedures
- ANALYZE_DB procedure / Procedures
- ANALYZE_INST procedure / Procedures
- GET_REPORT procedure / Procedures
- DBMS_ADVISOR package
- procedures / Procedures
- SET_DEFAULT_TASK_PARAMETER procedure / Procedures
- QUICK_TUNE procedure / Procedures
- EXECUTE_TASK procedure / Procedures
- DBMS_JOB package
- procedures / DBMS_JOB
- SUBMIT procedure / Procedures
- RUN procedure / Procedures
- NEXT_DATE procedure / Procedures
- BROKEN procedure / Procedures
- REMOVE procedure / Procedures
- DBMS_LOB package
- procedures / Procedures
- GET_LENGTH procedure / Procedures
- FILEOPEN procedure / Procedures
- LOADFROMFILE procedure / Procedures
- APPEND procedure / Procedures
- OPEN procedure / Procedures
- READ procedure / Procedures
- WRITE procedure / Procedures
- CLOSE procedure / Procedures
- DBMS_MVIEW package
- procedures / Procedures
- EXPLAIN_MVIEW procedure / Procedures
- EXPLAIN_REWRITE procedure / Procedures
- REFRESH procedure / Procedures
- REFRESH_ALL_MVIEWS procedure / Procedures
- DBMS_OUTLN package
- procedures / Procedures
- CLEAR_USED procedure / Procedures
- DROP_BY_CAT procedure / Procedures
- UPDATE_BY_CAT procedure / Procedures
- DROP_UNUSED procedure / Procedures
- DBMS_OUTLN_EDIT package
- procedures / Procedures
- CREATE_EDIT_TABLES procedure / Procedures
- REFRESH_PRIVATE_OUTLINE procedure / Procedures
- DROP_EDIT_TABLES procedure / Procedures
- DBMS_SHARED_POOL package / How it works...
- procedures / Procedures
- KEEP procedure / Procedures
- UNKEEP procedure / Procedures
- PURGE procedure / Procedures
- SIZES procedure / Procedures
- DBMS_SPACE package / Estimating table size with different PCTFREE parameter
- procedures / Procedures
- CREATE_TABLE_COST procedure / Procedures
- CREATE_INDEX_COST procedure / Procedures
- FREE_BLOCKS procedure / Procedures
- SPACE_USAGE procedure / Procedures
- DBMS_SPM.MIGRATE_STORED_OUTLINE procedure / How it works...
- DBMS_SPM package
- procedures / Procedures
- LOAD_PLANS_FROM_CURSOR_CACHE procedure / Procedures
- LOAD_PLANS_FROM_SQLSET procedure / Procedures
- EVOLVE_SQL_PLAN_BASELINE procedure / Procedures
- DROP_SQL_PLAN_BASELINE procedure / Procedures
- DBMS_SQL package
- procedures / Procedures
- EXECUTE procedure / Procedures
- OPEN_CURSOR procedure / Procedures
- PARSE procedure / Procedures
- BIND_VARIABLE procedure / Procedures
- CLOSE_CURSOR procedure / Procedures
- DBMS_SQLTUNE package / How it works...
- procedures / Procedures
- CREATE_SQLSET procedure / Procedures
- DROP_SQLSET procedure / Procedures
- SELECT_SQLSET procedure / Procedures
- LOAD_SQLSET procedure / Procedures
- SELECT_CURSOR_CACHE procedure / Procedures
- CREATE_TUNING_TASK procedure / Procedures
- EXECUTE_TUNING_TASK procedure / Procedures
- REPORT_TUNING_TASK procedure / Procedures
- INTERRUPT_TUNING_TASK procedure / Procedures
- RESUME_TUNING_TASK procedure / Procedures
- DBMS_STATS.GATHER_SCHEMA_STATS procedure / How it works...
- DBMS_STATS.IMPORT_SCHEMA_STATS procedure / How it works...
- DBMS_STATS package / How it works...
- procedures / Other procedures in DBMS_STATS, Procedures
- about / Other procedures in DBMS_STATS
- GATHER_SCHEMA_STATS procedure / Procedures
- GATHER_DATABASE_STATS procedure / Procedures
- GATHER_TABLE_STATS procedure / Procedures
- GATHER_INDEX_STATS procedure / Procedures
- CREATE_STAT_TABLE procedure / Procedures
- DROP_STAT_TABLE procedure / Procedures
- EXPORT_SCHEMA_STATS procedure / Procedures
- IMPORT_SCHEMA_STATS procedure / Procedures
- DBMS_UTILITY function / How it works...
- DBMS_UTILITY package
- procedures / Procedures
- ANALYZE_SCHEMA procedure / Procedures
- ANALYZE_DATABASE procedure / Procedures
- GET_TIME procedure / Procedures
- DBMS_WORKLOAD_REPOSITORY package
- procedures / Procedures
- CREATE_SNAPSHOT procedure / Procedures
- MODIFY_SNAPSHOT_SETTINGS procedure / Procedures
- CREATE_BASELINE procedure / Procedures
- DBW0 (DB Writer) process / How it works...
- deadlocks
- about / Investigating transactions and concurrency, How it works..., There's more...
- UPDATE statement / How it works...
- dedicated server versus shared server / Dedicated server versus shared server
- DELETE operation / There's more...
- DELETE_SCHEMA_STATS procedure / How it works...
- denormalization / There's more...
- DENSE_RANK() function / How to do it..., How it works...
- dictionary cache
- tuning / Tuning the Dictionary Cache
- V$ROWCACHE dynamic performance / Tuning the Dictionary Cache
- direct I/O / How it works...
- direct path inserting
- DISTINCT keyword / There's more...
- DMBS_STATS procedure / Lock table statistics for load or highly volatile tables
- DROP_BY_CAT procedure / There's more..., Procedures
- DROP_EDIT_TABLES procedure / Procedures
- DROP_SQLSET procedure / Procedures
- DROP_SQL_PLAN_BASELINE procedure / Procedures
- DROP_STAT_TABLE procedure / Procedures
- DROP_UNUSED procedure / There's more..., Procedures
- dynamic performance views
- about / Acquiring data using a data dictionary and dynamic performance views, How it works..., There's more...
- ALL_OBJECTS / ALL_OBJECTSALL_OBJECTS view
- DBA_BLOCKERS / DBA_BLOCKERSDBA_BLOCKERS view
- DBA_DATA_FILES / DBA_DATA_FILESDBA_DATA_FILES view
- DBA_EXTENTS / DBA_EXTENTSDBA_EXTENTS view
- DBA_INDEXES / DBA_INDEXESDBA_INDEXES view, Fields
- DBA_SQL_PLAN_BASELINES / DBA_SQL_PLAN_BASELINESDBA_SQL_PLAN_BASELINES view
- DBA_TABLES / DBA_TABLESDBA_TABLES view
- DBA_TEMP_FILES / DBA_TEMP_FILESDBA_TEMP_FILES view, Fields
- DBA_VIEWS / DBA_VIEWS
- DBA_WAITERS / DBA_WAITERSdynamic performance viewsDBA_WAITERSDBA_WATERS view
- INDEX_STATS / INDEX_STATSINDEX_STATS view
- DBA_SEQUENCES / DBA_SEQUENCESDBA_SEQUENCES view
- DBA_TABLESPACES / DBA_TABLESPACESDBA_TABLESPACES view
- DBA_TAB_HISTOGRAMS / DBA_TAB_HISTOGRAMSDBA_TAB_HISTOGRAMS view, Fields
- V$ADVISOR_PROGRESS / V$ADVISOR_PROGRESSV$ADVISOR_PROGRESS view
- V$BUFFER_POOL_STATISTICS / V$BUFFER_POOL_STATISTICSV$BUFFER_POOL_STATISTICS view, Fields
- V$CONTROLFILE / V$CONTROLFILEV$CONTROLFILE view
- V$DATAFILE / V$DATAFILEV$DATAFILE view
- V$DB_CACHE_ADVICE / V$DB_CACHE_ADVICEdynamic performance viewsV$DB_CACHE_ADVICEV$DB_CACHE_ADVICE view
- V$DB_OBJECT_CACHE / V$DB_OBJECT_CACHEdynamic performance viewsV$DB_OBJECT_CACHEV$DB_OBJECT_CACHE view
- V$ENQUEUE_LOCK / V$ENQUEUE_LOCKdynamic performance viewsV$ENQUEUE_LOCKV$ENQUEUE_LOCK view
- V$FILESTAT / V$FILESTATdynamic performance viewsV$FILESTATV$FILESTAT view
- V$FIXED_TABLE / V$FIXED_TABLEdynamic performance viewsV$FIXED_TABLEV$FIXED_TABLE view
- V$INSTANCE_RECOVERY / V$INSTANCE_RECOVERYdynamic performance viewsV$INSTANCE_RECOVERYV$INSTANCE_RECOVERY view
- V$LATCH / V$LATCHdynamic performance viewsV$LATCHV$LATCH view
- V$LATCH_CHILDREN / V$LATCH_CHILDRENdynamic performance viewsV$LATCH_CHILDRENV$LATCH_CHILDREN view
- V$LIBRARYCACHE / V$LIBRARYCACHEdynamic performance viewsV$LIBRARYCACHEV$LIBRARYCACHE view
- V$LOCK / V$LOCKdynamic performance viewsV$LOCKV$LOCK view
- V$LOCKED_OBJECT / V$LOCKED_OBJECTV$LOCKED_OBJECT viewdynamic performance viewsV$LOCKED_OBJECT
- V$LOG / V$LOGdynamic performance viewsV$LOGV$LOG view
- V$LOG_HISTORY / V$LOG_HISTORYdynamic performance viewsV$LOG_HISTORYV$LOG_HISTORY view
- V$LOGFILE / V$LOGFILEdynamic performance viewsV$LOGFILEV$LOGFILE view
- V$MYSTAT / V$MYSTATdynamic performance viewsV$MYSTATV$MYSTAT view
- V$PROCESS / V$PROCESSdynamic performance viewsV$PROCESSV$PROCESS view
- V$ROLLSTAT / V$ROLLSTATdynamic performance viewsV$ROLLSTATV$ROLLSTAT view
- V$ROWCACHE / V$ROWCACHEdynamic performance viewsV$ROWCACHE$ROWCACHE view
- V$SESSION / V$SESSIONdynamic performance viewsV$SESSIONV$SESSION view, Fields
- V$SESSION_EVENT / V$SESSION_EVENTdynamic performance viewsV$SESSION_EVENTV$SESSION_EVENT view, See also
- V$SESSTAT / V$SESSTATdynamic performance viewsV$SESSTATV$SESSTAT view
- V$SGA / V$SGAdynamic performance viewsV$SGAV$SGA view
- V$SGAINFO / V$SGAINFOdynamic performance viewsV$SGAINFOV$SGAINFO view
- V$SHARED_POOL_RESERVED / V$SHARED_POOL_RESERVEDdynamic performance viewsV$SHARED_POOL_RESERVEDV$SHARED_POOL_RESERVED view
- V$SORT_SEGMENT / V$SORT_SEGMENTdynamic performance viewsV$SORT_SEGMENTV$SORT_SEGMENT view
- V$SQL / V$SQLdynamic performance viewsV$SQLV$SQL view
- V$SQL_PLAN / V$SQL_PLANdynamic performance viewsV$SQL_PLANV$SQL_PLAN view
- V$SQLAREA / V$SQLAREAdynamic performance viewsV$SQLAREAV$SQLAREA view
- V$STATNAME / V$STATNAMEdynamic performance viewsV$STATNAMEV$STATNAME view
- V$SYSSTAT / V$SYSSTATdynamic performance viewsV$SYSSTATV$SYSSTAT view
- V$SYSTEM_EVENT / V$SYSTEM_EVENTdynamic performance viewsV$SYSTEM_EVENTV$SYSTEM_EVENT view
- V$TEMPFILE / V$TEMPFILEdynamic performance viewsV$TEMPFILEV$TEMPFILE view
- V$TEMPSTAT / V$TEMPSTATdynamic performance viewsV$TEMPSTATV$TEMPSTAT view
- V$WAITSTAT / V$WAITSTATdynamic performance viewsV$WAITSTATV$WAITSTAT view
- X$BH / X$BHdynamic performance viewsX$BHX$BH view
- dynamic sampling
- about / There's more...
- dynamic SQL
- avoiding / Avoiding dynamic SQL
- avoiding, steps / How to do it..., How it works..., There's more...
E
- EMP_DEPARTMENT_IX index / How it works...
- EMP_DEPT_CLUSTER cluster / How it works...
- ENDPOINT_VALUE / How it works...
- ESTIMATE_PERCENT parameter / How it works...
- estimator
- about / Introduction
- EVOLVE_SQL_PLAN_BASELINE procedure / How it works..., Procedures
- example database
- exploring / Exploring the example database
- preparing, steps / How to do it...
- working / How it works...
- EXECUTE procedure / Procedures
- EXECUTE_TASK procedure / Procedures
- EXECUTE_TUNING_TASK procedure / Procedures
- EXPLAIN_MVIEW procedure / Procedures
- EXPLAIN_REWRITE procedure / Procedures
- EXPORT_SCHEMA_STATS procedure / How it works..., Procedures
- external table / How it works...
F
- Fast-Start checkpointing / How it works...
- FAST_START_MTTR_TARGET parameter / How it works...
- FILEOPEN procedure / Procedures
- FILESYSTEMIO_OPTIONS parameter / There's more...
- filters
- using, in group-by queries / Using count, min/max, and group-by, How it works...
- FIRST_ROWS (n) / There's more...
- FORALL statement / How it works...
- FORCE mode / There's more...
- FOR EACH ROW
- avoiding, in triggers / Avoid FOR EACH ROW in triggers, when possible
- FREE_BLOCKS procedure / Procedures
- FULL (table_name) / There's more...
- full table scan
- avoiding / Avoiding full table scans, How to do it...
- working / How it works...
- FULL TABLE SCAN operation / How it works...
- function-based index / How it works...
- function inlining technique / How it works...
- function result cache
- about / Taking advantage of function result cache
- using / How to do it...
- working / How it works...
G
- GATHER_DATABASE_STATS procedure / Procedures
- GATHER_INDEX_STATS procedure / Procedures
- GATHER_SCHEMA_STATS procedure / Procedures
- GATHER_TABLE_STATS procedure / Procedures
- GET_LENGTH procedure / Procedures
- GET_REPORT procedure / Procedures
- GET_TIME procedure / Procedures
- group-by queries
- filters, using in / Using count, min/max, and group-by, How it works...
- GROUP BY query / How to do it...
H
- HASH (table_name) / There's more...
- hash clusters
- about / Using hash clusters
- using / Using hash clusters, How to do it...
- working / How it works...
- EMP_DEPT_CLUSTER cluster / How it works...
- CL_DEPARTMENTS table / How it works...
- CL_EMPLOYEES table / How it works...
- EMP_DEPARTMENT_IX index / How it works...
- TABLE ACCESS HASH operation / How it works...
- HASHKEYS parameters / There's more...
- sorted / Sorted hash clusters
- custom hash function / Custom hash function
- CREATE CLUSTER statement / Custom hash function
- single-table / Single-table hash clusters
- HASH GROUP BY operation / There's more...
- HASHKEYS parameters / There's more...
- hash partitioning / Hash partitioning
- HASH UNIQUE operation / There's more...
- HAVING clause / How to do it..., How it works...
- height-based histograms / Height-based and value-based (frequency) histograms
- High-Water Mark (HWM)
- about / The High-Water Mark
- resetting / The High-Water Mark
- High-Water Mark (HWM), resetting
- TRUNCATE / The High-Water Mark
- ALTER TABLE MOVE / The High-Water Mark
- EXPORT + DROP + IMPORT / The High-Water Mark
- histograms
- about / Using histograms
- working / How it works...
- ENDPOINT_VALUE / How it works...
- skewed values / There's more...
- height-based histograms / Height-based and value-based (frequency) histograms
- value-based histograms / Height-based and value-based (frequency) histograms
- home directory / Getting ready
- hugepages / There's more...
I
- I/O performance issues
- ID field / How it works...
- ID value / How it works...
- immediate latch requests / There's more...
- IMPORT_SCHEMA_STATS procedure / Procedures
- in-memory sort operation
- versus on-disk sort operation / Getting ready, How to do it..., How it works...
- INCLUDING option / INCLUDING, OVERFLOW, PCTTHRESHOLD
- INDEX (table_name index_name) / There's more...
- index clusters
- using / Using index clusters, How to do it...
- COUNTRY_ID attribute / How it works...
- Multi-Table Index Cluster Tables / There's more...
- index entries / There's more...
- indexes
- about / Indexing the correct way
- using / How to do it...
- working / How it works...
- function-based index / How it works...
- UPPER function / How it works...
- B-Tree Index / There's more...
- INDEX FAST FULL SCAN / There's more...
- where condition / There's more...
- rebuilding / Rebuilding index, How to do it...
- rebuilding in offline mode, drawbacks / How it works...
- PARALLEL option / There's more...
- DELETE operation / There's more...
- INSERT operation / There's more...
- ONLINE options / There's more...
- rebuild and statistics / Index rebuild and statistics
- compressing / Compressing indexes
- compressing, steps / How to do it…, How it works...
- CREATE INDEX command / There's more...
- ALTER INDEX REBUILD command / There's more...
- COMPRESS parameter / There's more...
- prefix length / There's more...
- reverse key indexes, using / Using reverse key indexes, How to do it...
- used, for avoiding sort operations / Sorting and indexing, How it works...
- inspecting / Inspecting indexes and triggers overhead, How to do it..., How it works..., There's more...
- index lookup
- exploring / Exploring index lookup
- example / Getting ready
- steps / How to do it...
- working / How it works...
- function, using / There's more...
- NULL values, searching for / There's more...
- index range-scan
- and index skip-scan, differences / Exploring index skip-scan and index range-scan, How to do it..., How it works..., There's more...
- Index Range Scan operation / How it works...
- index skip-scan
- and index range-scan, differences / Exploring index skip-scan and index range-scan, How to do it..., How it works..., There's more...
- INDEX UNIQUE SCAN operation / How it works...
- INDEX_STATS view / INDEX_STATSINDEX_STATS view
- INSERT operation / There's more...
- INSERT statement / Introducing arrays and bulk operations, Direct path inserting
- Instance Efficiency Indicators section / How it works...
- INTERRUPT_TUNING_TASK procedure / Procedures
- INTERSECT operator / How to do it..., How it works...
- Intimate Shared Memory (ISM) / There's more...
- IOT
- about / Migrating to index organized tables, How to do it...
- PCTTHRESHOLD parameter / INCLUDING, OVERFLOW, PCTTHRESHOLD
- INCLUDING option / INCLUDING, OVERFLOW, PCTTHRESHOLD
- USER tablespace / INCLUDING, OVERFLOW, PCTTHRESHOLD
- Logical ROWID / Logical ROWID
J
- JDBC / There's more...
- JOIN operator / How it works...
- joins
- optimizing / Optimizing joins
- types / How to do it...
- working / How it works...
K
- k-combinations / How to do it...
- KEEP buffer cache / How it works...
- KEEP pool / There's more...
- KEEP procedure / Procedures
L
- Latch Activity section / How it works...
- latch contention
- minimizing, by tuning resources / Tuning resources to minimize latch contention, How it works...
- latches
- tuning / Tuning latches, How to do it...
- V$SYSTEM_EVENT dynamic performance view / How it works..., How it works..., There's more...
- TIME_WAITED column / How it works...
- latch free event / How it works...
- V$LATCH dynamic performance view / How it works...
- about / There's more...
- latch free wait event / There's more...
- willing-to-wait latch requests / There's more...
- immediate latch requests / There's more...
- Instance Efficiency Indicators section / How it works...
- Latch Activity section / How it works...
- shared pool latches / There's more...
- library cache latches / There's more...
- Cache buffers (LRU) chain latches / There's more...
- V$LATCH_CHILDREN dynamic performance view / There's more...
- redo copy latches / There's more...
- redo allocation latches / There's more...
- minimizing, bind variables used / Minimizing latches using bind variables, How to do it..., How it works..., There's more...
- WORKLOAD_NOBIND procedure / How to do it...
- WORKLOAD_BIND procedure / How to do it...
- latch free event / How it works...
- latch free wait event / There's more...
- LEADING (table_name1 table_name2 ) / There's more...
- leaf nodes / There's more...
- library cache
- tuning / Tuning the Library Cache
- tuning, steps / How to do it...
- working / How it works..., There's more...
- misses, minimizing / How to minimize misses
- CURSOR_SHARING parameter / How to minimize misses
- library cache latches / There's more...
- list partitioning / List partitioning
- LOADFROMFILE procedure / Procedures
- LOAD_PLANS_FROM_CURSOR_CACHE procedure / Procedures
- LOAD_PLANS_FROM_SQLSET procedure / Procedures
- LOAD_SQLSET procedure / Procedures
- LOBs
- using / Using LOBs, How to do it...
- working / How it works...
- BLOB field / There's more...
- c_file BLOB field / There's more...
- CHUNK parameter / There's more...
- SecureFile (s) / There's more...
- data compression / There's more...
- BLOB data, encryption / There's more...
- NOLOGGING parameters / There's more...
- lock contention
- detecting / Detecting and preventing lock contention, How it works...
- preventing / Detecting and preventing lock contention, How it works...
- V$LOCKED_OBJECT dynamic performance view / How to do it..., How it works...
- DBA_WAITERS / How to do it...
- DBA_BLOCKERS / How to do it...
- Table Level Lock / How it works...
- Row Level Lock / How it works...
- DBA_WAITERS dynamic performance view / How it works...
- DBA_BLOCKERS dynamic performance view / How it works...
- V$SESSION dynamic performance view / How it works...
- LOCK_SGA parameter / How it works...
- log file sync statistic / How it works...
- Logical ROWID / Logical ROWID
M
- MANUAL policy
- about / How it works...
- materialized views
- used, for reducing database requests / Reducing the number of requests to the database using materialized views, How it works..., Materialized views and grants
- MAX_CREDIT column / How it works...
- MAX_CREDIT field / How it works...
- MAX_CREDIT field value / How it works...
- memory
- tuning, to avoid operating system paging / Tuning memory to avoid Operating System paging, How to do it..., How it works..., There's more...
- min/max aggregates
- computing / Using count, min/max, and group-by, How it works...
- MIN/MAX query / How to do it...
- MINUS operator / How to do it...
- MODIFY_SNAPSHOT_SETTINGS procedure / Procedures
- multi-pass sort
- about / How it works..., There's more...
- Multi-Table Index Cluster Tables / There's more...
- Multi-Threaded Server (MTS) / Dedicated server versus shared server
- multiple block sizes
- advantages / There's more...
- multiple database writer slave processes / There's more...
- multiple disks
- objects, stripping / Striping objects across multiple disks, How to do it...
- MYSTATS table / How to do it...
- MY_SALES table / How it works...
N
- native compilation
- about / Using native compilation
- using / Getting ready, How to do it...
- working / How it works..., There's more..., See also
- NEXT_DATE procedure / Procedures
- NOCOPY
- parameters, passing to functions / Passing values with NOCOPY (or not), How to do it...
- working / How it works..., There's more...
- using, issues / There's more...
- NOLOGGING clause / There's more...
- NOLOGGING parameters / There's more...
- NO_INDEX (table_name index_name) / There's more...
- no_result_cache / There's more...
- NULL device / How it works...
O
- objects
- stripping, across multiple disks / How it works..., There's more...
- OF
- on-disk sort operation
- versus in-memory sort operation / Getting ready, How to do it..., How it works...
- ONLINE options / There's more...
- Online Transaction Processing (OLTP)
- OnLine Transaction Processing (OLTP) / There's more...
- OPEN procedure / Procedures
- OPEN_CURSOR procedure / Procedures
- operating system paging
- avoiding, by tuning memory / Tuning memory to avoid Operating System paging, How to do it..., How it works..., There's more...
- optimal sort / How it works...
- about / There's more...
- optimal storage parameters, temporary tablespaces / Optimal storage parameters for temporary tablespaces
- OPTIMIZER_DYNAMIC_SAMPLING parameter / There's more...
- Oracle Call Interface (OCI) / There's more...
- Oracle database
- features / There's more…
- Oracle Database Configuration Assistant (DBCA) / How to do it...
- Oracle Enterprise Manager (OEM) / There's more…
- Oracle Real Application Cluster (RAC) / How it works...
- ORDER BY clause
- about / How it works...
- ORDER BY query / How to do it...
- ORDERED / There's more...
- OTHER_SALES partition / List partitioning
- OUTLN_PKG package / There's more...
P
- package, Oracle
- DBMS_ADDM package / DBMS_ADDM
- DBMS_ADVISOR package / Procedures
- DBMS_JOB package / DBMS_JOB
- DBMS_LOB package / DBMS_LOB
- DBMS_MVIEW package / DBMS_MVIEW
- DBMS_OUTLN package / DBMS_OUTLN
- DBMS_OUTLN_EDIT package / DBMS_OUTLN_EDIT
- DBMS_SHARED_POOL package / DBMS_SHARED_POOL
- DBMS_SPACE package / DBMS_SPACE
- DBMS_SPM package / DBMS_SPM
- DBMS_SQL package / DBMS_SQL
- DBMS_SQLTUNE package / DBMS_SQLTUNE
- DBMS_STATS package / DBMS_STATS
- DBMS_UTILITY package / DBMS_UTILITY
- DBMS_WORKLOAD_REPOSITORY package / DBMS_WORKLOAD_REPOSITORY
- PARALLEL (DEFAULT | AUTO | MANUAL | n) / There's more...
- PARALLEL clause / There's more...
- PARALLEL option / There's more...
- parallel SQL
- enabling / Enabling parallel SQL
- working / How it works...
- degree of parallelism of two / There's more...
- parallel query and I/O / Parallel query and I/O
- need for / When to use parallel SQL
- PARAMETER column / Tuning the Dictionary Cache
- PARSE procedure / Procedures
- parsing
- about / Using bind variables and parsing, How to do it...
- working / How it works..., There's more...
- partitioning
- using / Using partitioning, How to do it...
- TIME_ID field / How it works...
- PARTITION KEY / How it works...
- partition pruning / There's more...
- list partitioning / List partitioning
- OTHER_SALES partition / List partitioning
- hash partitioning / Hash partitioning
- composite partitioning / Composite partitioning
- PARTITION KEY / How it works...
- partition pruning / There's more...
- PCTFREE parameter / There's more..., PctFree, PctUsed, and FREELISTs
- about / There's more...
- table size, estimating / Estimating table size with different PCTFREE parameter
- CREATE_TABLE_COST package / Estimating table size with different PCTFREE parameter
- DBMS_SPACE package / Estimating table size with different PCTFREE parameter
- PCTINCREASE parameter / Optimal storage parameters for temporary tablespaces
- PCTTHRESHOLD parameter / INCLUDING, OVERFLOW, PCTTHRESHOLD
- PCTUSED parameter / PctFree, PctUsed, and FREELISTs
- performance, optimizing
- schema denormalization used / Optimizing performance with schema denormalization, How to do it..., How it works..., There's more..., Not 1NF structures
- performance issues, Oracle database
- about / Introduction
- poor session management / Incorrect session management
- cursor management, issues / Poorly designed cursor management
- relational design, issues / Inadequate relational design
- storage structures, improper usage / Improper use of storage structures
- performance issues diagnosing, alert log used
- performance sharing
- improving, reusable code used / Improving performance sharing reusable code, How to do it...
- working / How it works...
- PL/SQL and parsing / PL/SQL and parsingperformance sharingPL/SQL and parsing
- performance tuning
- process, reviewing / Reviewing the performance tuning process, How it works...
- database, creating for examples / Exploring the example database, How to do it...
- performance tuning, example
- about / A working example
- demonstrating, SH schema used / How to do it..., There's more...
- performance tuning, process
- reviewing / Reviewing the performance tuning process
- issues, solving / How to do it...
- working / How it works..., There's more…
- PGA
- PGA (Program Global Area) / Dedicated server versus shared server
- PGA size
- about / How to do it...
- PGA_AGGREGATE_TARGET parameter / How it works..., There's more...
- PL/SQL code
- about / Inlining PL/SQL code
- inlining / How to do it...
- working / How it works...
- function inlining technique / How it works..., There's more...
- plan generator
- about / Introduction
- hints, issues / Errors in hints
- PMON (Process MONitor) proces / How it works...
- prefix length / There's more...
- private stored outlines / Private and public stored outlines, See also
- Program Global Area (PGA)
- about / There's more...
- public stored outlines / Private and public stored outlines, See also
- PURGE procedure / Procedures
Q
- query optimizer
- about / Introduction
- hints, exploring / Exploring optimizer hints, How it works..., There's more...
- query transformation
- about / Introduction
- QUICK_TUNE procedure / Procedures
R
- $ROWCACHE view / V$ROWCACHEdynamic performance viewsV$ROWCACHE$ROWCACHE view
- RAID level 0+1 / RAID level 0+1
- RAID level 5 / RAID level 5
- RAID levels
- choosing, for different Oracle files / Choosing different RAID levels for different Oracle files, Getting ready, How it works...
- working / How it works...
- RAID level 0 / RAID level 0
- RAID level 1 / RAID level 1
- RAID level 5 / RAID level 5
- RAID level 0+1 / RAID level 0+1
- RANK() function / How to do it..., How it works...
- READ procedure / Procedures
- recursive functions
- about / Avoiding recursion
- avoiding / How to do it..., There's more...
- working / How it works...
- RECYCLE pool / There's more...
- redo allocation latches / There's more...
- redo copy latches / There's more...
- redo logs
- monitoring / Tuning redo logs
- working / How it works...
- redo log switch / How it works...
- REFRESH procedure / Procedures
- REFRESH_ALL_MVIEWS procedure / Procedures
- REFRESH_PRIVATE_OUTLINE procedure / Procedures
- relational design, performance issues / Inadequate relational design
- REMOVE procedure / Procedures
- REPORT_TUNING_TASK function / How it works...
- REPORT_TUNING_TASK procedure / Procedures
- resources
- tuning, to minimize latch contention / Tuning resources to minimize latch contention, How it works...
- results
- caching, client-side result cache used / Caching results with the client-side result cache, Getting ready, How it works..., There's more...
- RESULT_CACHE option / How it works...
- RESULT_CACHE_MAX_SIZE parameter / There's more...
- RESUME_TUNING_TASK procedure / Procedures
- reusable code
- used, for improving performance sharing / Improving performance sharing reusable code, How to do it..., There's more...
- reverse key B-Tree index / How it works...
- reverse key indexes
- using / Using reverse key indexes, How to do it...
- BEFORE INSERT trigger / How it works...
- REVERSE keyword / How it works...
- reverse key B-Tree index / How it works...
- INDEX UNIQUE SCAN operation / How it works...
- TABLE ACCESS BY INDEX ROWID operation / How it works...
- REVERSE keyword / How it works...
- REWRITE (materialized_view) / There's more...
- row
- changing, avoiding / Avoiding row chaining, How to do it...
- working / How it works...
- BIG_ROWS table / How it works...
- multiple block sizes, advantages / There's more...
- migration, avoiding / Avoiding row migration, How to do it..., How it works...
- PCTFREE parameter / There's more...
- Row Level Lock / How it works...
- rows
- counting / Using count, min/max, and group-by, How it works...
- RUN procedure / Procedures
S
- schema denormalization
- used, for optimizing performance / Optimizing performance with schema denormalization, How to do it..., How it works..., There's more..., Not 1NF structures
- select
- create table, using / Using create table as select, How it works...
- SELECT DISTINCT query / How to do it...
- SELECT_CURSOR_CACHE procedure / Procedures
- SELECT_SQLSET procedure / Procedures
- session management, performance issues / Incorrect session management
- SESSION_CACHED_CURSORS
- about / There's more...
- set operations
- sort, avoiding in / Avoiding sorting in set operations: union, minus, and intersect, How to do it..., How it works...
- set operators
- about / There's more...
- set theory
- about / There's more...
- SET_DEFAULT_TASK_PARAMETER procedure / Procedures
- SGA
- about / How it works...
- shared pool
- tuning / Tuning the Shared Pool
- tuning, steps / How to do it...
- working / How it works...
- DBMS_SHARED_POOL.KEEP procedure / How it works...
- DBMS_SHARED_POOL package / How it works...
- SHARED_POOL_SIZE parameter / How it works...
- V$ROWCACHE dynamic performance / How it works...
- SHARED_POOL_RESERVED_SIZE initialization parameter / There's more...
- ALTER SYSTEM FLUSH SHARED_POOL command / There's more...
- SIZES procedure / There's more...
- V$SHARED_POOL_ADVICE dynamic performance / There's more...
- shared pool latches / There's more...
- SHARED_POOL_RESERVED_SIZE initialization parameter / There's more...
- SHARED_POOL_SIZE parameter / How it works...
- short-circuit IF statements
- about / Using short-circuit IF statements
- using, steps / How to do it...
- working / How it works..., There's more...
- SH schema / Getting ready, How to do it...
- SIMPLE_FUNCTION function / How to do it...
- single-pass sort
- about / How it works..., There's more...
- SIZES procedure / There's more..., Procedures
- skewed values / There's more...
- SORT GROUP BY operation / There's more..., How it works...
- sorting
- about / Introduction
- avoiding, in set operations / Avoiding sorting in set operations: union, minus, and intersect, How to do it..., How it works...
- SORT operation / There's more...
- sort operations
- managing / There's more...
- avoiding, indexes used / Sorting and indexing, How it works...
- SORT UNIQUE operation / There's more..., How it works...
- SORT_AREA_SIZE parameter / Optimal storage parameters for temporary tablespaces
- SPACE_USAGE procedure / Procedures
- spcreate.sql script / How it works...
- SQL*Loader
- used, for loading data / Loading data with SQL*Loader and Data Pump, Getting ready, How it works..., There's more...
- SQL*Plus environment
- about / Getting ready
- SQL Access Advisor / There's more…
- SQL activity
- tracing, with SQL trace / Tracing SQL activity with SQL Trace and TKPROF, Getting ready, How it works..., There's more...
- tracing, with TKPROF / Tracing SQL activity with SQL Trace and TKPROF, Getting ready, How it works..., There's more...
- SQL baselines
- creating / Getting ready
- configuring / How to do it...
- working / How it works...
- SQL script
- about / Getting ready
- SQL Trace
- used, for tracing SQL activity / Tracing SQL activity with SQL Trace and TKPROF, Getting ready, How it works..., There's more...
- SQL Tuning Advisor / There's more…
- SQL tuning advisor
- using / Getting ready
- working / How it works...
- SQL tuning sets
- about / Creating SQL Tuning Sets
- creating / Getting ready, How to do it..., How it works...
- STAR_TRANSFORMATION / There's more...
- statistics
- collecting / Collecting statistics, How it works...
- computation / How it works...
- table statistics, locking for highly volatile tables / Lock table statistics for load or highly volatile tables
- Statspack report
- used, for analyzing data / Analyzing data using Statspack reports, How to do it..., How it works...
- data, collecting / Collecting different amounts of data
- report on specific SQL, producing / Producing a report on a specific SQL
- snapshot generation, automating / Automating snapshot generation
- Statspack, maintenance / Statspack maintenance
- storage structures, performance issues
- improper usage / Improper use of storage structures
- stored outlines
- managing / Managing stored outlines, How to do it..., How it works..., There's more...
- private stored outlines / Private and public stored outlines, See also
- public stored outlines / Private and public stored outlines, See also
- stored procedures
- used, for reducing database requests / Reducing the number of requests to the database using stored procedures, How to do it..., How it works..., How to do it..., How it works...
- SUBMIT procedure / Procedures
- subqueries
- using / How to do it...
- working / How it works...
- System Change Number (SCN) / Tuning checkpoints
T
- table
- data inserting, arrays used / How to do it..., How it works...
- TABLE ACCESS BY INDEX ROWID operation / How it works...
- TABLE ACCESS HASH operation / How it works...
- Table Level Lock / How it works...
- temporary tablespaces
- troubleshooting / Troubleshooting temporary tablespaces, How it works...
- configuring / How to do it...
- optimal storage parameters / Optimal storage parameters for temporary tablespaces
- TEST_TUNING_SET / How to do it...
- TIMED_STATISTICS parameter / Getting ready
- TIME_ID field / How it works...
- TIME_WAITED column / How it works...
- TKPROF
- used, for tracing SQL activity / Tracing SQL activity with SQL Trace and TKPROF, Getting ready, How it works..., There's more...
- top n queries
- retrieving / How to do it..., How it works...
- ranking, demonstarting / How to do it..., How it works...
- triggers
- about / Using triggers and virtual columns
- OF, using / Using WHEN and OF in trigger definition
- WHEN, using / Using WHEN and OF in trigger definition
- FOR EACH ROW, avoiding / Avoid FOR EACH ROW in triggers, when possible
- triggers overhead
U
- UGA
- UNION-ALL operation / How it works...
- UNION ALL operation / How it works...
- UNION operator / How to do it..., How it works...
- UNKEEP procedure / Procedures
- UPDATE statement / How it works...
- UPDATE_BY_CAT procedure / There's more..., Procedures
- UPPER function / How it works...
- User Global Area (UGA)
- about / There's more...
- USER tablespace / INCLUDING, OVERFLOW, PCTTHRESHOLD
- USER_TAB_HISTOGRAMS / How to do it...
- USE_HASH (table_name1 table_name2 ) / There's more...
- USE_MERGE (table_name1 table_name2 ) / There's more...
- USE_NL (table_name1 table_name2 ) / There's more...
V
- V$ADVISOR_PROGRESS view / V$ADVISOR_PROGRESSV$ADVISOR_PROGRESS view
- V$BUFFER_POOL_STATISTICS view / V$BUFFER_POOL_STATISTICSV$BUFFER_POOL_STATISTICS view
- V$CONTROLFILE view / V$CONTROLFILEV$CONTROLFILE view
- V$DATAFILE view / V$DATAFILEV$DATAFILE view
- V$DB_CACHE_ADVICE view / V$DB_CACHE_ADVICEdynamic performance viewsV$DB_CACHE_ADVICEV$DB_CACHE_ADVICE view, See also
- V$DB_OBJECT_CACHE view / V$DB_OBJECT_CACHEdynamic performance viewsV$DB_OBJECT_CACHEV$DB_OBJECT_CACHE view
- V$ENQUEUE_LOCK view / V$ENQUEUE_LOCKdynamic performance viewsV$ENQUEUE_LOCKV$ENQUEUE_LOCK view
- V$FILESTAT view / V$FILESTATdynamic performance viewsV$FILESTATV$FILESTAT view
- V$FIXED_TABLE view / V$FIXED_TABLEdynamic performance viewsV$FIXED_TABLEV$FIXED_TABLE view
- V$INSTANCE_RECOVERY view / V$INSTANCE_RECOVERYdynamic performance viewsV$INSTANCE_RECOVERYV$INSTANCE_RECOVERY view
- V$LATCH dynamic performance view / How it works...
- V$LATCH view / V$LATCHdynamic performance viewsV$LATCHV$LATCH view, Fields
- V$LATCH_CHILDREN dynamic performance view / There's more...
- V$LATCH_CHILDREN view / V$LATCH_CHILDRENdynamic performance viewsV$LATCH_CHILDRENV$LATCH_CHILDREN view, Fields
- V$LIBRARYCACHE view / V$LIBRARYCACHEdynamic performance viewsV$LIBRARYCACHEV$LIBRARYCACHE view
- V$LOCKED_OBJECT dynamic performance view / How to do it..., How it works...
- V$LOCKED_OBJECT view / V$LOCKED_OBJECTV$LOCKED_OBJECT viewdynamic performance viewsV$LOCKED_OBJECT
- V$LOCK view / V$LOCKdynamic performance viewsV$LOCKV$LOCK view, V$LOCKED_OBJECTV$LOCKED_OBJECT viewdynamic performance viewsV$LOCKED_OBJECT, Fields
- V$LOGFILE view / V$LOGFILEdynamic performance viewsV$LOGFILEV$LOGFILE view
- V$LOG view / V$LOGdynamic performance viewsV$LOGV$LOG view
- V$LOG_HISTORY view / V$LOG_HISTORYdynamic performance viewsV$LOG_HISTORYV$LOG_HISTORY view
- V$MYSTAT view / V$MYSTATdynamic performance viewsV$MYSTATV$MYSTAT view
- V$PROCESS dynamic performance view / How it works...
- V$PROCESS view / V$PROCESSdynamic performance viewsV$PROCESSV$PROCESS view, See also
- V$ROLLSTAT view / V$ROLLSTATdynamic performance viewsV$ROLLSTATV$ROLLSTAT view
- V$ROWCACHE dynamic performance / How it works..., Tuning the Dictionary Cache
- V$SESSION dynamic performance view / How it works...
- V$SESSION view / V$SESSIONdynamic performance viewsV$SESSIONV$SESSION view, See also
- V$SESSION_EVENT view / V$SESSION_EVENTdynamic performance viewsV$SESSION_EVENTV$SESSION_EVENT view, See also
- V$SESSTAT view / V$SESSTATdynamic performance viewsV$SESSTATV$SESSTAT view
- V$SGAINFO dynamic performance view / How to do it...
- V$SGAINFO view / V$SGAINFOdynamic performance viewsV$SGAINFOV$SGAINFO view
- V$SGA view / V$SGAdynamic performance viewsV$SGAV$SGA view
- V$SHARED_POOL_ADVICE dynamic performance / There's more...
- V$SHARED_POOL_RESERVED view / V$SHARED_POOL_RESERVEDdynamic performance viewsV$SHARED_POOL_RESERVEDV$SHARED_POOL_RESERVED view
- V$SORT_SEGMENT view / V$SORT_SEGMENTdynamic performance viewsV$SORT_SEGMENTV$SORT_SEGMENT view
- V$SQLAREA view / V$SQLAREAdynamic performance viewsV$SQLAREAV$SQLAREA view
- V$SQL view / V$SQLdynamic performance viewsV$SQLV$SQL view, Fields
- V$SQL_PLAN view / V$SQL_PLANdynamic performance viewsV$SQL_PLANV$SQL_PLAN view
- V$STATNAME view / V$STATNAMEdynamic performance viewsV$STATNAMEV$STATNAME view
- V$SYSSTAT view / V$SYSSTATdynamic performance viewsV$SYSSTATV$SYSSTAT view
- V$SYSTEM_EVENT dynamic performance view / How it works..., How it works..., There's more...
- V$SYSTEM_EVENT view / V$SYSTEM_EVENTdynamic performance viewsV$SYSTEM_EVENTV$SYSTEM_EVENT view
- V$TEMPFILE view / V$TEMPFILEdynamic performance viewsV$TEMPFILEV$TEMPFILE view
- V$TEMPSTAT view / V$TEMPSTATdynamic performance viewsV$TEMPSTATV$TEMPSTAT view
- V$WAITSTAT view / V$WAITSTATdynamic performance viewsV$WAITSTATV$WAITSTAT view
- value-based histograms / Height-based and value-based (frequency) histograms
- virtual columns
- about / Using triggers and virtual columns
- using / How to do it...
- working / How it works..., There's more...
W
- web application
- about / Web applications
- WHEN
- WHERE clause / How to do it...
- where condition / There's more...
- WHERE condition / How it works...
- willing-to-wait latch requests / There's more...
- WORKLOAD_BIND procedure / How to do it...
- WORKLOAD_NOBIND procedure / How it works..., How to do it...
- WRITE procedure / Procedures
X
- X$BH view / X$BHdynamic performance viewsX$BHX$BH view
- X1_MY_TEST index / How it works...