strange tkprof output for PL/SQLs

ce... -- 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, California

strange tkprof output for SQLs - II

h include statistics of their child statements 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)

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

by "ORA-600 kzckini 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

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: Oracle Tunning (DRPP)

nd it sure beats the checklist tuning approach (let's try this, then this, than that and finally this). May I suggest that you let Anjo, Cary, Bjorn and Steve review your paper, too? Best regards, Mogens Danisment Gazi Unal (Unal Bilisim) wrote: Hello Mogens and others, Yes, You are right. B

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 Perfor

Re: Trace/Event Info (iOraDumpReader)

ot; wrote: > I know. 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 > > -

Re: Trace/Event Info (iOraDumpReader)

) and in > > the message 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). > > -- > Danisment Gazi Unal > http://www.unal-bili

Re: Trace/Event Info (iOraDumpReader)

tGuru') and in > the message 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please

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 c

Re: Performance analysis (enqueue and buffer busy waits)

Hello, It's "Unal Bilisim". Ethan mentioned about itrprof SQL Analyzer, which is superior to tkprof. web: http://www.unal-bilisim.com/products/itrprof/itrprof.html Thank Ethan. regards... Babette Turner-Underwood wrote: > What is "unil-bialism" ?? > >

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: "dba_data_files" sizes disagree with Op. Sys?

urself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message 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

RE: ORA-00600 on Production DB - Need advice

--- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mai

RE: Rollback Segment needs recovery

t;>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or t

RE: Rollback Segment needs recovery

FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of &#x

Re: Rollback Segment needs recovery

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: D

RE: Help ! ORA-00600 : internal error code

27;) and in >the message 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://

RE: Reproduce ORA-0600

d email [EMAIL PROTECTED] with uploaded trace file. regards... 24/7/01 08:35:06, Danisment Gazi Unal (Unal Bilisim) wrote: >Hello, > >First of all, let me explain what the difference between ora-7445 and ora-600: > >We know ora-600 is oracle internal errors. ora-7445 is internal

Re: what do I tune?

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 Intern

RE: Reproduce ORA-0600

;To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message 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

Re: Re:Multiple Listeners

list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message 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

RE: Tracing

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,

iOraBugFinder 3.0.0 and itrprof 2.0.0 available

Hello list, I've added sending emai features to iOraBugFinder and itrprof SQL Analyzer. iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html Number of returned bugs depends on your licenses at Metalink and your selections on iOraBugFinder. If iOraBugFinder can not

Re: Second RBS in system tablespace

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 Diego, California

RE: 81714 aborted upgrade and core dumps on NT

;to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >also send the HELP command for other information (like subscribing). -- Please see the official OR

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

ote EXACT spelling of 'ListGuru') and in > the message 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

cursor 0 in sql_trace and event10046 raw trace files

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: large SORT_AREA_SIZE usefullness

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

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 m

Ynt: SQL Trace ( Perl script help needed)

-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of

Re: Redo latch contention

dk > Mobile: +45 2527 7100 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California

Re: Searching hard parses

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 Services-- (858) 538-50

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:   T

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

hem 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 City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: OT: Pin a CPU in Solaris

es, 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 C

Re: ORA-12545

o 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-

Re: Export sizing

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 City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Die

Re: ORA-01555 error

m 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 City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californi

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 Mengl

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 no

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: SV: problems when running dbstart

aktion_bransches". Should I > rename that variable too? > > /Mikael > > > -Ursprungligt meddelande- > > Från: Danisment Gazi Unal (Unal Bilisim) > > [SMTP:[EMAIL PROTECTED]] > > Skickat: den 6 juni 2001 15:01 > > Till: Multiple recipient

Re: problems when running dbstart

00 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)

Re: How to remove corrupted blocks from datafile.

rums 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-- Public Internet access / Mailing Lists

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 * Qu

Ynt: ora-600

> > with ORA 600. He said > > that it said in paren's, (with complications). Now > > what in the good lords > > name does that mean? I looked on Metasuck and I > > haven't seen anything. Is > > the only answer to call support, or just hammer away > >

Re: ora-600

nal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set > Search Depth to 0. > > Very nice little tool from Unal Bilisim. I used it a few times with good > results. > > HTH > > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.

Re: export causes segmentation fault

> To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be remove

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 AS SELECT sn.username, m.sid, m.type,     DECODE(m.lmode, 0, 'None'   , 1, 'Null'   , 2, 'Row S

Re: dbms_job query?

u') and in > the message 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 -

Re: Tkprof/explain plan errors

http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a 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. *

Re: Export character set

) and in > the message 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: Danism

Re: deadlock error in oracle8.1.7 on sun solaris

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) INET: [EMAIL PROT

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 PROT

Ynt: Performance tuning

f 'ListGuru') and in > the message 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 FA

Re: Error Message - Database is Already Up

so 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 Diego, California

Re: Database slowdown after 100 days uptime

D] (note EXACT spelling of 'ListGuru') and in > the message 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 OR

OT: my site is available

q.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

Re: cpu utilization on solaris

gt; -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Danisment Gazi > Unal (Unal Bilisim) > Sent: Thursday, May 24, 2001 3:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: cpu utilization on solaris > > Hi, > > As I reme

Re: cpu utilization on solaris

an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message 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

Re: How to interpret an errorstack

rough! > <> > > THANKS > > Hatzistavrou Yannis > > > Name: ora_60183.zip >ora_60183.zipType: Zip Compressed Data (application/x-zip-compressed) > Encoding: 7bit -- Please see the official ORACLE-L FAQ:

Re: ORA-600 and iOraBugFinder available

t; any bug no. directly. > Hope this will start working soon perfectly. I am sure this tool > would be of great help > in crisis. Good work done ;-)) > > Thanks again, > Regards, > Rajesh > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

sorry for attaching large files: Ynt: ORA-600 and iOraBugFinder available

your own risk). > However trace file is attached and sent separately to > [EMAIL PROTECTED] If anybody is interested, I can send directly. > > Appreciate your opinion, suggestions and ideas > > Regards, > Rajesh > > -Original Message- > Gazi Unal (Unal

Ynt: ORA-600 and iOraBugFinder available

ideas > > Regards, > Rajesh > > -Original Message- > Gazi Unal (Unal Bilisim) > Sent: Saturday, May 19, 2001 7:45 PM > To: Multiple recipients of list ORACLE-L > > > Hi Gurus, > > I developed a new web based product named iOraBugFinder. > > iOraBugF

iOraBugFinder available

//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-- Public Inter

Ynt: File size problem.

send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message 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 (lik

ora-600 ora-7445 trace file needed

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

Ynt: enqueue waits

Hi,   you can find the time spent in each enqueu by itrprof. - Original Message - From: Diego Cutrone To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 15, 2001 9:50 PM Subject: enqueue waits Hi List, I'm trying to identify the possible cause of c

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

er information (like subscribing). -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof

Re: SQL Tuning question?

zer. 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 Bil

Re: Oracle9i block structures

t; -- > > Use itrprof SQL Analyzer. > > > > 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 > >

Re: import from corrupted export file.

ww.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-5051 FAX:

Oracle9i block structures

rprof/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

Re: TAR 1354616.996 (trace generated during database startup)

d, 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-5

OFF-TOPIC: comp.databases.oracle.server

x27;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 Services-- (858

Re: Rollbacks

t; also send the HELP command for other information (like subscribing). -- Use itrprof SQL Analyzer. 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

Re: ORA-07445

rprof_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: 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, Typica

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

Hi, I would like to add a minor clarification. I saw some non SQL/event10046 trace files are uploaded. let's note that it's not possible to analyze SQLs if they are not traced by SQL_TRACE/Event10046. for report.txt, you can use Anjo's page at www.oraperf.com regards... una

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 Ora

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 everyone, c

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. 5

Re: ORA-12500

emoved 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 Servi

Re: Physical Data Layout

OTECTED] > > > > 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: AW: db link hangs

vices-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, sen