Home » RDBMS Server » Performance Tuning » Tablespace increase - Which is Optimum Method.
Tablespace increase - Which is Optimum Method. [message #150654] Thu, 08 December 2005 23:07 Go to next message
Jegathees
Messages: 8
Registered: December 2005
Location: Coimbatore
Junior Member
Dear Friends,

We have SAP R/3 4.7 Enterprise edition, Oracle 8.1.7.4.0 database & Operating System Redhat Linux 2.4.9.

We increase our Tablespace PSAPPML by 1 datafile every 10 days once when it reaches 99%. 1 datafile Size is 2 GB. Is it opitmal increase. ... ?

Which is the best method increase 1 datafile every week or else bulk datafile increase ie 2 Or 3 datafile at a time once in a Month ... ?

The problem is PSAPPML tablespace soon reaches 99% by our present scenario. Presently our oracle mount point is

Mount Point : /oracle
Allocated : 255 GB
Free : 86 GB

Could you kindly clarify ... ?

Thanking you.
Regards,
P. Jegatheeswaran.




Re: Tablespace increase - Which is Optimum Method. [message #150743 is a reply to message #150654] Fri, 09 December 2005 06:50 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May or may not be.
Depends on your Backup/OS limit/oracle configurations.
But at one fine time, you will hit the wall ( reaching maxdatafiles/db_files).
You can just extend your datafile (instead adding a new one), but your backup/ recovery options should be considered.

I would be more interested in identifying why tablespace is increasing 2g within a week ( Unless you really load 2G worth data with the timeframe).
>>Oracle 8.1.7.4.0 database & Operating System Redhat Linux 2.4.9.

1.)

Are you using DMT or LMT? (Dictionary or Locally managed tablespace?).

If you are in DMT, try to migrate to LMT ( preferably to 10g/9i).
ELSE ( if it is case that you have live with DMT),
make sure you have tablespaces/objects defined as INITIAL=NEXT and PCTINCREASE=0

2.)
Do you happen to do massive deletes/inserts.
May be the tables need the HWM to reset?
Do you ever coalesce the tablespace?

3.)
Are you doing the so-called 'preventive maintenance' thingies like
regular/scheduled online rebuild of indexes ?


[Updated on: Fri, 09 December 2005 06:53]

Report message to a moderator

Previous Topic: Performance of the sql due to group by
Next Topic: How to tune a sql query to make it run faster ...
Goto Forum:
  


Current Time: Fri Mar 29 09:07:37 CDT 2024