Home » RDBMS Server » Server Administration » Volume increased in DB (oracle 12c Windows 2012)
Volume increased in DB [message #672715] Thu, 25 October 2018 06:54 Go to next message
muthukrish104
Messages: 68
Registered: November 2017
Member
Hi ALL,

We dont have license for AWR or ASH.

But we need to have the details of the DB growth in terms of tables size increase, index size increase on every schemas for the last 6 months.
is it possible to get it.

Regards
M.krish
Re: Volume increased in DB [message #672717 is a reply to message #672715] Thu, 25 October 2018 07:28 Go to previous messageGo to next message
BlackSwan
Messages: 26538
Registered: January 2009
Location: SoCal
Senior Member
muthukrish104 wrote on Thu, 25 October 2018 04:54
Hi ALL,

We dont have license for AWR or ASH.

But we need to have the details of the DB growth in terms of tables size increase, index size increase on every schemas for the last 6 months.
is it possible to get it.

Regards
M.krish
If those numbers are deemed important to you, then you should start collecting them today.
Re: Volume increased in DB [message #672727 is a reply to message #672715] Thu, 25 October 2018 11:12 Go to previous messageGo to next message
EdStevens
Messages: 1077
Registered: September 2013
Senior Member
muthukrish104 wrote on Thu, 25 October 2018 06:54
Hi ALL,

We dont have license for AWR or ASH.

But we need to have the details of the DB growth in terms of tables size increase, index size increase on every schemas for the last 6 months.
is it possible to get it.

Regards
M.krish
Is it possible to get it?
Only if you have been collecting that data. The database has not been collecting it for you.
Re: Volume increased in DB [message #672744 is a reply to message #672727] Fri, 26 October 2018 04:40 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
One possible way of giving a very approximate guide is querying the v$datafile view to ascertain at what rate data files were added to the database. Here is an example. Note that this is not a replacement for gathering the required statistics yourself, and will not work if data files were resized, but it may give you a rough idea.
Re: Volume increased in DB [message #672751 is a reply to message #672744] Fri, 26 October 2018 06:58 Go to previous messageGo to next message
muthukrish104
Messages: 68
Registered: November 2017
Member
Hi All,

Thanks for the reply.

Regards
M.krish
Re: Volume increased in DB [message #672869 is a reply to message #672751] Tue, 30 October 2018 04:11 Go to previous message
Andrey_R
Messages: 309
Registered: January 2012
Location: Israel
Senior Member

Another (not so elegant, but possible as a urgent action ) way I can imagine of having a "look into the past" is by restoring your database from an old backup (by rman, not data pump, because data pump does sort of "defragmentation" on the blocks and re-creates indexes at the impdp stage, so it's not a good comparison ) to a different instance and reviewing the storage structures, number of data rows, and indexes, tables and other objects and metrics.

You can compare those to your current environment and conduct an analysis based on the comparison.

[Updated on: Tue, 30 October 2018 04:45]

Report message to a moderator

Previous Topic: Is there any benefits of using one PDB?
Next Topic: OPatch failed with error code = 255
Goto Forum:
  


Current Time: Mon Jun 17 14:03:33 CDT 2019