Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi,
1. Execute tcode DB02
2. Select "Space -> Tablespaces Overview"
3. Select the tab "Data/Temp files"
Here you can see:
- the current size of all data files
- the max size of all data files
- the next extent size (incremented by column)
. . . and more. . .
If you still need more details about the concept of space management, please use help.sap.com.
Regards,
LEH
From: Basis Redemption via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 31. mai 2010 16:12
To: Lars-Erik Hallsten
Subject: RE:[sap-basis] SAP AIX Oracle Autoextend ?
Posted by Basis Redemption
on May 31 at 10:52 AM Mark as helpful
Hello All,
Thank you for the replies. I still did not understand....
First in my case in DB02 my details are as below :
Used = 100% and Total used = 40% (so is this a problem because as per Lars reply I am good as long as Total used % does not reach 99%)
I need to still understand the concept. Where can I know the max autoextend details like how much capacity of extend is possible.
For example
I have max extend size to 20GB, current Tablespace size is 10GB and next extend is 1 GB
This means everytime 1GB data is full on tablespace it will extend/add data file of 1 gb but this will reduce my max extend by 1GB. Again where can I see all these parameters.
And what if I manually extend tables space from brtools what will happen then.
Please clarify these doubts.
Thank you
---------------Original Message---------------
From: Basis Redemption
Sent: Sunday, May 30, 2010 7:02 PM
Subject: SAP AIX Oracle Autoextend ?
> Hello Experts,
>
> My environment is SAP ECC on AIX with Oracle 10g as database. In tx DB02 when I see the tablespaces detail The PSAPECC tablespace shows used 100% and the Autoextend = YES. Free(MB) space is 279MB. Now do I have to extend this table space from BRTOOLS or will it autoextend on its own. How does autoextend work can anyone guide me please.
>
> Thank you
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Lars-Erik Hallsten
SAP Basis Enthusiast
Contributed 1,000 posts in a group to earn a Gold Achievement Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
