on 12-14-2006 7:59 AM
Hi Experts,
I need a transaction or a table or any location where i can find the memory space occupied by each of the tables(eg. Mem Space Occupoed by VBAP with the tablespace and Functional Area allocated to it) preferrably with their functional areas and tablespaces.
Expecting quick replies as i have very urgent requirment.
Thanks to all for the same.
Best Regards,
Aravind
Hi,
db table info is a bit db dependent. In case of Oracle you can try DB02 and check segment area to select details of a single table. In case of MAXDB, DB50 transaction is very useful.
In future, all dbs are bundled in a single transaction called DBACOCKPIT.
Regards
Christoph
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arvind
Please follow the link mentioned
DB02--> Current Sizes--> Tablespace
It will show you the space that is occupied by different tables in a tablespace. Hope that resolves you query.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.