on 06-11-2010 7:33 AM
hi SAP Expert,
is there anyway i can check the table size for oracle database? thanks.
Regards
Hariyono
Hi,
If your requirement is about checking the size of a particular table then use the program RSTABLESIZE. Execute using the Tcode SE38
Regards,
Sharath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can check it at os level using brtools if your operating system is UNIX or AIX.
Steps are below - Login as orasid user and execute command brtools
Segment management -- Additional segment functions -- Show tables -- Database table (Provide table name over here)
And Press Continue for couple of times. It will give you desired output.
Thanks and Regards,
Kedar
Hi,
following steps will give you the more idea about DB size checking.
1.goto DB02 or DB02old transaction. Here you can get the DB size.
2. in the same tcode you can get the table size also. click on Detailed analysis and give ur table name.
it will bring the size of the table.
I hope it will help you.
With Regards,
CSK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.