OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » TKPROF output (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TKPROF output [message #623298]

Mon, 08 September 2014 03:01

ind!@2020
Messages: 23
Registered: September 2014
Location: India

Junior Member

What QUERY and CURRENT columns are showing in TKPROF exactly.

Report message to a moderator

Re: TKPROF output [message #623299 is a reply to message #623298]

Mon, 08 September 2014 03:03

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Welcome to the forum!

Please read and follow the OraFAQ Forum Guide and How to use [code] tags, to enable us to help you.

Only you know what exactly the TKPROF is showing, since nobody can tell what they cannot see.

You can have a look at these links :
http://www.oracle.com/pls/db121/search?remark=quick_search&word=tkprof
http://www.orafaq.com/wiki/TKProf
http://www.oracle-base.com/articles/8i/tkprof-and-oracle-trace.php

Edit : Added links

[Updated on: Mon, 08 September 2014 03:06]

Report message to a moderator

Re: TKPROF output [message #623300 is a reply to message #623299]

Mon, 08 September 2014 03:06

cookiemonster
Messages: 13968
Registered: September 2008
Location: Rainy Manchester

Senior Member

That sounds like a request for the column defintions Lalit.

@India2020 - have you looked in the documentation?

Report message to a moderator

Re: TKPROF output [message #623301 is a reply to message #623299]

Mon, 08 September 2014 03:07

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

According to documentation

QUERY = Total number of buffers retrieved in consistent mode for all parse, execute, or fetch calls. Usually, buffers are retrieved in consistent mode for queries.
CURRENT = Total number of buffers retrieved in current mode. Buffers are retrieved in current mode for statements such as INSERT, UPDATE, and DELETE.

Report message to a moderator

Re: TKPROF output [message #623308 is a reply to message #623301]

Mon, 08 September 2014 03:26

ind!@2020
Messages: 23
Registered: September 2014
Location: India

Junior Member

So from the doc I have noticed that as follows

QUERY:- Only used for select statments
CURRENT:-Only used for update/delete/insert statements

Report message to a moderator

Re: TKPROF output [message #623309 is a reply to message #623308]

Mon, 08 September 2014 03:46

cookiemonster
Messages: 13968
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you read down the page we linked to you'll see examples of select using current.

Report message to a moderator

Re: TKPROF output [message #623316 is a reply to message #623309]

Mon, 08 September 2014 04:32

ind!@2020
Messages: 23
Registered: September 2014
Location: India

Junior Member

Yes that is correct even in the select query both the columns are being used.So still confused over the output suggested by those columns.

Report message to a moderator

Re: TKPROF output [message #623318 is a reply to message #623316]

Mon, 08 September 2014 04:39

cookiemonster
Messages: 13968
Registered: September 2008
Location: Rainy Manchester

Senior Member

Does this help: https://community.oracle.com/thread/777510
check the first answer to the question.

Report message to a moderator

Re: TKPROF output [message #623665 is a reply to message #623318]

Fri, 12 September 2014 07:17

ind!@2020
Messages: 23
Registered: September 2014
Location: India

Junior Member

Thank you for the link.

Report message to a moderator

Previous Topic:	expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
Next Topic:	sql loader control file+ Unix scripting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 28 13:37:35 CDT 2025