Home » RDBMS Server » Server Administration » tablespace growth prediction (Oracle 10g Rel2, Linux AS4)
tablespace growth prediction [message #377765] Wed, 24 December 2008 23:41 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

Is there any script which tells us what is the tablespace growth per day/week . I have the tablespace free and used script butI'm looking for the tablespace growth prediction per day/week .

can somebody help me out in that please.


Regards,
Raj
Re: tablespace growth prediction [message #377766 is a reply to message #377765] Thu, 25 December 2008 00:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Why not run that "tablespace free and used script" everyday/every week?
Meanwhile, it is not prediction. You are just computing it.
Re: tablespace growth prediction [message #377769 is a reply to message #377766] Thu, 25 December 2008 00:20 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hi Mahesh,

The thing is we have that free and used scripts but the main reason behind my query is ; we have a portal wherein we need to write the scripts for tablespace growth prediction which shows the database names ,tablespaces and their growth prediction per week/month .
And we have around 200 databases on our enterprise . so we want everything to show up on our enterprise portal when somebody look into that .

Any help on this will be thankful a lot .

Regards,
Raj

Re: tablespace growth prediction [message #377770 is a reply to message #377769] Thu, 25 December 2008 00:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>we need to write the scripts for tablespace growth prediction which shows the database names ,tablespaces and their growth prediction per week/month
Again,
one cannot predict this. It just a computation based on available information.

May be, you are talking about capacity planning. It would be a blunt ballpark figure, based on historical usage. I
>>so we want everything to show up on our enterprise portal when somebody look into that .
That means there should be a repository to hold historical data. Right?
Just run the tablespace growth script everyday, load data into your own repository and present it in your portal.

On the other hand, individual object information is stored in certain view like DBA_HIST_SEG_STAT. Look into *delta columns.

http://download-east.oracle.com/docs/cd/B13789_01/server.101/b10755/statviews_2143.htm

Re: tablespace growth prediction [message #377800 is a reply to message #377770] Thu, 25 December 2008 03:42 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Mahesh,

I'm not looking for the growth at the segment/object level, rather i'm looking at the filesystem level i.e Operating system level .

we have the databases on the file system as well as the disk groups. as i told you we are looking for calculating the tablespace/datafile growth prediction per day/week in Kb/Mb/Gb.

please try to help me out.

Regards,
Raj
Re: tablespace growth prediction [message #377803 is a reply to message #377800] Thu, 25 December 2008 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query dba_segments/dba_extents to follow object growth.

Regards
Michel
Re: tablespace growth prediction [message #377810 is a reply to message #377800] Thu, 25 December 2008 07:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> rather i'm looking at the filesystem level i.e Operating system level
I would always be careful what I am wishing for and be clear about what I am asking for.
No matter what happens in the database (insert/update/delete/truncate), the physical datafile size in oracle never changes, unless
someone is manually shrinking the datafile or the datafile is in autoextend mode.


You can get something like this.

MONTH_YEAR     DatafileAdded_in_Meg
-------------- -------------
April     2008            64
February  2008         2,285
March     2008        39,040
October   2008           128
September 2008           200
               -------------
sum                   41,717

As I have trying to explain you, this not prediction. I am just looking to the dates and filesize of datafiles when they were added.
It does not indicate how much is used inside those datafiles. You have query the views (as Michel said) or just run the your
"tablespace growth" script everyday and collect the information, and present it for week/day in the report.

As I have no better words to put, I am out of this conversation.
Re: tablespace growth prediction [message #378001 is a reply to message #377765] Sat, 27 December 2008 12:28 Go to previous messageGo to next message
IT Guru
Messages: 59
Registered: January 2007
Member
why dont u create a table name size.

& set cron job. shich will compute TS/datafile size every day & insert into table.

& then u take a report from table.


so simple yaar.


[Updated on: Sat, 27 December 2008 12:31]

Report message to a moderator

Re: tablespace growth prediction [message #378007 is a reply to message #378001] Sat, 27 December 2008 13:45 Go to previous message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use IM speak.

Regards
Michel
Previous Topic: Listener not starting
Next Topic: Shared server
Goto Forum:
  


Current Time: Sun Nov 03 01:26:29 CST 2024