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)
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
://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
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.
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
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
:
- 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
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
.
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
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
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
/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
://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
.
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
/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
://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
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
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
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
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
. 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
, 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
/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
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
-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
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
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
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
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
--
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
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
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
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
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
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:
,
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
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
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'
***
--
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
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
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
*
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
://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
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,
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
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
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
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
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
--
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
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
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
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
-
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
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
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
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
--
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
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
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
://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
://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
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
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
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
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
66 matches
Mail list logo