cancel
Showing results for 
Search instead for 
Did you mean: 

How analyses & Extend table space

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

>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

Former Member
0 Kudos

Thanks for your reply.

Its mean I should increase the FileSystem

My /oracle/DEV/sapdata3 93%

My /oracle/DEV/sapdata2 94%

My /oracle/DEV/sapdata1 91%

Can u explain how to increase file system in HP Unix

Thanks

Manu

Former Member
0 Kudos

do you have unallocated space available?

If you are unsure then i suggest you ask UNIX administrator to perform this task. if you do mistakes then you will be in risk.

you can search for hp unix admin guide on internet.

cheers,

-Sunil

Answers (2)

Answers (2)

Former Member
0 Kudos

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

http://sapbasis.wordpress.com

http://ardhian.kioslinux.com

former_member204746
Active Contributor
0 Kudos

login with Unix user ora[sid]

go in the kernel directory and call:

brtools -u /

Former Member
0 Kudos

Thnaks for your reply.

I log with oradev

then Run brtools. Then I extend Tablespace.

Thanks for your reply

manu