Answers for "oracle cpu usage by schema"

SQL

4

oracle cpu usage

SELECT PARSING_SCHEMA_NAME, MODULE, SQL_ID, 
	   round(((CPU_TIME / 1e6) / 60), 2) AS CPU_TIME,
       EXECUTIONS, ROWS_PROCESSED, DISK_READS, FIRST_LOAD_TIME,
       LAST_LOAD_TIME, OPTIMIZER_COST, SQL_FULLTEXT
FROM V$SQLAREA
WHERE PARSING_SCHEMA_NAME IN ('schema_name')
ORDER BY PARSING_SCHEMA_NAME, CPU_TIME DESC;

Posted by: Guest on July-10-2021

Source

Code answers related to "oracle cpu usage by schema"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#