Hello All,
After setting timed_statistics to true, I am finding something strange with
the wait times in v$system_event for the event 'db file sequential read'.
The wait times far exceed the uptime of the database. What I can think of
is, say there are 10 sessions waiting for a single hot block
Janet Linsy wrote:
Hi,
I have a table like this:
SQL select * from test;
ID PRICE
-- --
1 1
1 3
1 4
1 5
1 6
I need to get the second largest price and I was
- Original Message -
Ok, what I need is to find a cookbook for setting up a web server
to serve up Java applets that can connect to multiple databases.
I have an HP workstation with 8.1.7 loaded, with the Apache web
server, but I have no clue about how to a) serve up a Java applet,
You're thinking of v$mystat, but v$session_event is
available in 'vanilla' oracle.
hth
connor
--- [EMAIL PROTECTED] wrote: Hello All,
After setting timed_statistics to true, I am finding
something strange with
the wait times in v$system_event for the event 'db
file sequential read'.
Nope. That version of v$system_event would also show me the max wait that was done on an event, and not just the total time waited. Its there in his book, somewhere in a chapter that also talks of v$filestat and IO tuning, I think.RajConnor McDonald [EMAIL PROTECTED]Sent by: [EMAIL
Hi -
I have a procedure procA owned by userAwhich calls the utl_file
procedure to open and read a text file. The procA procedure
functions properly when it is run in SQL*Plus from the server.
However, when the procA procedure is executed from a client PC using
SQL*Plus (or
We had a very similiar problem here. Not sure what caused it, but by stopping
and restarting the listener, the issue went away. Go figure.
ps. we are also on AIX, with a mix of 8.1.7.2 and 7.3.4
02/09/2002 06:03 PM PST
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL
Anyone who knows ifthere is a possibility to download some edition of oracle database
to your harddrive?
I am running Windows 2000 Millenium Edition.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City