reg:db02 last 2 years data

[Former Member]

Hi All,

i want to see the tablespace growth analysis for particular tables.i can see only for last year in db02.I want to see it for the 2010 too.kindly let me know what can be done to this

System details:Database:oracle9.2.0.8 with Solaris 5.9

ecc5.0

Regards

Ram

[Former Member · Accepted solution]

Hello Ramky,

As far as I know, we can't get 2 years old data in DB02 unless you have maintained a spread sheet manually.

Thanks,

Siva Kumar

[Former Member · Accepted solution]

ya Shiva,

I am unable to see the 2010 but am able to see till last feb2011

Regards

Ram

[Former Member · Accepted solution]

That's is what I am saying bro Even I failed many time to fetch older than a year data.

Thanks,

Siva Kumar

[former_member204080]

Hi,

Try this DB02->Tablespaces->overview->Summary history->Months->SELECT filter and give start date and end date from wen u want to know the size and execute.

If not u can get it from EWA.

[Former Member]

Hello Rramky,

Check this link : http://avdeo.com/2011/01/07/checking-database-growth-trend/

But it will work only if autoextend mode is off for tables.

Regards,

Amit Barnawal

[Former Member]

Hi,

You should be able to get the details of tablespace growth from your EWA reports over the last 2 years.

Hope this helps.

Regards,

Varun