| AWR snap_id sequence [message #260672] |
Mon, 20 August 2007 11:57  |
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?
|
|
|
|
|
|
|
|
|
|
| Re: AWR snap_id sequence [message #260695 is a reply to message #260693] |
Mon, 20 August 2007 13:47  |
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.
|
|
|
|
|
|
| Re: AWR snap_id sequence [message #260697 is a reply to message #260696] |
Mon, 20 August 2007 13:57 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
