CODEWITHSUNDEEP
oracle-databaseplsqlawr
Ramesh Kumar
Ramesh Kumar

Reputation: 1

AWR Report for execution of PL/SQL with multiple queries

How does a PLSQL script execute?

Currently, I am confused with the AWR report analysis of a PLSQL script.

I see two different SQLIDs, one for the PLSQL SQL script and another for a query executed by the PLSQL.

Is it expected to have two different SQLIDs, or some other process is running the other sql?

Upvotes: 0

Views: 228

Answers (1)

Dinesh vishe
Dinesh vishe

Reputation: 3598

Just we are taking small example for Top running session for CPu. enter image description here

we are checking same sqlid clicked then we are able to data for same. enter image description here

Upvotes: 0

Related Questions