SQL Performance (MOSC)

MOSC Banner

Tkprof "Parsing user id"

edited Jul 28, 2013 11:38PM in SQL Performance (MOSC) 9 commentsAnswered
Hello,how can be identified the "Parsing user id" shown in tkprof output?

For example, let's take this tkprof ouput:

SQL ID: 9r7apbc0cdx6n Plan Hash: 3209728838

SELECT PLA.FLGLLRSEL
FROM
 TALU_PLAESTUDI PLA   WHERE PLA.CODALF =  :b1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          0          2          0           1

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 45056
Number of plan statistics captured: 1
(...)

When I query dba_users, there's no user with id 45056:

select * from dba_users where user_id=45056;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center