strange tkprof output for SQLs - II

according to call orders of kernel calls. But is this expected behavior. Thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network

strange tkprof output for PL/SQLs

://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

testtttttttttststststst

-- Daniþment Gazi Ünal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Ora-00600 running 64 bit and 32 bit databases error stack ...

kscnfy hope this helps ... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Oracle Tunning (DRPP)

Hello Mogens and others, Yes, You are right. But the current time based performance techniques still include errors. Prior to 80's(when I was a child), yes, ratio based measurements were the method. Then, wait-event based profiling appeared. In fact, this was an adaptation of Response Time

Re: Trace/Event Info (iOraDumpReader)

also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: Trace/Event Info (iOraDumpReader)

send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Trace/Event Info (iOraDumpReader)

. It was a joke. Don't bite my head off! ;-) eating your own dog food is a compliment...meaning a company that uses its own products in doing its business. I will you and the business good luck! - Ross -Original Message- From: Danisment Gazi Unal (Unal Bilisim) [mailto:[EMAIL

Re: Performance analysis (enqueue and buffer busy waits)

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: URGENT PLEASE ! tns service deletion and recreation

Selam Bunyamin, If you don't want to remove them by installer, you can remove by manually. to remove( as I remember ), go to registry: - HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services to

itrprof is now chart enabled

://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: Second RBS in system tablespace

BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim

Number of returned row(s) is greater than 0 while number of logical read

Hello, When "Number of returned row(s) is greater than 0 while number of logical read is 0", itrprof prompts error. Some of itrprof users encounter this error. here is a line from raw file: FETCH #3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=10,dep=0,og=3,tim=443263450 As you see, number of logical reads are

Re: large SORT_AREA_SIZE usefullness

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: large SORT_AREA_SIZE usefullness

://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

cursor 0 in sql_trace and event10046 raw trace files

orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE you

Re: how to find CPU utilisation at Oracle level

Hi Lisa, itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE and Event 10046 trace files of Oracle; finds bottlenecks and offers information on how to tune them. It's at http://www.unal-bilisim.com/products/itrprof/itrprof.html ---sorry list--- "Koivu, Lisa" wrote: Please excuse

Re: Redo latch contention

on (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

Re: Searching hard parses

- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself fr

Re: Ora-600 : Internal error code.. Help!!!

Unal is my surname, Bilisim is a Turkish word which means Information relevant things. "Koivu, Lisa" wrote: OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25

Re: Export sizing

web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gaz

Re: ORA-12545

-- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: OT: Pin a CPU in Solaris

links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Ora-600 : Internal error code.. Help!!!

Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

Re: Crash Recovery

Hi, In fact, in your case, adding larger TEMP is not the solution. Solution is the adding TEMP with larger extent size. Because, Oracle cleans up segments extent-by-extent. If you have more extents, cleaning-up them will make more dictionary look-up and this will eat CPU. regards... Charlie

Re: ORA-01555 error

www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE y

Re: Crash Recovery

Hi, Oracle was doing full recovery in older version during crash recovery ( I guess pre 7.3, but I'm not sure). But now, Oracle does not do full database recovery during crash recovery. Some un-recovered blocks are recovered when a user tries to use them later. So, if your online log files are

Re: urgent !!

Thank you Bunyamin, This is the one of the solution of generic ORA-12571 error. Keep in mind that there are a lot of solutions for that. "Bunyamin K. Karadeniz" wrote: Thank you All , for the answersI have corrected the fault with your helps.By the way ,Let me give you a fix of a bug on NT

Re: dbsnmp package

Bunyamin, select * from dba_objects where object_name like '%DBSNMP%'; "Bunyamin K. Karadeniz" wrote: Hi all gurus,My question is how can I query the database for which packages are installed?I wonder if dbsnmp is installed?Thank you.Bunyamin -- Web: http://www.unal-bilisim.com *

Re: How to remove corrupted blocks from datafile.

ttp://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To

Re: problems when running dbstart

://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: SV: problems when running dbstart

t;. Should I rename that variable too? /Mikael -Ursprungligt meddelande----- Frn: Danisment Gazi Unal (Unal Bilisim) [SMTP:[EMAIL PROTECTED]] Skickat: den 6 juni 2001 15:01 Till: Multiple recipients of list ORACLE-L mne: Re: problems when running dbstart Hello Mikael,

Re: export causes segmentation fault

*** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

Re: ora-600

t Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Re: DBA_OBJECTS

Bunyamin, Why don't you use v$locked_object ? "Bunyamin K. Karadeniz" wrote: I want to select locked_objects in a view.I runCREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS ASSELECT sn.username, m.sid, m.type, DECODE(m.lmode, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share'

Re: Tkprof/explain plan errors

, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat

Re: dbms_job query?

the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Serv

Re: Export character set

t you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

OT: web page counter needed

Hello, sorry for this OFF-OFF-OFF... topic question. I'm looking for a counter which counts all visited pages, not just current page visited. thanks... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED

Re: deadlock error in oracle8.1.7 on sun solaris

LP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

Re: Database slowdown after 100 days uptime

be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Error Message - Database is Already Up

orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE you

OT: hosting forums

Hello, do you know an organization supplies web-forums hosting. I'll launch my FQA page, but I don't want to deal with setup/backup etc. thanks... *** Unal Bilisim http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal

OT: my site is available

-- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Re: cpu utilization on solaris

end the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: How to interpret an errorstack

rou Yannis Name: ora_60183.zip ora_60183.zipType: Zip Compressed Data (application/x-zip-compressed) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL

Re: ORA-600 and iOraBugFinder available

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

iOraBugFinder available

-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

ora-600 ora-7445 trace file needed

to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

OT: idle and non-idle waits on Unix

/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Installing Multiple Oracle Clients

, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Oracle9i block structures

. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network

Re: SQL Tuning question?

/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle9i block structures

/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: import from corrupted export file.

://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: TAR 1354616.996 (trace generated during database startup)

ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

OFF-TOPIC: comp.databases.oracle.server

web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: ORA-07445

. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim

a minor clarification: SQL tuning is not a problem anymore ?

: - Original Message - From: Danisment Gazi Unal (Unal Bilisim) To: Multiple recipients of list ORACLE-LSent: Saturday, April 28, 2001 12:16 AMSubject: SQL tuning is not a problem anymore ? Hi gurus, I developed a web based tool which formats SQL and Event10046 traces. This tool is superior

Re: monitoring listener.log

listener.log only is not a good way to catch sql*net errors. to catch sql*net errors after connections are established, set sql*net server trace. then scan them. But, it's not be efficient. there will be a lot of trace files. rgrds... "Danisment Gazi Unal (Unal Bilisim)" wrote: Hi, Typical err

Re: monitoring listener.log

Hi, Typical errors in sql*net traces are like this: nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=533, nt[1]=57, nt[2]=0 Means: You get protocol error 57. If you are using TCP/IP, check winsock errors, if I'm not wrong it should be 20057 or 10057. This error causes sql*net 533 error.

Re: oraCore.log

Hi, I'm not sure if the name is oraCore.log. But, core log is generated if an exeception is occured. It includes stack traces, registers etc. You can understand where error is occured by register values, especially CodeSegment/InstructionPointer registers. Saurabh Sharma wrote: hi

SQL tuning is not a problem anymore ?

Hi gurus, I developed a web based tool which formats SQL and Event10046 traces. This tool is superior to tkprof but It works on WEB and formats Binds variables and Waits for SQLs in trace files. and gives tuning advises and costs of SQLs. You can compare these costs with other SQLs (unlike in

Re: Physical Data Layout

LP command for other information (like subscribing) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

Re: ORA-12500

://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: AW: db link hangs

ge BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim)