OraFAQ Forum: SQL & PL/SQL » PL/SQL Script execution metics in Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL Script execution metics in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL Script execution metics in Oracle [message #629632]

Fri, 12 December 2014 12:34

praveenr.kumar
Messages: 3
Registered: December 2014

Junior Member

Hello Experts

I am a new member to a Testing Team. As a part of Testing process, we execute lot of pl/sql scripts. What i am trying to do here is capture as many metrices as possible. Can you please point me to some documents or direction as where i can find out what are all the possible metrices that can possibly be reported and how to start capturing these metrices.

Eventually i will have to represent the metrices in a graphical via Oracle Reports or some other Oracle tool.

Regards

Report message to a moderator

Re: PL/SQL Script execution metics in Oracle [message #629634 is a reply to message #629632]

Fri, 12 December 2014 12:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

all existing statistics are contained in GV_$STATNAME
Good luck with deciding which to report & which to ignore.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from GV_$STATNAME ;

  COUNT(*)
----------
       628

Report message to a moderator