| MYSTATS table - Capture Stats? [message #65176] |
Mon, 31 May 2004 16:26  |
IA
Messages: 91
Registered: March 2004
|
Member |
|
|
Hi Everyone,
I am using Oracle 9i on a Solaris platform.
I would like to capture dictionary statistics using the following syntax from the perf tuning manual:
BEGIN
DBMS_STATS.GATHER_SYSTEM_STATS(
gathering_mode => 'interval',
interval => 720,
stattab => 'mystats',
statid => 'OLTP');
END;
/
However, my only problem is that where is the definition for the mystats table. ie, how do I create it? I have no such defined in my database and I cannot find the definition in the user manual.
Your answer to this question would be appreciated. Thanks ... IA
|
|
|
|
|
|
| Re: MYSTATS table - Capture Stats? [message #65183 is a reply to message #65176] |
Tue, 01 June 2004 18:32  |
Sujit Sarkar
Messages: 40
Registered: September 2003
|
Member |
|
|
Dear,
Prior to issue that command you have to create Statistics Table using the following Packaged Procedure.
DBMS_STATS.CREATE_STAT_TABLE(
ownname VARCHAR2 -- schema which ownes the table,
stattab VARCHAR2 -- name of the statistics table ,
tblspace VARCHAR2 -- tablespace which stores the table .but that is optional ,if not passed then user default tablespace is used);
Hope this would help you
Thanx & Regards
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
