Database Administration (MOSC)

MOSC Banner

Does dba_segments show accurate table size?

edited Oct 29, 2014 10:00AM in Database Administration (MOSC) 5 commentsAnswered

Hello, we are running Standard Editioin 11.2.0.3.  We have a purchased software package we are testing that uses the database and we want to get and estimate of how much disk space would be required to run thru 40,000 transacations.  First, I used the query below to get the current size of the tables.  Then, we ran thru 50 transactions.  I then ran the query again to determine the difference in size.  The  increase was only 72K for all tables combined.  This seems low and we feel it should be higher.  So, we ran thru another 50 transactions and I

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