| Volume increased in DB [message #672715] |
Thu, 25 October 2018 06:54  |
 |
muthukrish104
Messages: 82
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 #672744 is a reply to message #672727] |
Fri, 26 October 2018 04:40  |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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 #672869 is a reply to message #672751] |
Tue, 30 October 2018 04:11 |
Andrey_R
Messages: 441
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
