0

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?

Ramesh Kumar
  • 1

1 Answers1

0

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

Vishe
  • 3,383
  • 1
  • 24
  • 23