database size from history

If you have EM or Grid control that can be done.
Rakesh

If you don't have grid then you could always check old logs from your full backups and see how much data was being backed up.

jason_goucf wrote:
yes if i had grid i could pull it, however if grid can pull it then we shuld be able to script it.

Are you trying to pull the information from base database or grid control db (repository) ?

:edit..

yes if i had grid i could pull it

Seems like you don't have GRID... Hope you understand there is repository associated with GRID... which could store information.

Edited by: ordba on Apr 8, 2010 12:32 PM

Grid Control stores the data in a repository which gets populated by the Management Agents which are constantly running.

jason_goucf wrote:
i have several standalone databases, none of them are in the grid nor do i have grid set up.

that's what i thought. Please see my response above.

Yes I did read it.
I was responding to your other comment:

"yes if i had grid i could pull it, however if grid can pull it then we shuld be able to script it. "

Grid gets it from the repository which you do not have.

Hello,


Starting with 10g, if AWR (Automatic Workload Repository) is enabled then you may query the following Table:

select  snap_id, tablespace_id, tablespace_size from DBA_HIST_TBSPC_SPACE_USAGE;

Where snap_id is the AWR Snapshot id and tablespace_id is the Tablespace id.

The View DBA_HIST_SNAPSHOT will give you time information for each snap_id.

The View DBA_HIST_TABLESPACE_STAT will give you the Tablespace id (column ts# ) and Tablespace name (column tsname ).

By that way, you may have the history of the Tablespaces growth.

NB: AWR needs specific license.


Hope this help.
Best regards,
Jean-Valentin

Edited by: Lubiez Jean-Valentin on Apr 8, 2010 9:58 PM

Hi all,

How to find the historical data from grid..i mean the table or views that holds historical database information.

I need to do an capacity planning in our environment.

Can anyone tell me the object that holds historical db size information...used by grid to shows us the historical database growth..

Thanks in advance...

Please don't hijack old threads, start your own.

See http://enterprise-manager.blogspot.com/2009/03/retain-historical-data-in-em-repository.html (found by google: oracle grid db historical information)