what does RESOURCES in EXA_DBA_AUDIT_SQL mean?

bjamshid
Padawan

Fellas,

I have been investigating some queries in terms of performance and how much resources are being used in my ETL processes. While checking EXA_DBA_AUDIT_SQL, I couldn't figure out what RESOURCES exactly mean as the only explanation I could find in documentation indicates that it is "Allocated resources in percentage ". Does anyone know what is meant by resources and how it is measured?

Thanks in advance.

1 REPLY 1

exa-Uwe
Moderator
Moderator

Hi,

what is listed as RESOURCES is the share of CPU resources in percent, related to other sessions running at the same time and competing about the CPU resources.

If you have the only active session running, that is 100. With a fair distribution of resources, two sessions running at the same time would each get 50. Here's an easy way to see that for yourself:

select session_id,user_name,sql_text,resources from exa_dba_sessions where status<>'IDLE';

exa-Uwe_0-1607600115597.png

Consumer groups respectively priority groups could be used to achieve an unfair distribution of CPU resources, but that's another story.

Best regards

Uwe