Database Administration (MOSC)

MOSC Banner

modify snapshots ID of Statspack

On 19c, my question is this: if you run Statspack and regularly schedule a snapshot to occur, the snapshots are numbered sequentially. That is OK.

But the problem is this: if I install Statspack at the same time on different databases, they get about the same ID's for the same time. If you collect the files in the same directory (for example because the different databases run on the same database as the same OS owner), well, the files look very alike. Meaning: from the numbers itself, it's hard to tell. I know you can change the name of the file, when you run the report manually ...

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