Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sql_id is null in v$active_session_history when session_state is CPU , event is not LFS

perfdbaJan 10 2017 — edited Jan 14 2017

Hi Friends,

I am facing a problem in understanding exactly what is the topmost activity taking the CPU during an application load test.

When i check the ASH i see only blank against the sql_id column when i search for -> event is null and session_state='CPU'. As you can see from the below graph , sql_id is null is taking more than 90% of the samples.

ASH_PHOTO.JPG

When i check the raw ASH data it looks like below.

ASH_SNAP.JPG

Can you suggest how to find exactly which sql or activity is causing this high CPU utilisation? It is not "log file sync" because event column is null.

Is it some bug or something?

Another note:

1. PLSQL_ENTRY_OBJECT_ID,PLSQL_ENTRY_SUBPROGRAM_ID,PLSQL_OBJECT_ID and PLSQL_SUBPROGRAM_ID columns are blank for these rows too.

2. DB version is 11.2.0.4

Regds,

Sachin
This post has been answered by John Thorton on Jan 10 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 11 2017
Added on Jan 10 2017
29 comments
4,888 views