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]) 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 | || tjaros@webma| || 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).
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 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).
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 OracleServiceSID2 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: 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 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
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, 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: 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 (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... OracleServiceSID1 OracleServiceSID2 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: 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 have 2 separate services... OracleServiceSID1 OracleServiceSID2 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
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... OracleServiceSID1 OracleServiceSID2 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).
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 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).
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 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: 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 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... OracleServiceSID1 OracleServiceSID2 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: 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. 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.evdbt.com/MythsExtPerf.doc http://www.dbatoolbox.com/WP2001/spacemgmt/Myths%20About%20Extents.pdf 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: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] 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).
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 e.g. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP (108M temp space, ). If I do subsets, selects, whatever, theviewsare 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: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 [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).
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 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: 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. 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
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: 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 http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.unix.shell http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.lang.perl Deshpande, Kirti kirti.deshpande@vTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: 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 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... OracleServiceSID1 OracleServiceSID2 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 --
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] 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... OracleServiceSID1 OracleServiceSID2 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: 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,
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 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.dochttp://www.evdbt.com/MythsExtPerf.doc http://www.dbatoolbox.com/WP2001/spacemgmt/Myths%20About%20Extents.pdfhttp://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 advanceAnand 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).