Home » RDBMS Server » Performance Tuning » MYSTATS table - Capture Stats?
MYSTATS table - Capture Stats? [message #65176] Mon, 31 May 2004 16:26 Go to next message
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 #65178 is a reply to message #65176] Mon, 31 May 2004 22:34 Go to previous messageGo to next message
Andrey Goryunov
Messages: 1
Registered: May 2004
Junior Member
Hello,
you can use the CREATE_STAT_TABLE procedure in the same package DBMS_STATS.
But by default, the statistics will be gathered in the SYS.AUX_STATS$ table.

Hope this helps.
Re: MYSTATS table - Capture Stats? [message #65183 is a reply to message #65176] Tue, 01 June 2004 18:32 Go to previous message
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
Previous Topic: Multiprocessor Processor Performance Research
Next Topic: How to improve performance on insertion, deletion and update
Goto Forum:
  


Current Time: Tue Feb 27 00:59:43 CST 2024