We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-basis] SAP AIX Oracle Autoextend ?

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by bmurthy (Senior Oracle DBA)
on May 31 at 8:41 AM 		Mark this reply as helpfulMark as helpful
It will not add datafiles, It will only extend the existing datafiles upto
the max size defined.


On Mon, May 31, 2010 at 2:38 PM, Basis Redemption via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:

> Posted by Basis Redemption
> on May 31 at 5:50 AM Hello
> Serhat / Lars,
>
> Thanks for the reply. I have Used = 100% and Total used = 40%. I am still
> confused with the autoextend concept. Does autoextend mean that it will kep
> increasing the tablespace by adding datafiles as long as I have physical
> disk space availability.
>
> Please clear my doubts
>
> Thank you
>
> ---------------Original Message---------------
> From: Lars-Erik Hallsten
> Sent: Monday, May 31, 2010 2:27 AM
> Subject: SAP AIX Oracle Autoextend ?
>
> > Hi,
> >
> > In DB02 you will see 2 columns called "Used" and "Total Used".
> > The "Used" column shows the current filling of the data files and the
> "Total Used" shows how much it can be autoextended to.
> > If the "Used" column says 99% and "Total Used" says 50%, the auto extend
> will increase the tablespace further when needed until "Total Used" is 100%.
>
> > So you don't need to do anything until "Total Used" is starting to reach
> 85-90%. Then you should consider to increase the tablespace with further
> data files.
> >
> > Regards,
> > LEH

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
White Papers
In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language