Tablespace usage history : dba_hist_tbspc_space_usage

select NAME,RTIME,TABLESPACE_SIZE/1024/1024,TABLESPACE_MAXSIZE/1024/1024,TABLESPACE_USEDSIZE/1024/1024 from dba_hist_tbspc_space_usage,v$tablespace where TABLESPACE_ID=TS# order by 1,2;

Advertisements

3 Responses

  1. Thanks a lot….This was helpfull….

  2. Hi,

    Its actually reports number of blocks … so you tablespace_size*block_size/1024/1024 ….

  3. Good One

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: