simple question on growth monitoring
I'm writing a simple procedure that will run nightly to gather some basic table information, I want to be able to answer questions like "How many record were in so and so table 2 months ago?".......I know this will have been done before but I'm learning and it never hurts to get your hands dirty :)
It inserts the information into a table and I'm currently collecting the following data:-
instance name
table name
row count
date
no of extents
segment size
Can you guys think of anything else (that relates to a table) that might be useful???
LAST_ANALYZED maybe?
chris