You might want to look at dbms_system.set_ev
Parameters:
sid
serial
event number
level
event name -- leave null in your case
.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see
On the information as supplied you are correct,
the sequence does seem to be the most likely problem.
It has occurred to me, though, that the original poster
showed us a couple of lines from v$session_wait -
without showing the STATE (or is it STATUS) column.
It is a common error to assume that
At 12:28 PM 12/20/2002, John Shaw wrote:
It's probably in the fine manual somewhere - but I haven't found it yet
From my pc:
I can ping the IP address of the server and response time is 10 ms
ping the name of the server and response time is 10 ms
tnsping of IP is 10 ms
but tnsping of the name is
'cause I've met her
--- Sony kristanto [EMAIL PROTECTED] wrote:
How do you know that Rachel ?
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 4:45 AM
To: Multiple recipients of list ORACLE-L
Subject:RE:
Stephen,
Unless you are doing one of the Expert Technical Sessions (otherwise
known as the mini-lessons) I'm not in contention as an alternate for
your slot :)
Rachel
--- Stephen Andert [EMAIL PROTECTED] wrote:
Lisa,
Good news.
REGISTER FOR LIVE! 2003
APRIL 27 - MAY 1
ORLANDO,
Hi,
I have a rac 9.2.0.2 Database running on RedHat AS2.1,it has been up and running for
about 4 monthes(One month ago, i patched it to 9202).
Last night, one instance died unexpectedly,while another instance still running.Though
not much business is affected, I want to know why it died, But i
Hi Chao:
THe Instance 2 in your Cluster (rac2) was dead during
the fast reconfiguration (Check the reason in the alert log
file.. which says reason 2). You generally do a reconfig
(or fast reconfig) when you add/remove instances from the
Cluster setup, which is not (I hope) in your case.
THere
(Even if you have seen an article in Oracle Magazine
that might suggest otherwise).
Cheeky :-)
--- Jonathan Lewis [EMAIL PROTECTED]
wrote: The answer to the question you asked is to
check the dba_indexes view for columns
distinct_keys and num_rows.
HOWEVER -
It is not sensible to
If this were to be used as a serious security tool, you would
be better off studying some of the well known password crackers
and duplicating the algorithms in PL/SQL.
Sounds like a project to add to my todo list. Actually it's one I've had
on the backburner for some time. This can also be
why isn't there a program available that can reverse engineer the code used
to encrypt passwords...
if username XYZ always has password (encrypted) CBA, you think that it would
be easy to figure out the pattern... once you have the pattern it's easy
to go back and forth with the
It is a common error to assume that v$session_wait
is showing a wait time - however if the STATE is
__not__ WAITING then the SECONDS_IN_WAIT
column is the time since the last wait ended.
It's actually the time since the last wait *began*, right?
Cary Millsap
Hotsos Enterprises, Ltd.
Ian,
Could you explain how ASSM could be detrimental in a single instance
environment ?
Vivek,
Could you provide details on the issues [BugNos, description of the
problem, your findings]
you had with ASSM in 9iRAC ?
Hemant
At 07:09 AM 19-12-02 -0800, you wrote:
As part of a RAC
benchmark with
12 matches
Mail list logo
