Re: truss/trace/strace equivalent on Windows

2002-09-08 Thread Danisment Gazi Unal (ubTools)
everything is threads. If you give som more information on the problem/what you whant. I migth be able to give to help you with the correct tool. Danisment Gazi Unal (ubTools) wrote: Thanks Peter, I've been using this utility. But, It's reporting system calls in process level. regards... Peter Gram

truss/trace/strace equivalent on Windows

2002-09-06 Thread Danisment Gazi Unal (ubTools)
Hi to all, I need a utility to debug Oracle's thread on Windows2000. do you know a utility which can trace windows system calls in thread level ? thanks in advance... -- Danisment Gazi Unal http://www.ubTools.com Web-based Oracle Database Products

Re: SQLNet and NET8

2002-08-20 Thread Danisment Gazi Unal (ubTools)
') 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.ubTools.com -- Please see the official ORACLE-L FAQ: http

Re: Oracle Corp. move to India

2002-07-31 Thread Danisment Gazi Unal (ubTools)
command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

OT: finding pasword emails. Virus ???

2002-07-18 Thread Danisment Gazi Unal (ubTools)
Hello list, I'm getting many finding pasword emails from non-registered users. have you got this type of email ? is it a spam or virus ? regards... -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal

Re: UNDO

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

Re: Error on creating index

2002-07-08 Thread Danisment Gazi Unal (ubTools)
ce,connect,resource,...)what is the problem.please help me -- Danisment Gazi Unal http://www.ubTools.com

Re: how to tell if OPS

2002-07-03 Thread Danisment Gazi Unal (ubTools)
') 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.ubTools.com -- Please see the official ORACLE-L FAQ: http

Re: Questionable V$SQLAREA Statistics

2002-07-02 Thread Danisment Gazi Unal (ubTools)
(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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET

Re: ORA-600 during replication

2002-07-01 Thread Danisment Gazi Unal (ubTools)
the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

OT: some questions regarding jobs in EU/US

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

Re: rbs oracle data block corrupted

2002-06-30 Thread Danisment Gazi Unal (ubTools)
interpret it. regards Atul Kumar Srivastav wrote: version : 8.1.6 -Original Message- From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: rbs oracle data block corrupted Hi, which version

Re: rbs oracle data block corrupted

2002-06-29 Thread Danisment Gazi Unal (ubTools)
for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com

Re: production database on aix won't be open, help

2002-06-20 Thread Danisment Gazi Unal (ubTools)
g file is completed. I thought deferred transaction rollback had only to do with storing rollback information for offline tablespaces. What am I missing? Or is the terminology confusing me? Raj "Danisment Gazi Unal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> (ubTools)"

Re: SMON Using Lots of Memory in 9i

2002-06-20 Thread Danisment Gazi Unal (ubTools)
(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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL

Re: SMON Using Lots of Memory in 9i

2002-06-20 Thread Danisment Gazi Unal (ubTools)
Hello, I mean how did you find that SMON is using 50M+ ? regards... Danisment Gazi Unal (ubTools) wrote: Hello, how utility/tool said that SMON was using 50M+ ? regards... Carle, William T (Bill), ALCAS wrote: Hi, We recently converted to 9i and the SMON process seems

Re: SMON Using Lots of Memory in 9i

2002-06-20 Thread Danisment Gazi Unal (ubTools)
command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Wait event problems

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

Re: ORA-00604 and ORA-01578

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

Re: AW: off topic: anyone form Amsterdam, Holland / other major e

2002-06-11 Thread Danisment Gazi Unal (ubTools)
(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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET

Re: ORA-00604 and ORA-01578

2002-06-11 Thread Danisment Gazi Unal (ubTools)
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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see

Re: oracle connection

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

Re: Production Database Open Fails after Mount

2002-06-04 Thread Danisment Gazi Unal (ubTools)
] (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). -- Danisment Gazi Unal http://www.ubTools.com -- Please

Re: ORA-600

2002-05-31 Thread Danisment Gazi Unal (ubTools)
: 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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal

Re: Wait time for SQL*Net message

2002-05-30 Thread Danisment Gazi Unal (ubTools)
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 HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com

Re: Datafile Corruption ........... or Not

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

Re: sqlplus Connect Slow on

2002-05-29 Thread Danisment Gazi Unal (ubTools)
command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: how to changes the sequence no for the redologs

2002-05-29 Thread Danisment Gazi Unal (ubTools)
to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network

Re: Datafile Corruption ........... or Not

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

Re: DB Freeze

2002-05-21 Thread Danisment Gazi Unal
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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: DB Freeze

2002-05-21 Thread Danisment Gazi Unal
') 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.ubTools.com -- Please see the official ORACLE-L FAQ

Re: formating 10046 (level 12) trace file

2002-05-10 Thread Danisment Gazi Unal
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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat

Re: Oracle wants your job

2002-04-30 Thread Danisment Gazi Unal
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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment

Re: Prod problem, please help!!!

2002-04-30 Thread Danisment Gazi Unal
send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com

Re: What block size are you using for your new 9i data

2002-04-26 Thread Danisment Gazi Unal
Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha 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, 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 (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com

Re: Currval and buffer gets

2002-04-23 Thread Danisment Gazi Unal
=838976 p2=1 p3=0 WAIT #1: nam='SQL*Net message from client' ela= 815 p1=838976 p2=1 p3=0 STAT #1 id=1 cnt=1 pid=0 pos=0 obj=0 op='FIXED TABLE FULL X$DUAL ' = Trace file output ends here --- Danisment Gazi Unal [EMAIL PROTECTED]> wrote: > Hello Gaja, &g

Re: Oracle invents time machine - optimizer now faster than light.

2002-04-23 Thread Danisment Gazi Unal
(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.ubTools.com

Re: Oracle invents time machine - optimizer now faster than light.

2002-04-23 Thread Danisment Gazi Unal
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). -- Danisment Gazi Unal http://www.ubTools.com

Re: Currval and buffer gets

2002-04-22 Thread Danisment Gazi Unal
: 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.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal

Re: Ora-12500 Error

2002-04-16 Thread Danisment Gazi Unal
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 subscribing). -- Danisment Gazi Unal http://www.unal

Re: Database shutdown

2002-04-16 Thread Danisment Gazi Unal
). You may 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 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

OT: looking for 9i on solaris for test

2002-04-16 Thread Danisment Gazi Unal
Hello all, I'm looking for Oracle9i on Solaris for some tests. do you know a site offers these types of services. As I know Compaq offers, bu I need Solaris ? thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http

Re: CSSCAN Failed

2002-04-16 Thread Danisment Gazi Unal
to different character sets. regards... -- Danisment Gazi Unal http://www.unal-bilisim.com You can modify export file dump. By this method, you can Reddy, Madhusudana wrote: Hello All, I am getting the following error , when I was trying to run the CSSCAN utility /usr/lib/dld.sl: Can't open

Re: ORA-00600 Error

2002-04-10 Thread Danisment Gazi Unal
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 subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com

Re: Decyphering LMT space bitmap

2002-04-08 Thread Danisment Gazi Unal
e HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com

Re: Still Problem with ORA-12514

2002-04-06 Thread Danisment Gazi Unal
(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 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

[Fwd: ORA-00600 error]

2002-04-03 Thread Danisment Gazi Unal
the trace file ? regards... -- Danisment Gazi Unal http://www.unal-bilisim.com ---BeginMessage--- Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr

Re: OracleService is down on regular basis

2002-04-01 Thread Danisment Gazi Unal
ESPN_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7bit -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: DRPP Paper

2002-03-30 Thread Danisment Gazi Unal
used to build the dynamic sql is changed in between these execution. This happens only if I change that parameter . If I dont change that parameter its runs ok.Can you help pls ..Thanks ,-ak -- Danisment Gazi Unal http://www.unal-bilisim.com -- Danisment Gazi Unal http://www.unal-bilisim.com

Re: urgent

2002-03-28 Thread Danisment Gazi Unal
to build the dynamic sql is changed in between these execution. This happens only if I change that parameter . If I dont change that parameter its runs ok.Can you help pls ..Thanks ,-ak -- Danisment Gazi Unal http://www.unal-bilisim.com

Re: strange tkprof output for SQLs - II

2002-03-22 Thread Danisment Gazi Unal
cpu,elapsed times to ZERO. as a result: Be careful if you enable sql trace from other session. You can see wrong tkprof outputs not only for the current running statement, but also for statements which are parsed before enabling trace. regards... Danisment Gazi Unal wrote: Hello Mogens, I saw

Re: strange tkprof output for SQLs - II

2002-03-21 Thread Danisment Gazi Unal
like to know statistics in raw trace files are inclusive or exclusive. I'm facing diffierent behaviors for this problem. I've opened an iTAR. thanks in advance... Mogens Nrgaard wrote: Danisment - isn't it always "alter system flush shard_pool"? I thought so... Danisment Gazi Unal (Un

Re: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

2002-03-21 Thread Danisment Gazi Unal
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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment

strange tkprof output for SQLs - II

2002-03-20 Thread Danisment Gazi Unal (Unal Bilisim)
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

2002-03-20 Thread Danisment Gazi Unal (Unal Bilisim)
: 844 Logical IO: --- Raw trace file: 5229 + 132854 = 138083 tkprof output : 1279 + 40206 = 41485 As a result, raw trace file is consistent with V$SQL for the parent statement. But tkprof reports different values. What is your comment ? Thanks in advance... -- Danisment Gazi Unal http

testtttttttttststststst

2002-03-19 Thread Danisment Gazi Unal (Unal Bilisim)
-- 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 ...

2002-03-19 Thread Danisment Gazi Unal (Unal Bilisim)
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)

2002-01-31 Thread Danisment Gazi Unal (Unal Bilisim)
and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Danisment Gazi Unal http://www.unal-bilisim.com

Re: Trace/Event Info (iOraDumpReader)

2002-01-24 Thread Danisment Gazi Unal (Unal Bilisim)
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)

2002-01-24 Thread Danisment Gazi Unal (Unal Bilisim)
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)

2002-01-24 Thread Danisment Gazi Unal (Unal Bilisim)
. 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)

2001-08-22 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-08-22 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-08-09 Thread Danisment Gazi Unal (Unal Bilisim)
://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

2001-07-11 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-26 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-22 Thread Danisment Gazi Unal (Unal Bilisim)
design, perhaps, you can add hidden indexed-columns to generated SQLs to make end-users to use indexes. regards... Johnson Poovathummoottil wrote: Hi Danisment Gazi Unal, Itprof's suggestion is valid that I should be able to use an index to speed up this query. But my objective here

Re: large SORT_AREA_SIZE usefullness

2001-06-21 Thread Danisment Gazi Unal (Unal Bilisim)
://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

2001-06-21 Thread Danisment Gazi Unal (Unal Bilisim)
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

Ynt: how to find CPU utilisation at Oracle level

2001-06-20 Thread Danisment Gazi Unal
). 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 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: how to find CPU utilisation at Oracle level

2001-06-20 Thread Danisment Gazi Unal (Unal Bilisim)
ase excuse my ignorance... but what's itrprof? Not tkprof? Lisa Koivu Goddess of Inept Ninja-ettes -Original Message----- From: Danisment Gazi Unal [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Subject: Ynt: how to find CPU utilisation

Re: Redo latch contention

2001-06-16 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-15 Thread Danisment Gazi Unal (Unal Bilisim)
- 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!!!

2001-06-13 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-12 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-12 Thread Danisment Gazi Unal (Unal Bilisim)
-- 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

2001-06-12 Thread Danisment Gazi Unal (Unal Bilisim)
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!!!

2001-06-12 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-11 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-11 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-10 Thread Danisment Gazi Unal (Unal Bilisim)
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 !!

2001-06-08 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-06 Thread Danisment Gazi Unal (Unal Bilisim)
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.

2001-06-06 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-06 Thread Danisment Gazi Unal (Unal Bilisim)
://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

2001-06-06 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-05 Thread Danisment Gazi Unal (Unal Bilisim)
*** -- 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

2001-06-05 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-04 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-02 Thread Danisment Gazi Unal (Unal Bilisim)
, 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?

2001-06-02 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-06-01 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-05-31 Thread Danisment Gazi Unal (Unal Bilisim)
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: SQL TRACE

2001-05-31 Thread Danisment Gazi Unal
, 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 INET: [EMAIL

Re: deadlock error in oracle8.1.7 on sun solaris

2001-05-31 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-05-28 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-05-28 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-05-25 Thread Danisment Gazi Unal (Unal Bilisim)
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

2001-05-25 Thread Danisment Gazi Unal (Unal Bilisim)
-- 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

2001-05-24 Thread Danisment Gazi Unal (Unal Bilisim)
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

  1   2   >