 |
|
Automating Oracle
Oracle Tips by Mike Ault |
Automated Statistics Gathering
We will begin with the most complex task,
gathering database statistics. Figure 2 shows a snippet of code from
a statistics gathering PL/SQL routine. The PL/SQL routine called
RUNNING_STATS was excerpted from the RevealNet, Inc. DBMS_REVEALNET
package and can be used to model your own code.
PROCEDURE
running_stats (is_interactive IN BOOLEAN DEFAULT FALSE) AS
start_date DATE;
meas_date DATE;
comp_date DATE;
dd_ratio NUMBER := 0;
r_calls NUMBER := 0;
h_ratio NUMBER := 0;
.
.
.
--
CURSOR get_contend1 IS
SELECT
CLASS, WAITS
FROM
contend
SEE CODE DEPOT FOR FULL SCRIPTS
--
.
.
.
--
CURSOR get_stat(stat IN VARCHAR2) IS
SELECT
name,value
FROM
v$sysstat
SEE CODE DEPOT FOR FULL SCRIPTS
--
--
PROCEDURE
write_out(
SEE CODE DEPOT FOR FULL SCRIPTS
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
