Geek Answers Handbook

Can a program determine the use of Oracle resources?

My boss would like to find a way to execute the executable to ask Oracle the size of the resources the program uses. The purpose of this is that we can add to the documentation for documentation / documentation on capacity planning, information on the amount of resources required for each program.

My Google-Fu is weak today, and I really couldn't find anything in the docs or on the Internet that point to an API that will help me with this.

Does anyone have experience that they can share? Or suggest to lead for me to follow?

All answers to questions get +1, as a thank you.

Evil.

+4
source share
1 answer

This query will show you session statistics by their description.

select v$statname.name, v$mystat.value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic#

Descriptions of various statistics (for 10g) are given here:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/stats002.htm

Other useful info in v $ session:

 select * from v$session where sid = ( select distinct sid from v$mystat )
+1
source

More articles:


All Articles