on 10-27-2008 2:41 PM
Dear Expert,
I am using ECC 6.0 with Oracle 10 on HP UX.I check my Tablespace is near about 92 %.
How to Run brtools ?Witch Login I should use ? What I should first analyses about space.I am sending my all filespace
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 2097152 421024 1663040 20% /
/dev/vg00/lvol1 1835008 165960 1656112 9% /stand
/dev/vg00/lvol8 17301504 1929128 15253368 11% /var
/dev/vg00/lvol7 12320768 2575488 9669216 21% /usr
/dev/vg00/lvol10 31457280 6269653 23613441 21% /usr/sap/trans
/dev/vg00/lvol11 10485760 2447740 7535698 25% /usr/sap/DEV
/dev/vg00/lvol6 10354688 4471048 5837720 43% /tmp
/dev/vg00/lvol9 10485760 6869488 3396110 67% /sapmnt
/dev/vg00/lvol12 2097152 28273 1940446 1% /oracle
/dev/vg00/lvol29 5242880 4857623 361185 93% /oracle/stage/102_64
/dev/vg00/lvol13 2097152 133178 1841230 7% /oracle/client
/dev/vg00/lvol15 15728640 14288071 1350577 91% /oracle/DEV
/dev/vg00/lvol22 14548992 408687 13256590 3% /oracle/DEV/sapreorg
/dev/vg00/lvol26 44040192 36724132 6858808 84% /oracle/DEV/sapdata4
/dev/vg00/lvol25 44040192 40570260 3253063 93% /oracle/DEV/sapdata3
/dev/vg00/lvol24 44040192 41129540 2728800 94% /oracle/DEV/sapdata2
/dev/vg00/lvol23 44040192 39980564 3805964 91% /oracle/DEV/sapdata1
/dev/vg00/lvol18 8388608 146099 7727359 2% /oracle/DEV/origlogB
/dev/vg00/lvol17 8388608 146099 7727359 2% /oracle/DEV/origlogA
/dev/vg00/lvol21 31457280 28540417 2734592 91% /oracle/DEV/oraarch
/dev/vg00/lvol20 8388608 121539 7750384 2% /oracle/DEV/mirrlogB
/dev/vg00/lvol19 8388608 121539 7750384 2% /oracle/DEV/mirrlogA
/dev/vg00/lvol30 6291456 4058364 2093777 66% /oracle/DEV/102_64
/dev/vg00/lvol5 12320768 4134056 8122808 34% /opt
/dev/vg00/lvol4 4194304 18928 4142784 0% /home
My /oracle/DEV/sapdata3 93%
My /oracle/DEV/sapdata2 94%
My /oracle/DEV/sapdata1 91%
Please tell me how I analyse from given full filspace and Now I want to increase these three tablespace
Thanks
manu
>My /oracle/DEV/sapdata3 93%
>My /oracle/DEV/sapdata2 94%
>My /oracle/DEV/sapdata1 91%
these are not tablesapce, these are filesystem. tablespace stats with 'PSAP*******'
execute DB02 and check for each tablespace, also check whether you refreshed D02 stats before you check.
Cheers,
-Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
/dev/vg00/lvol26 44040192 36724132 6858808 84% /oracle/DEV/sapdata4
/dev/vg00/lvol25 44040192 40570260 3253063 93% /oracle/DEV/sapdata3
/dev/vg00/lvol24 44040192 41129540 2728800 94% /oracle/DEV/sapdata2
/dev/vg00/lvol23 44040192 39980564 3805964 91% /oracle/DEV/sapdata1
this OS level view. As you can see tha your /oracle/DEV/sapdata4 (usually this is where your SAP production data reside) is almost full, 84%. Consider of increasing logical volume lvol26.
Oracle tablespace is marked with PSAPxxx. You can check via tcode DB02, then click Current Sizes button.
ardhian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
login with Unix user ora[sid]
go in the kernel directory and call:
brtools -u /
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.