Database Tuning (MOSC)

MOSC Banner

Can system level optimizer statistics be copied from one database to another?

Is it possible to gather system stats to a stat table, export/import the table to another database, and import the system stats from the transferred table? It seems crazy to run work load stats in production without having any idea how that will impact existing system stats. I'd like to run in prod and move to test (same hardware) to see what work load stats would look like before implementing in production. I don't see a way to do that. Thank-you

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