Search

OakieTags

Who's online

There are currently 0 users and 53 guests online.

Recent comments

Affiliations

A simple script for enchancing the functionality of dbms_stats to gather optimizer statistics.

 A simple script for enchancing the functionality of dbms_stats to gather optimizer statistics.

AttachmentSize
dbstat.rename9.68 KB

dbstat

Hi Anand,

Its worth noting that this script was produced for the original OakTable site back in 19/06/2001 (yes, nearly 10 years ago) - a time when dbms_stats had a poor auto size calculation plus numerous other flaws...

If you're on 10.2 or 11, then most of these errors have been ironed out, and you're probably better going with the standard.

Cheers
Connor

Error runing above script

SYS@ims3> @"C:\Documents and Settings\BSFVPN\Desktop\DbstatRename.sql"
Grant succeeded.
Grant succeeded.
Package created.

Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY SYSTEM.DBSTAT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
147/3 PL/SQL: SQL Statement ignored
153/26 PL/SQL: ORA-00942: table or view does not exist
178/18 PL/SQL: SQL Statement ignored
183/32 PL/SQL: ORA-00942: table or view does not exist
190/12 PL/SQL: Statement ignored
190/57 PLS-00364: loop index variable 'J' use is invalid

I think you want to re-visit your above script.

Thanks.

Hi, Can you show its usage

Hi,

Can you show its usage with an example.