Automatische SQL Tuning in Oracle Database 10g

Automatische SQL Tuning in Oracle Database 10g - Handige views

Handige views gerelateerd aan automatisch SQL tuning zijn onder andere:

· DBA_ADVISOR_TASKS

· DBA_ADVISOR_FINDINGS

· DBA_ADVISOR_RECOMMENDATIONS

· DBA_ADVISOR_RATIONALE

· DBA_SQLTUNE_STATISTICS

· DBA_SQLTUNE_BINDS

· DBA_SQLTUNE_PLANS

· DBA_SQLSET

· DBA_SQLSET_BINDS

· DBA_SQLSET_STATEMENTS

· DBA_SQLSET_REFERENCES

· DBA_SQL_PROFILES

· V$SQL

· V$SQLAREA

· V$ACTIVE_SESSION_HISTORY

Voorkeur