Correct -
I was sure that I had a set of test results to
prove my point, but I didn't - so I've just run
a series of tests on enqueue and buffer busy waits
on an 8.1.7.4 system and you are absolutely right -
the seconds_in_wait does not reset as the wait
completes.
Thanks,
Jonathan Lewis
You would be getting the TNS protocol adapter error if the instance hasn't been
started -- it is configured to start as a service.
Hemant
At 08:45 AM 19-12-02 -0800, you wrote:
Humm obivioiously Im missing a few brain cells here
Yes, I should know there isnt an exe called connect that would
What is Bonnie's benchmark ? Is it some standard test suite ?
Hemant
At 08:09 AM 19-12-02 -0800, you wrote:
Hello,
We have a Compaq AlphaServer 8400 with 8 GB RAM, 8 dual 625mhz CPUs and
two HSZ70 Array Controllers. Each Controller is connected to 24 36GB
10K rpm Ultr SCSI disk divers. In the
Thanks for your suggestion, i checked that article, but still unable to solve the
problem.
The same time the next day, another instance in the cluster died, with the same
reason. ora-29740, still with reason 2.
The cluster runs quite stable in the past month(since the patchset is installed, it
We have apps 11.5.6 and FS 6i patch 8 (6.0.8.17.1) and
we have been using
mode=socket because Oracle recommended that. Now we
have another Oracle
support guy suggesting mode=http because we have some
users on our WAN in europe
who are saying the system is kind of slow.
Oracle says switching to
I am facing lot of difficulties with out VB objective questions
and Answers and oracle objective questions and Answers.Can any one
help me by sending it
Its my humble request
Regards,
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: guess
But how long did it take to wrap??? :-)
[EMAIL PROTECTED] 21/12/2002 0:03:50
This message has been scanned by MAILSweeper.
Speaking of house ... Congratulations !!
Yesterday my wife and I celebrated our 5th wedding anniversary.
Dear List,
Firstly - Merry Christmas to those who have not already departed for the
holiday season.
I'm currently doing some investigation based around indexes and would like
everyone's opinion: What is everyone's preferred approach to identify
redundant (as in never used by Oracle) indexes? I
Not easily done in Unix. However, if you've got an Oracle db running on the
same server you might want to get yesterday's date from Oracle (within a
shell script).
...
...
YESTERDAY=`sqlplus -s / -EOF
set head off feed off pages 0
select trunc(sysdate - 1) from dual;
Mark,
The way we do it is by what you might call extreme brute force:
1. Capture all SQL from the applications (not just the stuff you've run
in the past month, but the stuff you'll run in the future too, like
period-end close processes, and so on).
2. Generate execution plans in production for
Search the archive of this list. This has been discussed before.
You can use a trick such as this:
yesterday=$(TZ=EST26EDT date +%a)
but beaware that this is not a portable solution. You can write
your own script. E-mail me off line and I can send you mine yesterday
script.
-Original
Thanks for friends,
I found the reason of my rac down.There is a cron that runs daily to sync the
time with the time server. My sa added it without telling me.
And if i set the time back in one node, the instance on another node went
down, with the same trace information. I
Dear List,
I have Korn shell Script that show the date of
execution.
echo `date` - Start shutdown of oracle DB.
Could any body tell me how to display this char `
the quotation for date.
I mean which key I have to press in Unix to get this
quotation character.
I'm working with Unixware7.1
13 matches
Mail list logo