-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
http://dioncho.wordpress.com/tag/copy_table_stats/ READ MORE
|
http://www.oracle.com/technology/oramag/oracle/09-jan/o19asktom.html READ MORE
|
Using v$filestat one can find the physical reads and writes to datafiles it also includes reads done by RMAN. So… READ MORE
|
In 10g SMON gathers information on columns that are used in predicates and updates them in COL_USAGE$. Here is the… READ MORE
|
Using dbms_workload_repository.create_snapshot() one can create AWR snapshot. Example: Creates the snapshot and returns the snap id. If ‘ALL’ is not… READ MORE
There are few scripts that can be used to generate AWR HTML or text reports. @?/rdbms/admin/awrrpt.sql – It is an… READ MORE
|
Using dbms_workload_repository.modify_snapshot_settings, one can modify retention, interval, and topnsql. READ MORE
Using this SQL one can find the snapshot interval and snapshot retention. SQL> SELECT extract(day from snap_interval) *24*60+extract(hour from snap_interval)… READ MORE
Using procedures in DBMS_STATS package one can backup statistics and restore them. Assumes the user scott already has access to… READ MORE
Using the package DBMS_SCHEDULER one can enable/disable jobs. To disable job: This disables the job from running SQL> exec dbms_scheduler.disable(‘GATHER_STATS_JOB’);… READ MORE
|
In certain cases you may want to lock statistics in a table in certain cases, for example if you want… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 