The Oracle DBA's Guide to NT
Guy Harrison
Published Spring 1998:
http://www.oreview.com/9805harr.htm
( linked from: http://home.mira.net/~gharriso )
--- excerpts ---
...
The architecture of Oracle in an NT environment is somewhat
different [than Unix/etc.] (see Figure 2).
Starship)
|| -Original Message-
|| From: Jerry C [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, June 05, 2001 11:32 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT RE: Database writer
||
||
|| So... no winner Ross?
||
|| Do we get the answer??
||
||
|| - Original Message
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT RE: Database writer
||
||
|| So... no winner Ross?
||
|| Do we get the answer??
||
||
|| - Original Message -
|| To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|| Sent: Monday, June 04, 2001 4:25 PM
||
||
|| Yea
in Dublin...aaa!
(Jefferson Starship)
|| -Original Message-
|| From: Jerry C [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, June 05, 2001 11:32 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT RE: Database writer
||
||
|| So... no winner Ross?
||
|| Do we get the answer
: Database writer
||
||
|| Does that mean I can get a beer?
||
|| -Original Message-
|| From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, June 06, 2001 01:08
|| To: 'Mark Leith '; 'Multiple recipients of list ORACLE-L '
|| Subject: RE: OT RE: Database writer
||
||
|| Paul
be as happy as you if I can get my
stars and stripes ass over to GB and buy us
*both* a Smithwick's.
|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, June 06, 2001 9:26 AM
|| To: Lyris; Mohan, Ross
|| Subject: RE: OT RE: Database writer
||
||
|| Does that mean
, June 05, 2001 11:32 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT RE: Database writer
||
||
|| So... no winner Ross?
||
|| Do we get the answer??
||
||
|| - Original Message -
|| To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|| Sent: Monday, June 04
or Kantnergeez, now I have to pull a Pierce
and throw some electrons at google.com
|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, June 06, 2001 5:41 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: OT RE: Database writer
can get my
stars and stripes ass over to GB and buy us
*both* a Smithwick's.
|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, June 06, 2001 9:26 AM
|| To: Lyris; Mohan, Ross
|| Subject: RE: OT RE: Database writer
||
||
|| Does that mean I can get
: OT RE: Database writer
||
||
|| Can you make that 3, I haven't been to Dublin for ages and hope to be
|| popping over in July sometime. Lucky for me though its only
|| a short hop
|| across the Irish Sea.
||
|| Jefferson Starship link is I saw them in a FREE concert
|| in Orlando in
|| 1993
a beer.
NT bigots and their families summarily excused from this offer.:)
|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, June 04, 2001 2:16 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Database writer
of list ORACLE-L
|| Subject: Re: OT RE: Database writer
||
||
|| So... no winner Ross?
||
|| Do we get the answer??
||
||
|| - Original Message -
|| To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|| Sent: Monday, June 04, 2001 4:25 PM
||
||
|| Yea, NT blows. Blows like
Look under ps.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, June 04, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I added db writer
Kev,
Trying to add multiple DBWR processes on NT is useless since NT uses asynch.
I/O. If you remember, all the Oracle processes (DBWR, LGWR, CKPT, ARCH,
etc.) run as threads under the oracle.exe process.
Multiple DBWR processes are definitely a Unix thing!
Also, here's something from
There is a tool in the WinNT Resource Kit that lets you look at
individual threads per process. I don't remember what the name is, but
it's in there.
Try doing a select against v$session and v$bgprocess you should from
v$bgprocess you should get a DBW0 and DBW1 under the listing of
Kevin,
I apologize for asking but this is for the benefit of others possibly. But
how did you determine that your instance may require an additional DBWR
process. What led you to think that you had an bottleneck with only one
process?
Thanks,
Ethan
-Original Message-
Sent: Monday,
Hi, Kevin,
Maybe this query will help:
SQLselect PROGRAM from v$process where PROGRAM like '%DBW%';
Regards
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Monday, June 04, 2001 11:56 AM
To: Multiple recipients of list
Original Message
On 6/4/01, 12:10:53 PM, Vadim Gorbounov [EMAIL PROTECTED]
wrote regarding RE: Database writer:
Hi, Kevin,
Maybe this query will help:
SQL select PROGRAM from v$process where PROGRAM like '%DBW%';
Regards
Vadim Gorbounov
Oracle DBA
You can see that at operating system level using next sentence:
ps -ef | grep dbwr
04/06/2001 17.55
Kevin Kostyszyn
[EMAIL PROTECTED]
04/06/2001 18.10
Por favor, responda a [EMAIL
On Monday 04 June 2001 10:16, Christopher Spence wrote:
Look under ps.
Really? On NT?
Jared
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, June 04, 2001
Have you tried v$bgprocess ?
Regards
Mark
-Original Message-
Kostyszyn
Sent: Monday, June 04, 2001 04:56
To: Multiple recipients of list ORACLE-L
Hi all,
I added db writer processes last week to try and improve performance of one
of my 8.1.7 db's on NT. Does anyone know if
, June 04, 2001 2:16 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Database writer
||
||
|| Doubt, didnt' see NT, boy NT blows.
||
|| I hate how it doesn't list out the processes.
||
|| Walking on water and developing software from a
|| specification are easy if
|| both
to get the thread name.
Rodd Holman
Original Message
On 6/4/01, 2:46:19 PM, Raghu Kota [EMAIL PROTECTED] wrote regarding
RE: Database writer:
But I don't see any Processors for DBWr except ORACLE80.EXE!!
SIDSERIAL#SCHEMANAME PROGRAM
[EMAIL PROTECTED]
Subject: RE: Database writer
Date: Mon, 04 Jun 2001 10:16:07 -0800
That was the query I was looking for.
-Original Message-
Sent: Monday, June 04, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
There is a tool in the WinNT Resource Kit that lets you look
Kevin,
What size is your redo log buffer?
Jared
On Monday 04 June 2001 08:55, Kevin Kostyszyn wrote:
Hi all,
I added db writer processes last week to try and improve performance of
one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if
Oracle actually started the
Title: RE: Database writer
you can download a free fully functional trial version of Spotlight on Oracle from the Quest Website at http://www.quest.com/spotlight_oracle/
there is a link to 'download trial' on the left hand side. You can click on the screenshot to get a full size image
Nick,
Does spotlight support an Oracle server running on NT?
The requirements page says:
Server
Oracle versions from 7.3.3 and above
Solaris (2.5, 2.6, 2.7)
HP-UX (10.20, 11.00/32 bit, 11.00/64 bit)
AIX (4.2, 4.3)
Digital (v4.0d, v4.0f)
which seems to me to say the Oracle server must
I don't think multiple db writer process in NT has any use. I tried all ur method. In
unix only I have seen this parameter taken into effect when u bounce the db after u
change in init.ora
--
On Mon, 04 Jun 2001 10:16:08
Christopher Spence wrote:
Doubt, didnt' see NT, boy NT blows.
I hate
28 matches
Mail list logo