Database Tuning (MOSC)

MOSC Banner

What is OPTSTAT_HIST_CONTROL$ table?

edited Apr 19, 2012 6:25AM in Database Tuning (MOSC) 5 comments
"OPTSTAT_HIST_CONTROL$" table. When I found out about it. I only know SNAME and SPARE4 columns.
SQL> select SNAME, SPARE4  from SYS.OPTSTAT_HIST_CONTROL$;

Anyway, How can I find out more information about this table? I mean Information for each column.

SQL> desc OPTSTAT_HIST_CONTROL$
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAME                                              VARCHAR2(30)
 SVAL1                                              NUMBER
 SVAL2                                              TIMESTAMP(6) WITH TIME ZONE
 SPARE1                                             NUMBER
 SPARE2                                             NUMBER
 SPARE3                                             NUMBER
 SPARE4                                             VARCHAR2(1000)
 SPARE5                                             VARCHAR2(1000)
 SPARE6                                             TIMESTAMP(6) WITH TIME ZONE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center