Oracle DBMS UTILITY CPU Time - Revision history

Ittichai at 02:44, 15 May 2012

2012-05-15T02:44:09Z

Ittichai at 20:50, 14 May 2012

2012-05-14T20:50:59Z

Ittichai: Created page with "

  variable t1 NUMBER variable cpu1 NUMBER   BEGIN   :t1 := dbms_utility.get_time;   :cpu1 := dbms_utility.get_cpu_time;   dbms_application_info.set_client_info(0); END; /  -..."

2012-05-14T14:36:28Z

Created page with "<pre> variable t1 NUMBER variable cpu1 NUMBER BEGIN :t1 := dbms_utility.get_time; :cpu1 := dbms_utility.get_cpu_time; dbms_application_info.set_client_info(0); END; / -..."

New page

<pre>

variable t1 NUMBER
variable cpu1 NUMBER

BEGIN
:t1 := dbms_utility.get_time;
:cpu1 := dbms_utility.get_cpu_time;
dbms_application_info.set_client_info(0);
END;
/

-- Sample CPU Only
Begin
FOR i IN 1..1000000 LOOP
NULL;
END LOOP;
END;
/

-- Sample CPU and I/O
Begin
FOR i IN (SELECT * FROM all_objects) LOOP
NULL;
END LOOP;
END;
/

SELECT
dbms_utility.get_time - :t1 AS time_hsecs,
dbms_utility.get_cpu_time - :cpu1 AS cpu_hsecs,
userenv('client_info') as calls
FROM dual;

</pre>

@@ Line 1: / Line 1: @@
 <pre>
@@ Line 36: / Line 38: @@
 </pre>
 [[Category:Database_Scripts]]

← Older revision		Revision as of 20:50, 14 May 2012
Line 36:		Line 36:

	</pre>		</pre>
		+
		+	[[Category:Database_Scripts]]