Jump to content
tipsu

Trace file

Recommended Posts


Hi Dear Mr.Burleson!

I have session that consumes fully 1 CPU.

in OEM I can see this session is doing this  -  BEGIN custom_pricing_list.process_q(:errbuf,:rc); END;

Nothing else. When I put the trace on from start of the session , I have a trace file.

But then the trace stops ( not reached yet max_dump_file_size 2G) and the call still going/session spining on CPU ..

So, how to trace to find out WHAT EXACTLY it doing for the rest of the time ?

DB has  free resources

Thanks,Linda

 

Share this post


Link to post
Share on other sites

Hi Linda, and welcome to the forum!

Using 100% CPU is not a problem, the server is designed to ramp up fast!

http://www.dba-oracle.com/t_high_cpu.htm

http://www.dba-oracle.com/t_cpu_utilization_metrics.htm

If the task runs for more than a few minutes, take a AWR or statspack report in a one minute interval!  

That will tell you what is happening!

http://www.dba-oracle.com/t_taking_awr_statspack_snapshot.htm

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×