Home » RDBMS Server » Performance Tuning » AWR snap_id sequence
AWR snap_id sequence [message #260672] Mon, 20 August 2007 11:57 Go to next message
adam15612
Messages: 3
Registered: August 2007
Location: U.S.
Junior Member
I am trying to export AWR tables from one database and import them into another. I can't seem to find the sequence that Oracle is using to generate the snap_id. Does anyone know where it's at or what other mechanism Oracle is using to generate the snap_id?

Report message to a moderator

Re: AWR snap_id sequence [message #260687 is a reply to message #260672] Mon, 20 August 2007 13:03 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
 
dba_hist_seg_stat

Report message to a moderator

Re: AWR snap_id sequence [message #260689 is a reply to message #260687] Mon, 20 August 2007 13:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again, how does this help to find where snap_id comes from?

Regards
Michel

Report message to a moderator

Re: AWR snap_id sequence [message #260693 is a reply to message #260672] Mon, 20 August 2007 13:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Found it.
Not sure at 100% but I think it is SYS.WRI$_ADV_SEQ_TASK.

Regards
Michel

Report message to a moderator

Re: AWR snap_id sequence [message #260695 is a reply to message #260693] Mon, 20 August 2007 13:47 Go to previous messageGo to next message
adam15612
Messages: 3
Registered: August 2007
Location: U.S.
Junior Member
Nope. That doesn't have the same sequence numbers as the snapshots, but it is related to taking snapshots because it increments when taking one.

Report message to a moderator

Re: AWR snap_id sequence [message #260696 is a reply to message #260695] Mon, 20 August 2007 13:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the difference? Did you take into account sequence cache size?
Post your queries and result.

Regards
Michel

Report message to a moderator

Re: AWR snap_id sequence [message #260697 is a reply to message #260696] Mon, 20 August 2007 13:57 Go to previous message
adam15612
Messages: 3
Registered: August 2007
Location: U.S.
Junior Member
Yes, the cache is only 10 and the difference between the lastest snap_id and the nextval of the sequence is 398 (the last snap_id being 3085 and the nextval being 3483)

Thanks,
Adam

Report message to a moderator

Previous Topic: Run TKPROF..............
Next Topic: How to Ping (keep) table in db_keep_cache
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 10:36:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.