| Tablespace increase - Which is Optimum Method. [message #150654] |
Thu, 08 December 2005 23:07  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
