RE: Log switches

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 8 Jul 2004 15:52:31 -0400

What a cool idea. Basically keeping an open file descriptor so that
information about the file is pinned in the kernel. Some antique systems
might complain that someone already has the file open, but using input
redirection should force a read open that doesn't really do anything except
fetch up the needed info.

After Oracle sees this, I wonder how long before they add adaptive
observation of switch times and execute an open a while before they need to
switch so they won't have to wait for file info when they need it.

Holy cow. That is from April 2002 and this is the first time I've noticed
it.

mwf

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Sharples
Sent: Thursday, July 08, 2004 1:30 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Log switches


www.ixora.com.au works for me in the U.K...

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: 08 July 2004 18:25
To: Oracle-L Freelists
Subject: RE: Log switches

On Thu, 2004-07-08 at 02:48, Wolfson Larry - lwolfs wrote:
> Jared,
>       I was wondering if you looked at Steve Adams suggestion of
keeping
> log files open to speed up switching?
>       It is something we were mulling over.
>=20
>       Larry Wolfson
>=20

I'm not familiar with that, or at least, I can't recall it.

And ixora.com.au seems to be down at the moment.

What is the premise?

Jared


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: