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
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 additional db writer processes? I added
db_writer_processes to the init file, the instance started so I am
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
MetaStink on the issue:
Oracle on NT only allows/needs a single database writer process (DBWR).
Multiple DBWRs on UNIX is not multiple real DBWRs which
all go scan for dirty buffers and write them to disk. It's really just one
real DBWR and some I/O slaves. The real DBWR tells the slave DBWRs to do
I/O
of
background processes.
select s.sid, s.serial#, s.schemaname, s.program, b.name
from v$session s, v$bgprocess b
where s.paddr = b.paddr;
HTH
Rodd Holman
Original Message
On 6/4/01, 10:55:35 AM, Kevin Kostyszyn [EMAIL PROTECTED] wrote regarding
Database writer:
Hi all,
I added db writer
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
Well duh? :)
Sorry, but isn't the Database Writer an Oracle process?
-Original Message-
Sent: Monday, June 04, 2001 08:46
To: Multiple recipients of list ORACLE-L
But I don't see any Processors for DBWr except ORACLE80.EXE!!
SIDSERIAL#SCHEMANAME
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
29 matches
Mail list logo