OraFAQ Forum: Performance Tuning » Current snap shot level?

Home » RDBMS Server » Performance Tuning » Current snap shot level? (9.2, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Current snap shot level? [message #437245]

Sat, 02 January 2010 11:05

muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore

Junior Member

How to view the current snapshot level in performance tuning?

Report message to a moderator

Re: Current snap shot level? [message #437246 is a reply to message #437245]

Sat, 02 January 2010 11:27

BlackSwan
Messages: 26766
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)

Report message to a moderator

Re: Current snap shot level? [message #437247 is a reply to message #437246]

Sat, 02 January 2010 11:29

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?

Report message to a moderator

Re: Current snap shot level? [message #437248 is a reply to message #437247]

Sat, 02 January 2010 11:39

BlackSwan
Messages: 26766
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

Report message to a moderator

Previous Topic:	Explain Plan from statsreport
Next Topic:	write as a single statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:52:54 CST 2024