Database Administration (MOSC)

MOSC Banner

How to detect rows_num variation?

edited Feb 22, 2010 11:15PM in Database Administration (MOSC) 12 commentsAnswered
Hello

-

I'm running on a 10.2.0.4 RAC database, and I need to detect if a table has a 20% variation in the amount of rows, I mean, if the table has increased or decreased in the number of rows by DML transactions, in order to decide if run or not statistics.
-

Do you know a query or a way to achive that?

-

Thanks in advance.

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