"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). O
-L
>
>
>No winner! I drink the freaking beer all by myself.
>
>I think I'll pour myself a Smithwick's...somewhere in Dublin...aaa!
>
>
>(Jefferson Starship)
>
>|| -Original Message-
>|| From: Jerry C [mailto:[EMAIL PROTECTED]]
>|| Sent: Tues
: 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
||
u 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 I
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
[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"
'll 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
: 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
f a Smithwick's...somewhere 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 winne
, 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
(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??
||
||
|| - Origin
ipients 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
||
||
|| &
t song lyric reference and i buy you 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 l
I've used it on NT.
Kev
-Original Message-
Bruce (CALBBAY)
Sent: Monday, June 04, 2001 10:15 PM
To: Multiple recipients of list ORACLE-L
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,
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 ha
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
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
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 t
stay near zero most of the time.
Buffers Scanned = "Number of times that the database writer scans the
least-recently-used chain for more buffers to write. The scan can be invoked
either by a "DBWR make free requests" or by a checkpoint. "
This is also probably not the best in
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#
$bgprocess to get the thread name.
Rodd Holman
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 6/4/01, 2:46:19 PM, Raghu Kota <[EMAIL PROTECTED]> wrote regarding
, 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
by looking at the number of buffers scanned, redo log space requests and the
lru scans. According to what I have read there was a possibility that my
DBW0 was not performing very well. It was just a shot in the dark to try
and squeeze some performance out of the db.
Kev
-Original Message---
7 SYS
SNP0
9 7 SYS
SNP1
9 rows selected.
>From: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PRO
NP1
9 rows selected.
>From: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Database writer
>Date: Mon, 04 Jun 2001 10:16:07 -0800
>
>That was the query I was
Would the NT Resource kit program PSTAT.EXE not show you the processes on
the NT box ?? If it will and you don't have it you can pick it up at
http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/pstat-o.
asp
-Original Message-
Sent: Monday, June 04, 2001 1:16 PM
To: Mult
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 are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, June 04, 2001 1:18 PM
To: [EMAIL
odd Holman
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 6/4/01, 10:55:35 AM, Kevin Kostyszyn <[EMAIL PROTECTED]> wrote regarding
Database writer:
> Hi all,
> I added
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 th
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,
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 [EMAI
r.
Rodd Holman
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 6/4/01, 12:10:53 PM, Vadim Gorbounov <[EMAIL PROTECTED]>
wrote regarding RE: Database writer:
> Hi, Kevi
Hi, Kevin,
Maybe this query will help:
SQL>select 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 ORACLE
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, Jun
listing 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 <<<<<<<<<<<<
from 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 "
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 p
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
38 matches
Mail list logo
