Home » SQL & PL/SQL » SQL & PL/SQL » Query for Table & Index Growth
Query for Table & Index Growth [message #243794] Sat, 09 June 2007 01:00 Go to next message
Messages: 15
Registered: May 2007
Junior Member
Hi, I am looking for a query that will tell me what tables were created and updated with the growth of each. I am trying to determine how much to increase a database autogrowth by and I am not having much luck estimating,

thank you.

Re: Query for Table & Index Growth [message #243798 is a reply to message #243794] Sat, 09 June 2007 01:32 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
creation date is in "CREATED" column of DBA_OBJECTS.
There is no last updated date.
Size is in DBA_SEGMENTS.
There is no history. You have to build your own.

Previous Topic: performance tuning of merge
Next Topic: Inserting unique records
Goto Forum:

Current Time: Fri Jul 21 20:09:45 CDT 2017

Total time taken to generate the page: 0.16670 seconds