Re: Table - Extents

[Anand Kumar N]

thanks a 
lot...
 
- Original Message - 

  From: 
  DENNIS 
  WILLIAMS 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Sunday, December 01, 2002 4:03 
  AM
  Subject: RE: Table - Extents
  Anand - This was the common wisdom several years ago. I used to 
  rebuildtables based on rules of thumb like this. Recently, several leading 
  expertshave challenged this assumption, and now it is generally accepted 
  thattrying to keep the number of extents below 5 wastes a lot of work 
  fornothing. Here are links to papers by Tim Gorman and Cary Millsap 
  thatdiscuss this in more detail.  http://www.evdbt.com/MythsExtPerf.doc 
  http://www.dbatoolbox.com/WP2001/spacemgmt/Myths%20About%20Extents.pdf 
   Dennis Williams DBA, 40%OCP Lifetouch, Inc. 
  [EMAIL PROTECTED] 
  -Original Message-Sent: Saturday, November 30, 2002 11:39 
  AMTo: Multiple recipients of list ORACLE-LIs there any 
  restriction that the segments shouldn't cross more than 5extents in oracle 
  7.3. Pl. help me, as I heard from somebody that the segments 
  shouldn't cross morethan 5 extents and my indexes are in more than 20 
  extents. Thanks in advance Anand KumarDBAITW 
  Signode India Ltd-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
  DENNIS WILLIAMS  INET: [EMAIL PROTECTED]Fat 
  City Network Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California    -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and inthe message BODY, include a line containing: 
  UNSUB ORACLE-L(or the name of mailing list you want to be removed 
  from).  You mayalso send the HELP command for other information (like 
  subscribing).

RE: instance and database

[sstefick]

John,

You're welcome.  I'm always happy when I can help.

-Scott


>= Original Message From [EMAIL PROTECTED] =
>thanks Scott, Jeff, Richard for this one.
>also many thanks for arup for helping out with the earlier
>db shutdown problem that i had earlier.
>
>
>
>--- Jeff Herrick <[EMAIL PROTECTED]> wrote:
>>
>> 1) Identify the database you wish to start using an environment
>>variable (good old DOS)
>>
>> c:\> set ORACLE_SID=SID1
>> c:\> svrmgrl
>>
>>   You can also use LOCAL=SID1...It will override ORACLE_SID
>>   Both of these variables can also be set in the registry under
>>   HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful
>>   to 'hide' a remote database so that you don't have to specify
>>   'connect user/passwd@remotedb' you can just 'connect user/pass'
>>
>>   You can also set either at the System environment level using a
>>   right-click on My Computer / Properties / Environment using
>>   variable names LOCAL or ORACLE_SID
>>
>>   It's good form to do a 'select * from V$database' after you
>>   connect to make sure you are working on the right database
>> =8-0
>>
>> 2) A database can be opened by multiple instances when it's
>>configured in an OPS (Oracle Parallel Server) environment.
>>Not to sound 'flip' here but I wouldn't worry about OPS until
>>you get your mind around how a single instance works :)
>>OPS is now known as RAC - Real Application Clusters
>>
>> Cheers
>>
>> Jeff Herrick
>>
>> On Sat, 30 Nov 2002, john wrote:
>>
>> > Oracle 8i on NT4.0
>> >
>> > via the Oracle Database Configuration Assistant create another
>> > database.
>> > ie create another database with its instance and by default the
>> > db name and instance are same. say i proceed forward and create
>> it.
>> > so now the box would have 2 separate services...
>> > OracleService
>> > OracleService
>> >
>> > is that correct ?
>> > question:
>> > if yes then next if i would start the svrmgrl and do a startup
>> then
>> > which instance would be started ? is there a way to give the
>> > startup command to get only a particular instance started ?
>> >
>> > Next, the docs mention that it is possible to have two or more
>> > instance(s) associated with a given database. The above example
>> > shows two separate database, each with its one unique database.
>> > So how does one implement or have 2 instances for a given
>> database
>> > ?
>> > can someone explain the difference between the two scenarios ?
>> >
>> >
>> > __
>> > Do you Yahoo!?
>> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>> > http://mailplus.yahoo.com
>> > --
>> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> > --
>> > Author: john
>> >   INET: [EMAIL PROTECTED]
>> >
>> > Fat City Network Services-- 858-538-5051
>> http://www.fatcity.com
>> > San Diego, California-- Mailing list and web hosting
>> services
>> >
>>
>-
>> > To REMOVE yourself from this mailing list, send an E-Mail
>> message
>> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
>> and in
>> > the message BODY, include a line containing: UNSUB ORACLE-L
>> > (or the name of mailing list you want to be removed from).  You
>> may
>> > also send the HELP command for other information (like
>> subscribing).
>> >
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Jeff Herrick
>>   INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services-- 858-538-5051
>> http://www.fatcity.com
>> San Diego, California-- Mailing list and web hosting
>> services
>>
>-
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
>> in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from).  You
>> may
>> also send the HELP command for other information (like
>> subscribing).
>>
>
>
>__
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: john
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sstef

Re: instance and database

[Arup Nanda]

John,

You are welcome. I am glad Icould be of help.

Arup Nanda
www.proligence.com





From: john <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: instance and database
Date: Sat, 30 Nov 2002 13:58:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by 
mc4-f27.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sat, 30 
Nov 2002 14:52:34 -0800
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
(8.9.3/8.9.3) with UUCP id OAA62840;Sat, 30 Nov 2002 14:52:30 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050F6DF; 
Sat, 30 Nov 2002 13:58:43 -0800
Message-ID: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: john <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 30 Nov 2002 22:52:34.0078 (UTC) 
FILETIME=[2BCE4BE0:01C298C3]

thanks Scott, Jeff, Richard for this one.
also many thanks for arup for helping out with the earlier
db shutdown problem that i had earlier.



--- Jeff Herrick <[EMAIL PROTECTED]> wrote:
>
> 1) Identify the database you wish to start using an environment
>variable (good old DOS)
>
> c:\> set ORACLE_SID=SID1
> c:\> svrmgrl
>
>   You can also use LOCAL=SID1...It will override ORACLE_SID
>   Both of these variables can also be set in the registry under
>   HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful
>   to 'hide' a remote database so that you don't have to specify
>   'connect user/passwd@remotedb' you can just 'connect user/pass'
>
>   You can also set either at the System environment level using a
>   right-click on My Computer / Properties / Environment using
>   variable names LOCAL or ORACLE_SID
>
>   It's good form to do a 'select * from V$database' after you
>   connect to make sure you are working on the right database
> =8-0
>
> 2) A database can be opened by multiple instances when it's
>configured in an OPS (Oracle Parallel Server) environment.
>Not to sound 'flip' here but I wouldn't worry about OPS until
>you get your mind around how a single instance works :)
>OPS is now known as RAC - Real Application Clusters
>
> Cheers
>
> Jeff Herrick
>
> On Sat, 30 Nov 2002, john wrote:
>
> > Oracle 8i on NT4.0
> >
> > via the Oracle Database Configuration Assistant create another
> > database.
> > ie create another database with its instance and by default the
> > db name and instance are same. say i proceed forward and create
> it.
> > so now the box would have 2 separate services...
> > OracleService
> > OracleService
> >
> > is that correct ?
> > question:
> > if yes then next if i would start the svrmgrl and do a startup
> then
> > which instance would be started ? is there a way to give the
> > startup command to get only a particular instance started ?
> >
> > Next, the docs mention that it is possible to have two or more
> > instance(s) associated with a given database. The above example
> > shows two separate database, each with its one unique database.
> > So how does one implement or have 2 instances for a given
> database
> > ?
> > can someone explain the difference between the two scenarios ?
> >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: john
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
>
-
> > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You
> may
> > also send the HELP command for other information (like
> subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeff Herrick
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
> services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You
> may
> also send the HELP command for other information (like
> subscribing).
>

RE: Anyone knowing about Unix groups

[Brian_P_MacLean]

Ah, news groups...It's where it all started for some of us old timers.

Read, Learn, & Ask.  You can browse and post via Google.

http://groups.google.com/groups?hl=en&lr
=&ie=UTF-8&group=comp.databases.oracle
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.unix
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.unix.shell
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.lang.perl




   
 
  "Deshpande, Kirti"   
 
 
  erizon.com>   cc:
 
  Sent by:  Subject:  RE: Anyone knowing about 
Unix groups  
  [EMAIL PROTECTED] 
 
   
 
   
 
  11/28/02 10:04 AM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




http://www.ugu.com

- Kirti

-Original Message-
Sent: Thursday, November 28, 2002 2:59 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anyone whom knows about any website where you can ask questions about unix
and shell-programming?

Thanks in advance.

Roland



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Error on the ORACLE-L list

[Richard Ji]

I got a same error message when sending an e-mail to the list last night.
Haven't got it since.

-Original Message-
Sent: Saturday, November 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L



The error is 'relaying denied'.

For some reason, the mail server thought your message
was attempting to relay mail through the fatcity server.

I'm no mail expert, but that's what it looks like.

If it doesn't continue, don't worry about it.

Jared

On Friday 29 November 2002 19:21, Hemant K Chitale wrote:
> I just got an error saying that ORACLE-L doesn't exist
> when I sent an email to the list.  I wonder if this email goes through ...
>
> Here's the header of the reply / bounce-back :
>
===
> The original message was received at Sat, 30 Nov 2002 10:43:47
> +0800 from bb-203-125-107-187.singnet.com.sg [203.125.107.187]
> - The following addresses had permanent fatal errors -
> <[EMAIL PROTECTED]>
> (reason: 550 <[EMAIL PROTECTED]>... Relaying denied)
> - Transcript of session follows -
>
> ... while talking to mh2.cts.com.:
>  >>> RCPT To:<[EMAIL PROTECTED]>
>
> <<< 550 <[EMAIL PROTECTED]>... Relaying denied
> 550 5.1.1 <[EMAIL PROTECTED]>... User unknown
> Reporting-MTA: dns; smtp15.singnet.com.sg
> Received-From-MTA: DNS; bb-203-125-107-187.singnet.com.sg
> Arrival-Date: Sat, 30 Nov 2002 10:43:47 +0800
> Final-Recipient: RFC822; [EMAIL PROTECTED]
> Action: failed
> Status: 5.1.1
> Remote-MTA: DNS; mh2.cts.com
> Diagnostic-Code: SMTP; 550 <[EMAIL PROTECTED]>... Relaying denied
> Last-Attempt-Date: Sat, 30 Nov 2002 10:46:59 +0800
> Return-Path: <[EMAIL PROTECTED]>
> Received: from hemant.singnet.com.sg (bb-203-125-107-187.singnet.com.sg
> [203.125.107.187])
> by smtp15.singnet.com.sg (8.12.6/8.12.6) with ESMTP id gAU2hlj0008866;
> Sat, 30 Nov 2002 10:43:47 +0800
> Message-Id: <[EMAIL PROTECTED]>
> X-Sender: [EMAIL PROTECTED]
> X-Mailer: QUALCOMM Windows Eudora Version 5.1.1
> Date: Sat, 30 Nov 2002 10:37:17 +0800
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> From: Hemant K Chitale <[EMAIL PROTECTED]>
> Subject: Re: Recipe for application design to run on RAC
> In-Reply-To: <[EMAIL PROTECTED]>
> Mime-Version: 1.0
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
===
>
>
> Hemant K Chitale
> My web site page is :  http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Views & Resources (7.3.4 DB)

[Jeff Herrick]

Maybe the UNION is trying to resolve duplicates that it doesn't
have to??? i.e. requiring a sort

Have you tried UNION ALL

Cheers

Jeff Herrick

On Sat, 30 Nov 2002, Lisa R. Clary wrote:

> I have 3 individual views (average #records=76,000) with the exact same variable 
>names and datatypes.  There is another view that is the union of the 3 individual 
>views. If I use a count(*) operation (in sqlplus) on the view that is the union (or 
>the individual view), I run out of temp space e.g. ORA-01652: unable to extend temp 
>segment by 256 in tablespace TEMP (108M temp space, ). If I do subsets, selects, 
>whatever, the views are fairly quick with no problems-- I just can't perform count(*) 
>operations
>
> Any ideas as to parameters in environment/temp space that would eliminate the extent 
>problem relative to the count function?
>
> thanks,
> lc
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Error on the ORACLE-L list

[Jeff Herrick]

You think that's bad...I've received 2 bounces from 2 different
mail gateways for a suspected virus in my message. The first
one was that ASP example you wanted Jared and the second was
the ORACLE_SID on NT discussion. I can kinda understand
the paranoia with the ASP code if they're using HTML mail agents
but I can't see any reason why a couple of example DOS commands
would make it barf.  =8-0

BTWI'm using PINE thru a Telnet session to a BSD host for
all my emails. So I know I'm _clean_  :)

Jeff Herrick


On Sat, 30 Nov 2002, Jared Still wrote:

>
> The error is 'relaying denied'.
>
> For some reason, the mail server thought your message
> was attempting to relay mail through the fatcity server.
>
> I'm no mail expert, but that's what it looks like.
>
> If it doesn't continue, don't worry about it.
>
> Jared
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:is it possible ?

[dgoulet]

Not on HP-UX.  Since the processes have names like 'ora_smon_' when you try
to start the second instantiation of the database under the same sid you get an
error message about Oracle already running.

Dick Goulet

Reply Separator
Author: "VIVEK_SHARMA" <[EMAIL PROTECTED]>
Date:   11/27/2002 7:54 AM


Is it possible For 2 Databases to be Brought up on the SAME machine with the
SAME ORACLE_SID 
from Different ORACLE_HOMEs ?

If so , how ?

Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Views & Resources (7.3.4 DB)

[Lisa R. Clary]

I have 3 individual views (average 
#records=76,000) with the exact same variable names and datatypes.  There 
is another view that is the union of the 3 individual views. If I use a count(*) 
operation (in sqlplus) on the view that is the union (or the individual view), I 
run out of temp space e.g. ORA-01652: unable to extend temp segment by 256 in 
tablespace TEMP (108M temp space, ). If I do subsets, selects, whatever, 
the views are fairly quick with no problems-- I just can't perform 
count(*) operations
 
Any ideas as to parameters in environment/temp 
space that would eliminate the extent problem relative to the count function? 

 
thanks,
lc

Re:Oracle 8.1.6 Installation error

[dgoulet]

Ashoke,

I can't speak for SUN, but as far as I know HP is the same way.  You need to
install into a seperate ORACLE_HOME.  For me that's /ora1/817 for 6.1.7 and
/ora1/816 for 8.1.6.

Dick Goulet

Reply Separator
Author: "Mandal; Ashoke" <[EMAIL PROTECTED]>
Date:   11/27/2002 9:18 AM

Greetings,

I was trying to install oracle 8.1.6 on a Sun Solaris(2.7) box.

But I get an error saying that you cannot install 8.1.6 when you have already
installed 8.1.7 in this box.

I was under impression that you can install a lower version of Oracle in the
same box.

Could you please confirm this.

Thanks,
Ashoke
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandal, Ashoke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table - Extents

[DENNIS WILLIAMS]

Anand - This was the common wisdom several years ago. I used to rebuild
tables based on rules of thumb like this. Recently, several leading experts
have challenged this assumption, and now it is generally accepted that
trying to keep the number of extents below 5 wastes a lot of work for
nothing. Here are links to papers by Tim Gorman and Cary Millsap that
discuss this in more detail. 
 
http://www.evdbt.com/MythsExtPerf.doc
 
http://www.dbatoolbox.com/WP2001/spacemgmt/Myths%20About%20Extents.pdf
 
 


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Saturday, November 30, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Is there any restriction that the segments shouldn't cross more than 5
extents in oracle 7.3.
 
Pl. help me, as I heard from somebody that the segments shouldn't cross more
than 5 extents and my indexes are in more than 20 extents.
 
Thanks in advance
 
Anand Kumar
DBA
ITW Signode India Ltd

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: instance and database

[john]

thanks Scott, Jeff, Richard for this one.
also many thanks for arup for helping out with the earlier
db shutdown problem that i had earlier.   



--- Jeff Herrick <[EMAIL PROTECTED]> wrote:
> 
> 1) Identify the database you wish to start using an environment
>variable (good old DOS)
> 
> c:\> set ORACLE_SID=SID1
> c:\> svrmgrl
> 
>   You can also use LOCAL=SID1...It will override ORACLE_SID
>   Both of these variables can also be set in the registry under
>   HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful
>   to 'hide' a remote database so that you don't have to specify
>   'connect user/passwd@remotedb' you can just 'connect user/pass'
> 
>   You can also set either at the System environment level using a
>   right-click on My Computer / Properties / Environment using
>   variable names LOCAL or ORACLE_SID
> 
>   It's good form to do a 'select * from V$database' after you
>   connect to make sure you are working on the right database 
> =8-0
> 
> 2) A database can be opened by multiple instances when it's
>configured in an OPS (Oracle Parallel Server) environment.
>Not to sound 'flip' here but I wouldn't worry about OPS until
>you get your mind around how a single instance works :)
>OPS is now known as RAC - Real Application Clusters
> 
> Cheers
> 
> Jeff Herrick
> 
> On Sat, 30 Nov 2002, john wrote:
> 
> > Oracle 8i on NT4.0
> >
> > via the Oracle Database Configuration Assistant create another
> > database.
> > ie create another database with its instance and by default the
> > db name and instance are same. say i proceed forward and create
> it.
> > so now the box would have 2 separate services...
> > OracleService
> > OracleService
> >
> > is that correct ?
> > question:
> > if yes then next if i would start the svrmgrl and do a startup
> then
> > which instance would be started ? is there a way to give the
> > startup command to get only a particular instance started ?
> >
> > Next, the docs mention that it is possible to have two or more
> > instance(s) associated with a given database. The above example
> > shows two separate database, each with its one unique database.
> > So how does one implement or have 2 instances for a given
> database
> > ?
> > can someone explain the difference between the two scenarios ?
> >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: john
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
>
-
> > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You
> may
> > also send the HELP command for other information (like
> subscribing).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jeff Herrick
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
> services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You
> may
> also send the HELP command for other information (like
> subscribing).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: john
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: logical tuning

[DENNIS WILLIAMS]

Madhu - That is what makes a DBA's job so interesting. The only pattern is
that there is no pattern. But if it was simple, I doubt if we would be
making much over minimum wage. A case study by Ferenc for Seibel would not
help me, and I'm sure Ferenc would find my experience with Lawson to be a
big yawn. Very little in common. That is why learning how to learn your app
is what really matters. Too many people don't believe they can ever
understand the app. Or they just spend all their time whining about what
idiots the people were that created the app.
   Another issue with 3rd party apps that is pretty common -- upgrading to a
new version. This involves moving massive amounts of data. Businesses don't
like to have their critical app down for days at a time, so this is often
the supreme performance test.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Saturday, November 30, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L


Thanks a bunch Ferenc and Dennis,
I actually expected a CASE study which you have developed on some of tools /
3rd party Apps, But have got some nice tips . I shall follow them

Thanks
Madhu


-Original Message-
Sent: Friday, November 29, 2002 7:14 PM
To: Multiple recipients of list ORACLE-L


Madhu

To be perfectly honest, I had an unfair advantge as I worked in Siebel 
Expert Services for 2.5 years, flying all over the world, with a broom in 
one hand and a mop in the other, cleaning mess after mess at customer 
sites,where usually the integrator stuffed things up mainly due to 
ignorance on almost all fronts. I then spent a good portion of this year in 
Siebel Engineering where I was their lead performance engineer for the 
Siebel Analytics and Marketing products on Oracle.Then in August, I finally 
had enough and quit.

I don't know that there is a top 10 list. But always the 3 golden rules for 
being a good DBA:
1. know your data.
2. know your data.
3. know your data.
Everything is supplementary after that.

Regards :

Ferenc Mantfeld

-Original Message-
From:   Reddy, Madhusudana [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, November 29, 2002 10:34 PM
To: Multiple recipients of list ORACLE-L
Subject:FW: logical tuning

Dennis & Ferenc,
Your discussion is a good read ...

You guys are able to understand how your applications are working WITH
Oracle, like using RULE/COST optimizer , Table Scans and also how it is
using the Oracle capabilities. I also wanted to know more about the
application running on top of Oracle . Would you guys GUIDE me with some
steps ( may be top 10 and how to do that ) , or you have any document which
you have prepared in the past will be great help for guys like me who 
wanted
to know more :))-

This LIST is always been a great HELP for me... Happy Thanks giving to YOU
ALL.

Thanks
Madhu


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/27/2002 4:28 PM

Ferenc
   Thanks so much for providing an insight into what you do. Lawson uses
Oracle in quite a simpler method. No joins, just individual table
access. No
table scans, each access is hinted to use a specific index. Crude but
effective. The first issue is that it doesn't use all of Oracle's
capabilities. The second issue is that it provides little opportunity
for
Oracle tuning experts such as yourself. But customers keep pressing for
better use of Oracle, so there is hope yet. ;-)
   Based on what I've seen out of Lawson and wait statistics, I'm
applying
my efforts to reducing physical I/O. I just configured several tables
for
the KEEP and RECYCLE pools.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, November 27, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Dennis

as you know, there is no 'follow these steps to get a better performing
application' guide when it comes to tuning. An intimate knowledge of
what
the application does is a must. I sell myself (tried the street corners
but
was not getting much intrest) as a Siebel performance tuning specialist,
so
when customers say 'Oh, you are an Oracle DBA !', I respond with 'No,
Oracle DBA is just one of the things I do in order to get my job done'.
there are plenty of DBA's out there, (and DBB's too), but understnading
how
the application (in my case Siebel) works and what it is trying to
accomplish from a functional perspective helps me to know immediately
what
is the framework of limitations I can work in. For instance, Siebel is
written for RBO, so when someone comes spouting partitions and bitmap
indexes, I buzz them out on try 1.

now for Siebel specific EIM (Enterprise Integration Manager) type tuning
,
when I see that index range scans are killing me, I try to reduce the
batch
size first so that it will not have to go through as many records per
value
(think of a batch size of 20,000 records where it is doing a correlated
subquery on just the batch_id). Now change this into 100

Re: Error on the ORACLE-L list

[Jared Still]

The error is 'relaying denied'.

For some reason, the mail server thought your message
was attempting to relay mail through the fatcity server.

I'm no mail expert, but that's what it looks like.

If it doesn't continue, don't worry about it.

Jared

On Friday 29 November 2002 19:21, Hemant K Chitale wrote:
> I just got an error saying that ORACLE-L doesn't exist
> when I sent an email to the list.  I wonder if this email goes through ...
>
> Here's the header of the reply / bounce-back :
> ===
> The original message was received at Sat, 30 Nov 2002 10:43:47
> +0800 from bb-203-125-107-187.singnet.com.sg [203.125.107.187]
> - The following addresses had permanent fatal errors -
> <[EMAIL PROTECTED]>
> (reason: 550 <[EMAIL PROTECTED]>... Relaying denied)
> - Transcript of session follows -
>
> ... while talking to mh2.cts.com.:
>  >>> RCPT To:<[EMAIL PROTECTED]>
>
> <<< 550 <[EMAIL PROTECTED]>... Relaying denied
> 550 5.1.1 <[EMAIL PROTECTED]>... User unknown
> Reporting-MTA: dns; smtp15.singnet.com.sg
> Received-From-MTA: DNS; bb-203-125-107-187.singnet.com.sg
> Arrival-Date: Sat, 30 Nov 2002 10:43:47 +0800
> Final-Recipient: RFC822; [EMAIL PROTECTED]
> Action: failed
> Status: 5.1.1
> Remote-MTA: DNS; mh2.cts.com
> Diagnostic-Code: SMTP; 550 <[EMAIL PROTECTED]>... Relaying denied
> Last-Attempt-Date: Sat, 30 Nov 2002 10:46:59 +0800
> Return-Path: <[EMAIL PROTECTED]>
> Received: from hemant.singnet.com.sg (bb-203-125-107-187.singnet.com.sg
> [203.125.107.187])
> by smtp15.singnet.com.sg (8.12.6/8.12.6) with ESMTP id gAU2hlj0008866;
> Sat, 30 Nov 2002 10:43:47 +0800
> Message-Id: <[EMAIL PROTECTED]>
> X-Sender: [EMAIL PROTECTED]
> X-Mailer: QUALCOMM Windows Eudora Version 5.1.1
> Date: Sat, 30 Nov 2002 10:37:17 +0800
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> From: Hemant K Chitale <[EMAIL PROTECTED]>
> Subject: Re: Recipe for application design to run on RAC
> In-Reply-To: <[EMAIL PROTECTED]>
> Mime-Version: 1.0
> Content-Type: text/plain; charset="us-ascii"; format=flowed
> ===
>
>
> Hemant K Chitale
> My web site page is :  http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Table - Extents

[Anand Kumar N]

Is there any restriction 
that the segments shouldn't cross more than 5 extents in oracle 
7.3.
 
Pl. help me, as I heard 
from somebody that the segments shouldn't cross more than 5 extents and my 
indexes are in more than 20 extents.
 
Thanks in 
advance
 
Anand 
KumarDBA
ITW 
Signode India 
Ltd

Re: instance and database

[Jeff Herrick]

1) Identify the database you wish to start using an environment
   variable (good old DOS)

c:\> set ORACLE_SID=SID1
c:\> svrmgrl

  You can also use LOCAL=SID1...It will override ORACLE_SID
  Both of these variables can also be set in the registry under
  HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful
  to 'hide' a remote database so that you don't have to specify
  'connect user/passwd@remotedb' you can just 'connect user/pass'

  You can also set either at the System environment level using a
  right-click on My Computer / Properties / Environment using
  variable names LOCAL or ORACLE_SID

  It's good form to do a 'select * from V$database' after you
  connect to make sure you are working on the right database  =8-0

2) A database can be opened by multiple instances when it's
   configured in an OPS (Oracle Parallel Server) environment.
   Not to sound 'flip' here but I wouldn't worry about OPS until
   you get your mind around how a single instance works :)
   OPS is now known as RAC - Real Application Clusters

Cheers

Jeff Herrick

On Sat, 30 Nov 2002, john wrote:

> Oracle 8i on NT4.0
>
> via the Oracle Database Configuration Assistant create another
> database.
> ie create another database with its instance and by default the
> db name and instance are same. say i proceed forward and create it.
> so now the box would have 2 separate services...
> OracleService
> OracleService
>
> is that correct ?
> question:
> if yes then next if i would start the svrmgrl and do a startup then
> which instance would be started ? is there a way to give the
> startup command to get only a particular instance started ?
>
> Next, the docs mention that it is possible to have two or more
> instance(s) associated with a given database. The above example
> shows two separate database, each with its one unique database.
> So how does one implement or have 2 instances for a given database
> ?
> can someone explain the difference between the two scenarios ?
>
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: john
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: instance and database

[sstefick]

>= Original Message From [EMAIL PROTECTED] =
>Oracle 8i on NT4.0
>
>via the Oracle Database Configuration Assistant create another
>database.
>ie create another database with its instance and by default the
>db name and instance are same. say i proceed forward and create it.
>so now the box would have 2 separate services...
>OracleService
>OracleService
>
>is that correct ?
-->  Yes this is correct.


>question:
>if yes then next if i would start the svrmgrl and do a startup then
>which instance would be started ? 
--> The default instance.


>is there a way to give the startup command to get only a particular instance
>started ?
-->  Yes, set the ORACLE_SID environment variable to the SID that you want 
started and just issue "startup" in svrmgrl.



>Next, the docs mention that it is possible to have two or more
>instance(s) associated with a given database. The above example
>shows two separate database, each with its one unique database.
>So how does one implement or have 2 instances for a given database
>?
-->  I believe you have to have RAC/Parallel Server for this kind of setup.  
I've never had a reason to do this. Hopefully someone else who has done this 
before could shed more light on this topic.

>can someone explain the difference between the two scenarios ?
-->  I can't answer this one for you.  Sorry.

-Scott Stefick

>
>
>__
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: john
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sstefick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: instance and database

[Richard Ji]

Before you get into svrmgrl, check your %ORACLE_SID% environmental
variable.  Whichever SID it's set to, that's the database you are
going to startup/shutdown.  You can do "set ORACLE_SID=NEW_SID" to
change it.

Having two or more instances associated with a database is called
Oracle Parallel Server (pre-9i) or Real Application Cluster (9i).
You would need a cluster of minimum two nodes with a shared disk
to implement it.  It's possible to set up RAC on a single node
under Windows or Linux.

Regards,

Richard Ji

-Original Message-
Sent: Saturday, November 30, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i on NT4.0

via the Oracle Database Configuration Assistant create another
database. 
ie create another database with its instance and by default the
db name and instance are same. say i proceed forward and create it.
so now the box would have 2 separate services...
OracleService
OracleService
 
is that correct ?
question:
if yes then next if i would start the svrmgrl and do a startup then
which instance would be started ? is there a way to give the
startup command to get only a particular instance started ?

Next, the docs mention that it is possible to have two or more
instance(s) associated with a given database. The above example
shows two separate database, each with its one unique database. 
So how does one implement or have 2 instances for a given database
? 
can someone explain the difference between the two scenarios ?


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: john
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: redo log file setup with mirrored drives

[Stephen Lee]

> -Original Message-
> We hope by
> eliminating redo log multiplex, but with OS mirroring we 
> can speed up this loading process.

--

We deal with this by:

1.  Hardware mirroring of archives.
2.  Archives go to device on which no other I/O is present and, if there is
a difference in the speed of devices in the system (for example 7200 rpm
drives and 1 rpm drives), the archives get the faster drives.
3.  Alternating online redo between different devices, the theory being that
when a log switch occurs then the log being archived will be on a device
that is not being written to, so (we hope) the reads from that device will
be faster.

Even after making the archiving as fast as possible, you still might be
required to have a very large amount of online redo available in order to
handle the backlog built up during peak times.  We have found that archiving
is so much slower than online redo writing in a case like this, that we can
Oracle multiplex online redo to hardware RAID (redundant redundancy) and the
archiving will still be the slow point.

I wouldn't worry about the fault tolerance aspect of online redo mirroring,
since whatever would blow away both sides of a hardware or OS mirror would
also blow away both sides of Oracle multiplexing.  However, my experience
has shown that, as far as any debate on how one mirrors online redo the
point is moot.  My experience is that, in this scenario, the archiving is
what will snag things.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: logical tuning

[Reddy, Madhusudana]

Thanks a bunch Ferenc and Dennis,
I actually expected a CASE study which you have developed on some of tools /
3rd party Apps, But have got some nice tips . I shall follow them

Thanks
Madhu


-Original Message-
Sent: Friday, November 29, 2002 7:14 PM
To: Multiple recipients of list ORACLE-L


Madhu

To be perfectly honest, I had an unfair advantge as I worked in Siebel 
Expert Services for 2.5 years, flying all over the world, with a broom in 
one hand and a mop in the other, cleaning mess after mess at customer 
sites,where usually the integrator stuffed things up mainly due to 
ignorance on almost all fronts. I then spent a good portion of this year in 
Siebel Engineering where I was their lead performance engineer for the 
Siebel Analytics and Marketing products on Oracle.Then in August, I finally 
had enough and quit.

I don't know that there is a top 10 list. But always the 3 golden rules for 
being a good DBA:
1. know your data.
2. know your data.
3. know your data.
Everything is supplementary after that.

Regards :

Ferenc Mantfeld

-Original Message-
From:   Reddy, Madhusudana [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, November 29, 2002 10:34 PM
To: Multiple recipients of list ORACLE-L
Subject:FW: logical tuning

Dennis & Ferenc,
Your discussion is a good read ...

You guys are able to understand how your applications are working WITH
Oracle, like using RULE/COST optimizer , Table Scans and also how it is
using the Oracle capabilities. I also wanted to know more about the
application running on top of Oracle . Would you guys GUIDE me with some
steps ( may be top 10 and how to do that ) , or you have any document which
you have prepared in the past will be great help for guys like me who 
wanted
to know more :))-

This LIST is always been a great HELP for me... Happy Thanks giving to YOU
ALL.

Thanks
Madhu


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/27/2002 4:28 PM

Ferenc
   Thanks so much for providing an insight into what you do. Lawson uses
Oracle in quite a simpler method. No joins, just individual table
access. No
table scans, each access is hinted to use a specific index. Crude but
effective. The first issue is that it doesn't use all of Oracle's
capabilities. The second issue is that it provides little opportunity
for
Oracle tuning experts such as yourself. But customers keep pressing for
better use of Oracle, so there is hope yet. ;-)
   Based on what I've seen out of Lawson and wait statistics, I'm
applying
my efforts to reducing physical I/O. I just configured several tables
for
the KEEP and RECYCLE pools.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, November 27, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Dennis

as you know, there is no 'follow these steps to get a better performing
application' guide when it comes to tuning. An intimate knowledge of
what
the application does is a must. I sell myself (tried the street corners
but
was not getting much intrest) as a Siebel performance tuning specialist,
so
when customers say 'Oh, you are an Oracle DBA !', I respond with 'No,
Oracle DBA is just one of the things I do in order to get my job done'.
there are plenty of DBA's out there, (and DBB's too), but understnading
how
the application (in my case Siebel) works and what it is trying to
accomplish from a functional perspective helps me to know immediately
what
is the framework of limitations I can work in. For instance, Siebel is
written for RBO, so when someone comes spouting partitions and bitmap
indexes, I buzz them out on try 1.

now for Siebel specific EIM (Enterprise Integration Manager) type tuning
,
when I see that index range scans are killing me, I try to reduce the
batch
size first so that it will not have to go through as many records per
value
(think of a batch size of 20,000 records where it is doing a correlated
subquery on just the batch_id). Now change this into 100 batches of 200
rows each, and immediately you have a huge saving in logical IO, since
each
time excpet the first iteration, the index blocks and table blocks
should
be found in DBBC (Also see Cary's paper on www.hotsos.com which goes
into
deeper details on the latches needed and the recursive calls for buffer
hits.) Other things include looking at SQL where you can see it is using
an
index to look up a row in the table to get a single value (column). In
this
case, for a large load, it may be beneficial to recreate this same index

with the column concatenated on the end, and avoid the table lookup
altogether. Also knowing EXACTLY how RBO works (there are only about 20
rules and in reality only 5 or 6 get used in an application), will help
you
to know when it may even be beneficial to DROP an index (gasp ! can he
be
serious ? Youbetcha ! ). anyway, that is it for today, class dismissed.

Have a great day !

Ferenc Mantfeld

-Original Message-
From:   DENNIS WILLIAMS [S

instance and database

[john]

Oracle 8i on NT4.0

via the Oracle Database Configuration Assistant create another
database. 
ie create another database with its instance and by default the
db name and instance are same. say i proceed forward and create it.
so now the box would have 2 separate services...
OracleService
OracleService
 
is that correct ?
question:
if yes then next if i would start the svrmgrl and do a startup then
which instance would be started ? is there a way to give the
startup command to get only a particular instance started ?

Next, the docs mention that it is possible to have two or more
instance(s) associated with a given database. The above example
shows two separate database, each with its one unique database. 
So how does one implement or have 2 instances for a given database
? 
can someone explain the difference between the two scenarios ?


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: john
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table Locks

[Govind.Arumugam]

We run the following script every 20 minutes to identify the pending transactions ( to 
be committed) and notify the appropriate application group (online or batch ) to take 
action in consultation with the DBA group.

We filter this by username since we have some convention for batch programs and online 
programs; We set thresholds for minutes_pending > 5 minutes for onlines and > 60 for 
batch.

select sysdate, '1' inst_id, sid, serial#, username, substr(terminal,1,10) termi
nal, osuser,
   t.start_time, r.name, t.used_ublk "ROLLB BLKS",
   decode(t.space, 'YES', 'SPACE TX',
  decode(t.recursive, 'YES', 'RECURSIVE TX',
 decode(t.noundo, 'YES', 'NO UNDO TX', t.status)
   )) status, round( ( sysdate - TO_DATE( start_time, 'MM/DD/YY HH24:MI:SS')
 ) *24*60 ,0 ) minutes_pending
from v$transaction t, v$rollname r, v$session s
where t.xidusn = r.usn
  and t.ses_addr = s.saddr
order by t.start_time;

Hope this helps.

Govind

-Original Message-
Sent: Saturday, November 30, 2002 12:39 AM
To: Multiple recipients of list ORACLE-L


Seems to me you should just have your program try to lock tables in
exclusive mode.  If it succeeds, then rollback.  If it fails
(timeout), it opens another session while the 'lock table' is waiting,
and finds the blocker.

Otherwise, if you are only interested in sessions that are actually
blocking other sessions, just look in v$lock where block = 1.

As interesting as it seems, I think you won't succeed in trying to put
triggers on x$kgllk or anything like that.  They're not real tables -
just table-like accessors for memory structures in the SGA.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Fri, 29 Nov 2002, [EMAIL PROTECTED] wrote:

> I would like to send an alert message to a client when a data row is 
> locked for more than a certain period of time. For this can I write 
> triggers on the system tables. If so on which table should I write a 
> trigger to retrieve the table lock information. Are there any implications 
> on writing triggers on the system tables.
> 
> The alert message should be sent automatically in the sense, can I write 
> an alert and signal it from a trigger written on some system table where 
> the lock information is available?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Re: Effect of Upgrading O/S to the 817 database !!!

[Jackson Dumas]

Thanx for your response guys. Actually I did not have to install a new
software, immediate after upgrade straight from NT to 2000 it worked
like a charm, just started the database and walla, it was up and
running, no hassles.

Thanx

Jackson


On Fri, 29 Nov 2002 22:08:38 -0800
([EMAIL PROTECTED]) wrote:

>If ur upgrading from nt 5 to 2000 then he first opt should work. Just
>install oracle on w2000 and start up the db coz the services are n
nt. but
>if ur goin in for a fresh install of w2000, it is better to create a
fresh
>db and import.
>Alternatively u can create a db with the same config of existig db
and copy
>the old db folder with that of ur new one.
>hope this should work. wishes.
>Regards,
>
>Sathyanarayanan
>
>
>
>
>|+--->
>||  "Jackson |
>||  Dumas"   |
>||  ||  il.co.za>|
>||   |
>||  29/11/2002   |
>||  18:33|
>||  Please   |
>||  respond to   |
>||  ORACLE-L |
>||   |
>|+--->
>  >--|
>  |  |
>  |   To: Multiple recipients of list ORACLE-L   |
>  |   <[EMAIL PROTECTED]> |
>  |   cc: (bcc: Sathyanaryanan K/VGIL)   |
>  |   Subject: Effect of Upgrading O/S to the 817|
>  |   database !!!   |
>  >--|
>
>
>
>
>
>Hi
>
>We are currently running Oracle 817 database on a Windows NT, version
>5, service pack 6. We need to upgrade O/S to Windows 2000. What
should
>we do on the database side, do we need to do a new Oracle 817
software
>installation after upgrading O/S and try to startup the database or
do
>we need to do everything from scratch, i.e. install software, create
>database and import ?  I tought this should not have an effect on the
>database, if that the case, do we then need to just try to startup
the
>database after O/S upgrade ? Please help ...your response will be
>highly appreciated. Desperado
>
>___
> http://www.webmail.co.za the South-African free email service
>
>  NetWiseGurus.Com Portal - Your Own Internet Business Today!
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jackson Dumas
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>

___
 http://www.webmail.co.za the South-African free email service

  NetWiseGurus.Com Portal - Your Own Internet Business Today!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jackson Dumas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).