Home » RDBMS Server » Performance Tuning » Current snap shot level? (9.2, Windows XP)
Current snap shot level? [message #437245] Sat, 02 January 2010 11:05 Go to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
How to view the current snapshot level in performance tuning?
Re: Current snap shot level? [message #437246 is a reply to message #437245] Sat, 02 January 2010 11:27 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
It is not clear what exactly you desire

SQL> desc user_snapshot_logs
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 LOG_OWNER					    VARCHAR2(30)
 MASTER 					    VARCHAR2(30)
 LOG_TABLE					    VARCHAR2(30)
 LOG_TRIGGER					    VARCHAR2(30)
 ROWIDS 					    VARCHAR2(3)
 PRIMARY_KEY					    VARCHAR2(3)
 OBJECT_ID					    VARCHAR2(3)
 FILTER_COLUMNS 				    VARCHAR2(3)
 SEQUENCE					    VARCHAR2(3)
 INCLUDE_NEW_VALUES				    VARCHAR2(3)
 CURRENT_SNAPSHOTS				    DATE
 SNAPSHOT_ID					    NUMBER

SQL> desc user_snapshots    
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER					   NOT NULL VARCHAR2(30)
 NAME					   NOT NULL VARCHAR2(30)
 TABLE_NAME				   NOT NULL VARCHAR2(30)
 MASTER_VIEW					    VARCHAR2(30)
 MASTER_OWNER					    VARCHAR2(30)
 MASTER 					    VARCHAR2(30)
 MASTER_LINK					    VARCHAR2(128)
 CAN_USE_LOG					    VARCHAR2(3)
 UPDATABLE					    VARCHAR2(3)
 REFRESH_METHOD 				    VARCHAR2(11)
 LAST_REFRESH					    DATE
 ERROR						    NUMBER
 FR_OPERATIONS					    VARCHAR2(10)
 CR_OPERATIONS					    VARCHAR2(10)
 TYPE						    VARCHAR2(8)
 NEXT						    VARCHAR2(200)
 START_WITH					    DATE
 REFRESH_GROUP					    NUMBER
 UPDATE_TRIG					    VARCHAR2(30)
 UPDATE_LOG					    VARCHAR2(30)
 QUERY						    LONG
 MASTER_ROLLBACK_SEG				    VARCHAR2(30)
 STATUS 					    VARCHAR2(7)
 REFRESH_MODE					    VARCHAR2(8)
 PREBUILT					    VARCHAR2(3)
Re: Current snap shot level? [message #437247 is a reply to message #437246] Sat, 02 January 2010 11:29 Go to previous messageGo to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
Is there is any query to know the current snap shot level out of the 5 levels, so i can change to new level?
Re: Current snap shot level? [message #437248 is a reply to message #437247] Sat, 02 January 2010 11:39 Go to previous message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
GOOGLE is your friend, but only when you actually USE it.

http://www.dba-oracle.com/tips_oracle_statspack_collection_levels.htm
Previous Topic: Explain Plan from statsreport
Next Topic: write as a single statement
Goto Forum:
  


Current Time: Tue Dec 06 00:21:20 CST 2016

Total time taken to generate the page: 0.10970 seconds