-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
One can automate taking of snapshots of STATSPACK by executing DBMS_JOB or by scheduling it through crontab. Schedule automatic STATSPACK… READ MORE
One can truncate data in STATSPACK or delete range of snaps stored. To truncate STATSPACK data Using $ORACLE_HOME/rdbms/admin/sptrunc.sql, one can… READ MORE
Statspack can be installed by executing the following script, it will prompt for password for user PERFSTAT, the tablespace for… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 