on 11-03-2008 8:32 AM
Dear Team
I have check my table space .my PSAPSR3 IS 86 %
PSAPSR3 52,288.00 5,864.00 86 YES 240,000.00
PSAPSR3700 95,964.00 21,170.44 83 YES 200,960.00
PSAPSR3USR 20.00 18.06 9 YES 10,000.00
PSAPTEMP 2,000.00 2,000.00 0 YES 10,000.00
PSAPUNDO 8,940.00 8,682.56 3 YES 10,000.00
SYSAUX 440.00 173.63 61 YES 11,024.00
SYSTEM 1,640.00 790.94 50 YES 12,048.00
Plesae suggest . what to do and how
Thanks
manu
start brtools and add a data file.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As already said it depends on your setup and what you want.
Try to two day Oracle DBA course to understand, what is going on with the database and how Oracle works:
http://www.oracle.com/pls/db102/homepage?remark=tahiti
Markus
thanks Sunil, For your repply.
/oracle/PRD/sapdata1 72318976 31010720 40985600 43%
/oracle/PRD/sapdata2 73367552 29033080 43988112 40%
/oracle/PRD/sapdata3 74416128 36411984 37707240 49%
/oracle/PRD/sapdata4 75464704 32602784 42527064 43%
/oracle/PRD/sapdata5 76513280 34622152 41563856 45%
/oracle/PRD/oraarch 40960000 32000082 6595216 84%
In My OS level File system space is there , So now I can simply Extend the Tablespace
Thanks
Manu
hi manu
if table spaces in ASM no problem.if they are not in ASM u add the datafile through brtools or SQL level (login as sysdba user)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi manu
if table spaces in ASM no problem.if they are not in ASM u add the datafile through brtools or SQL level (login as sysdba user)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Sunil for repply . I check with DB02
Tablespace Size Free Used Autoextend
PSAPSR3 52,288.00 5,366.63 90 YES
PSAPSR3700 95,964.00 21,770.38 77 YES
PSAPSR3USR 20.00 18.06 10 YES
PSAPTEMP 2,000.00 2,000.00 0 YES
PSAPUNDO 8,940.00 8,467.56 5 YES
SYSAUX 440.00 170.81 61 YES
SYSTEM 1,640.00 790.94 52 YES
Its Mean my PSAPSR3 is 90% used But it is autoextend . But for performance I want to Add datafile so that PSAPSR3 has more free Space.
So Can I add one more datafile of 2 GB
Thanks
manu
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.