VMware Cloud Community
nickyxy
Contributor
Contributor

how can i display oracle tablespace info line by line?

my oracle database has almost 20 tablespaces, i want to monitor the usage of tablespaces and display line by line . for example :
SYSTEM 100M 80M 80%
EXAM 10M 5M 50%
TBS1 1024M 512M 50%
TBS2 200M 50M 25%
......

how can i do?

tks
0 Kudos
2 Replies
nickyxy
Contributor
Contributor

who can help me?


tks
0 Kudos
jvalkeal_hyperi

I don't quite understand what you mean. If you list resources and give search parameters to show only TB's your interested in, this is basically just what you want. Metrics which are marked as indicators are then shown in that list.

If you just want these values as basic list without any formatting, easiest way is to create shell script wrapping some sqlplus commands.

However if you want this kind of raw list from HQ and perhaps refresh automatically, I would make hqu plugin. This option needs some work, thought...
0 Kudos