Simple way to get CPU usage

Often we want just the CPU usage from a query rather than complete 10046,

As Tom Kyte published in setember Oracle Magazine:

”

SQL> begin
   2   :cpu := dbms_utility.get_cpu_time;
   3   dbms_application_info.set_client_info(0);
   4 end;
   5 /
PL/SQL procedure successfully completed.

SQL> select owner, f(owner) from stage;
…
72841 rows selected.

SQL> select
  2  dbms_utility.get_cpu_time-:cpu cpu_hsecs,
  3  userenv(‘client_info’)
  4  from dual;

CPU_HSECS   USERENV(‘CLIENT_INFO’)
———   ———————–
       118                     72841
”

To read the whole article:

http://www.oracle.com/technetwork/issue-archive/2011/11-sep/o51asktom-453438.html

Ucertify evaluation

Once again Ucertify gave me the honor to evaluate their products.

This time the product was PMI RMP – PMI Risk Management Professional Prepkit.

The overall feeling is that Ucertify have a very good solid product.

The specific area evaluated areas were:

Download , Installation and registration: Perfect.

Usability: Excellent.

Methodology: Very good.

Quality of questions: Very good.

Answer explanations: Good.