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

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])

RE: Table Locks

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

instance and database

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... OracleServiceSID1

RE: logical tuning

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

RE: redo log file setup with mirrored drives

-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,

RE: instance and database

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

RE: instance and database

= 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

Re: instance and database

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

Table - Extents

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: Error on the ORACLE-L list

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

RE: logical tuning

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

Re: instance and database

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

RE: Table - Extents

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.

Re:Oracle 8.1.6 Installation error

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]

Views Resources (7.3.4 DB)

I have3 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

Re:is it possible ?

Not on HP-UX. Since the processes have names like 'ora_smon_SID' 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

Re: Error on the ORACLE-L list

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

Re: Views Resources (7.3.4 DB)

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.

RE: Error on the ORACLE-L list

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

RE: Anyone knowing about Unix groups

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=enlr =ie=UTF-8group=comp.databases.oracle http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.unix

Re: instance and database

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

RE: instance and database

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]

Re: Table - Extents

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