SQL Performance (MOSC)

MOSC Banner

Understanding tkprof results in 12.1

edited Nov 22, 2017 5:42PM in SQL Performance (MOSC) 3 commentsAnswered ✓

Not a tuning question per se, but this seems the best place to ask.

Looking at tkprof results on the same query in an 11.2 SE-1 database vs a 12.1 SE-2 database.

Method:

1) A .sql script file that has a single SELECT statement.

2) connect to database with sqlplus.

3) in different session query v$session to identify the sqlplus session from 2)

4) using the SID and SERIAL# identified in 3), execute 'exec DBMS_MONITOR.SESSION_TRACE_ENABLE($orasessid, $oraser, TRUE, TRUE);'  (this is actually in a shell script, and in addition to starting the trace, creates another shell script to stop it, and another to run tkprof on the resulting trace file)

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