Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TKPROF

467835Jun 4 2008 — edited Apr 7 2012
My oracle database release is

BANNER
----------------------------------------------------------------
Personal Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

I am new to TKPROF .I ran TKPROF report and i am getting the following message
TKPROF C:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3804 EXPLAIN=SYS/brooklyn as sysdba SYS=YES TABLE=sys.plan_table
c:\kk.txt


TKPROF: Release 10.2.0.1.0 - Production on Wed Jun 4 08:58:38 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Trace file: C:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3804.trc
Sort options: default

********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************

error connecting to database using: sysdba
ORA-01005: null password given; logon denied

EXPLAIN PLAN option disabled.


Please give some feedback
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2012
Added on Jun 4 2008
14 comments
3,059 views