Re: SharePlex
On 2003.08.09 09:39, Tanel Poder wrote: MessageHi! Mladen, does DG really have additional fee when using EE? I tried to check from oraclestore, but got - instead: Tanel, my @#$%! Adelphia Cable connection is down more or less throughout the day today, so I cannot check at the Oracle Store, but I'm reasonably certain that both Data Guard and Oracle Streams are sold separately. As for this email, I'm using my local sendmail, which will deliver the message whenever the connection is restored. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: database hanging during mount
Title: Message Get a drink, put some nice CD in the player and call (800) 223-1711. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank KesselSent: Friday, August 08, 2003 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: database hanging during mountI am running Oracle 8.1.7.4 on Solaris 8. I recently decided that I needed more space on the disk partitions that hold my Oracle databases. The machine I am running on didn't have room for more disks so I decided to nfs mount partitions from another machine. I backed up the existing partitions resized the one partition that I have locally and nfs mounted the other 3 partitions and restored all the partitions.The problem is when I try to STARTUP the database it hangs during the mount of the database. I am able to successfully STARTUP NOMOUNT. The instance starts then on the mount I receive the following in my trc file:ORA-00600: internal error code, arguments: [2116], [900], [], [], [], [], [], []ORA-00600: internal error code, arguments: [2116], [900], [], [], [], [], [], []From what I can determine this indicates that ORACLE is unable access the control file...permissions appear to be correct. Any suggestions on what I need to check? Any known problems with control files over a nfs mount?Thank youFrank Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: After Logon Trigger and Import
Thanks very much Arup for your suggestion. Actually, Tables and indexes are already exist in the schema. I just have to copy the data from one environment to other environment. So I thought I will make the indexes unusable, load the data and rebuild the indexes with nologging, parallel and compute statistics. Best Regards, Prasad 860 843 8377 Arup Nanda [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: Re: After Logon Trigger and Import [EMAIL PROTECTED] .com 08/05/2003 08:29 PM Please respond to ORACLE-L Prasad, You can use SKIP_UNUSABLE_INDEXES=Y as an import parameter. But then again, why do that? Why not just impirt with INDEXES=N and then rebuild the indexes in parallel and with NOLOGGING? HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:19 PM Sorry, I forgot to mention the OS and Oracle Version. It is Hp-UX v11 and Oracle 8.1.7.4 Thanks. Best Regards, Prasad 860 843 8377 Prasada R Gunda To: [EMAIL PROTECTED] 08/05/2003 12:21 cc: PM Subject: After Logon Trigger and Import(Document link: Prasada R Gunda) Hi, I put the 'alter session set skip_unusable_indexes=true' in the logon trigger of a particular user and tested it in the sql*plus session. It is working fine there. I tested it by making an index unusable and inserting the data into the table. But, when I tried to import (using the same user) the data into that table, It gives an error saying that 'Index is in unusable state'. Does logon trigger fire for the Import? Is there any way to verify that the skip_unusable_indexes is set to 'true' for a particular session. Thanks in advance for your help. Best Regards, Prasad 860 843 8377 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Arup Nanda 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
RE: PERL reference
Learning Perl from O'Reilly: http://www.oreilly.com/catalog/lperl3/ US $21.50 from bookpool.com: http://www.bookpool.com/.x/n6ardwv1ni/sm/0596001320 Got me going enough to start writing an OEM replacement in Perl/Tk. I didn't say it was *good*...(or finished). :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Bala Regupathy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Subject: PERL reference Pardon me if you have already come across this, can anyone please suggest a good book on PERL for beginners. Thanks, Bala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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).
ora-600 when analyzing IOT
Ok, since my original message still hasn't arrived (sent couple hours ago), here it goes again (sorry, if you get duplicate). First, sorry for asking this list before searching Metalink, but I don't have access to it right now. So, here it is: I'm getting: ORA-00600: internal error code, arguments: [15163], [333], [17424], [16191], [], [], [], [] when analyzing one of the index-organized tables: ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS. Now, similar statement analyzing other IOTs works fine. Also, on the same table (ipn_measurement) analyze worked fine yesterday, and the table didn't grew too much since yesterday. Any ideas? Another question, do I really have to run analyze table on IOT for cost-based optimizer, or analyzing index would be enough: ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS because analyze index still runs with no errors. Oracle version is 8.1.5. Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman 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).
FW: RMAN Backup piece being placed in wrong directory
Title: Message Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBFinput datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBFinput datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBFinput datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBFchannel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting full datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBFinput datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBFinput datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBFinput datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBFchannel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting full datafile backupsetchannel ORA_DISK_3: specifying datafile(s) in backupsetinput datafile fno=1 name=D:\ORACLE\EWFMS\SYSTEM01.DBFinput datafile fno=4 name=D:\ORACLE\EWFMS\DRSYS01.DBFinput datafile fno=5 name=D:\ORACLE\EWFMS\INDX01.DBFinput datafile fno=7 name=D:\ORACLE\EWFMS\USERS01.DBFchannel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1FEU5O8D_1_1.BAK comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:46channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1EEU5O8D_1_1.BAK comment=NONEchannel
RE: ** is there PL/SQL for case
Thanks everyone : Guang, Rajendra, Funny 2, Daniel Fink, Deb, Jayadas, Igor, Rick, rgriffy for your prompt help. Now I have better understanding. Appreciated. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: Consolidating Servers
I would consolidate and migrate at the same time. It makes your job a little more complicated (you will want to test your applications on 9i before you mograte your production instances at some point), but you will be solving the migration to 9i sooner rather than later. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 06, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Just got out of a meeting with my manager. He had just finished meeting with our Oracle rep and has finally figured out that we don't have enough licenses (I've always asked him what we have and he's never shared it with me, always just I've gotten it taken care of). We have 80 and with our current/potential configuration we are going to need 300. Anyways, to save money he decides that we need to take our databases and consolidate them to two or three servers (from 7). Most of the database are fairly small (100-300Meg) so shouldn't be too bad. Actually it should be pretty fun (if I didn't already have 5 full-time jobs to do). Anyone had to do the same thing? What are some concerns? Should I shoot for the moon and upgrade them all to 9i at the same time or have several versions (7.3, 8.0, 8.1.7) on the same server? Any comments would be greatly appreciated. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff 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.net -- Author: Mercadante, Thomas F 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: SharePlex
Title: Message I'll add one to the list: nnn) How much downtime and DBA time is required when the Shareplex replication queues get corrupted and you have to rebuild your entire replicated database? (I only add that as I've got to do it tomorrow morning). T¬ From: Nick Wagner [mailto:[EMAIL PROTECTED]Sent: 09 August 2003 00:04To: Multiple recipients of list ORACLE-LSubject: RE: SharePlex I know a little of their product... but I think you should be well aware of the limitations before attempting to implement it. Here are a couple of questions to ask the technical folks over there... 1)What happens when someone applies an Oracle Financials patch to the system. What is the procedure? 2) Do you have anyone else running Financials 11i thatyou could talk to as a reference? 3) Do they support IOT's? (Which Financials has a lot of) 4) How much downtime is normally associated with something like adding a new table or dropping one from replication? Nick -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 3:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SharePlex We are not running 9i but 8.1.7.4, sorry for not including that earlier. We are rolling out to our international offices and we basically have offices in every time zone. I'm looking at SharePlex for HA, reporting use, and potentially migrating from HP to Linux. They will be on Linux next month. Allan -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SharePlex Nelson, SharePlex does the same basic thing that Oracle does for the logical standby, as a matter of fact if your running 9i why not use that instead of Quests's pricey tool? I don't believe there is any additional cost to using logical standby over the second server license that your going to have to pay anyway. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex Hello, Quest is trying to sell us a product named SharePlex. It sounds very attractive, but then sales people are supposed to be good at that. We are a mid sized company, about 2.2 billion per year, running Financials 11.5.7. We are interested in this for HA and for reporting instance use. rant We use Cognos as our query tool and the owners of this product tells me that we can't tune the SQL it emits. It makes pretty poor choices, which is not surprising for a gooey, sticky tool designed for end users. It is sort of pretty and if you can drool you too can generate cross products. Anyway , I'd like to get them off the production box. rant/ Does SharePlex allow you to stay close to the production instance in time? Does the store and forward work well? Do you love it? Hate it? Anything you'd like to say about this product I'd like to hear Thanks in advance Allan L. NelsonOracle DBA M-I L.L.C.(832) 295-2238 office(832) 351-4180 fax[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
Re: Consolidating Servers
Jeff, Don't mix missions. Consolidating to the same server is one thing. Consolidating to the same version of software is another thing entirely. Your boss's goal is to reduce the number of CPUs, not the number of databases or ORACLE_HOMEs. Get his/her primary mission done first (i.e. Reduce number of CPUs to license), then consider consolidating databases or versions. So, I'd recommend copying entire directory structures to the remaining servers, each under different OS accounts/groups. My $0.02... -Tim on 8/6/03 11:29 AM, Eberhard, Jeff at [EMAIL PROTECTED] wrote: Just got out of a meeting with my manager. He had just finished meeting with our Oracle rep and has finally figured out that we don't have enough licenses (I've always asked him what we have and he's never shared it with me, always just I've gotten it taken care of). We have 80 and with our current/potential configuration we are going to need 300. Anyways, to save money he decides that we need to take our databases and consolidate them to two or three servers (from 7). Most of the database are fairly small (100-300Meg) so shouldn't be too bad. Actually it should be pretty fun (if I didn't already have 5 full-time jobs to do). Anyone had to do the same thing? What are some concerns? Should I shoot for the moon and upgrade them all to 9i at the same time or have several versions (7.3, 8.0, 8.1.7) on the same server? Any comments would be greatly appreciated. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: 100 instances on same server !!!
Right now I have 37 instances on an hp-ux server, a mix of 8.1.7.4 and 9.2.0.3 Matt Adams - GE Appliances - [EMAIL PROTECTED]We are pentium of Intel. Division is futile.You will be approximated. -Original Message-From: Dilip Patel [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 100 instances on same server !!! Thanks for the replies so far. Considering the fact that my database is tiny ( just around 3 GB ), How many of them can work on same server? I can just test with 5 instances, with limited hardware. Will the CPUs be able to take load of 100 instances? Is it worth experimenting this? I am on 8.1.7.4 and the application is already built. I stand no chance of changing the code. That is why using individual schemas for individual users is not an option. Right now I am just asked if 100 instances can run on same server and I dont have solid answer. Just on side note, canI ask, What is the maximum number of instances anyone has ever worked/heard being installedwith in same server? Thanks again. Dilip. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 11:54 AM Subject: Re: What books recommended for Data Modeling ? 100 instances woh . If you are in 9i look at possibilities like contextor label security . or creating another schema .-ak- Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 9:24 PM I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundredtrainees at a time. For this he wants to install hundred database instances onsame server machine, which *each* will be accessed simultaneously from 100different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each roundof training. - No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible.Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardwareneeded for this setup. Thanks in advance for your time. Dilip. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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.net-- Author: AK 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: Multiple Datafiles and performance?
There was a similar problem under HP-UX systems (I believe it was on version 10.0) in which the file size was limited to 2Gb, then they released a patch so that files could get bigger than 2 Gb after setting a parameter and recompiling the kernel. Under version 11.0 this was fixes (yet the parameter still exists). Sorry I have no exact documentation on this issue at hand and what I am writing could not be exactly right. Fermin. -Mensaje original- De: Thomas Day [mailto:[EMAIL PROTECTED] Enviado el: jueves, 07 de agosto de 2003 18:09 Para: Multiple recipients of list ORACLE-L Asunto: RE: Multiple Datafiles and performance? I don't know of any advantage to uniform datafile sizes. Back in the day some DBAs preferred uniform datafile sizes so that they could easily move datafiles from disk to disk to balance physical IO. With modern disk configurations this strikes me as more work than it's worth. However, if you really, really need that last little bit of umph then it is a consideration. 4x1 or 2x2 - 4x1 has more things to keep track of. Otherwise, to the best of my knowledge it's not an issue. If a datafile autoextends to the 2G mark, under certain service pack releases of Win2k the datafile becomes corrupted. As I remember the discussion, MS had fixed one of their disk IO dlls to work over the 2G mark but it the datafile size was under 2G the disk IO was handled by a program that could not handle growing to 2G. So if the datafile was over 2G you wouldn't run into the problem. MS does have upgrades to fix the problem. Has your SA applied them? I've been reading various white papers about RAID 10 vs. RAID 01 (mirror-then-stripe vs stripe-then-mirror). I've heard good arguments on both sides and I hope that the experts can come to a consensus. Only RAID manufacturers seem to be pushing RAID 5. Right now Oracle's recommendation is SAME (Stripe All, Mirror Everything). It is not the absolutely optimal situation but it will provide adequate performance in most situations. HTH Dave Phillips dphillips To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @gasper-corp.com cc: Subject: RE: Multiple Datafiles and performance? Sent by: ml-errors 08/07/2003 11:24 AM Please respond to ORACLE-L Gee, that question sounded a whole lot better when I wrote it yesterday than it did this morning when I saw it. :) Maybe I should be a little more vague.:) The problem is there are a couple of things I am trying to accomplish. We have clients that use our application that have specific performance issues which I am working to improve. The other issue is to provide recommendation to development/tech staff on initial setup of database/tablespaces/datafiles etc.., along with hardware recommendations for our application. So, that being said, I'll try and ask better questions. The environment is W2K, Oracle 8.1.7.2 or higher All tablespaces are LMT Most disk config's are 1 (or 2) Raid 1 along with a Raid 5 for basic systems. Most operate application 24/7 Questions: 1) Is there any advantage to uniform datafile sizes? 2) Is there any advantage/disadvantage for say 4 1G datafiles vs 2
Re: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR
v$open_cursors is all open cursors in the instance v$sesstat is just open cursors in the session. what 3rd party product is that? is it cross platform? Ill make sure not to buy it. really bad code to get too many open cursors. From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/08/07 Thu PM 04:14:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR No takers on this from the perf tuning gurus? Please don't make me open a TAR. Think of the children... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Thursday, July 24, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hey all, We recently had a problem with a 3rd-party app getting ORA-1000 max open cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500 in the init.ora -- should be more than generous for a tiny app on a tiny DB -- we started looking into how many cursors the app actually has open at any given time. While investigating this, I see that the number of rows in V$OPEN_CURSORS isn't consistent with the value of stat 3 (opened cursors current) of V$SESSSTAT. Of the two processes I looked at, each had a V$SESSSTAT value of 3 for stat 3, while the first had a single entry in V$OPEN_CURSOR and the second had four. Should these values match? I looked on Metalink but was unable to find any reference to the relationship between these, other than a forum article where the OraSupport person was extraordinarily unhelpful. TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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.net -- 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: why does block cleanout incur redo?
Its because flush doesnt mean what you probably think. During a delayed block cleanout, Oracle updates a blocks transaction table (ITL). Any time a block gets modified, theres redo. See Jonathan Lewiss Practical Oracle8i (pp4344) for a description. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic101 in Denver, Sydney - Hotsos Symposium 2004 March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: Wednesday, August 06, 2003 9:34 PM To: Multiple recipients of list ORACLE-L Subject: why does block cleanout incur redo? My understanding of block cleanout is that oracle is flushing transaction information of already committed transactions from the buffer cache. This can happen in selects, when 10% of the buffer cache is filled with 'lists' if blocks involved in transactions, or with dml. i dont understand why this incurs redo? your just flushing blocks that are no longer needed?
RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR
I should have known to check Steve's site first (is he still lurking around here?). One thing I noticed is that one of the cursors listed in V$OPEN_CURSOR is an INSERT into AUD$. This would account for the discrepancy and could match the description you provided. So, in summary, the true number of open cursors is correct in V$SESSTAT and is *not necessarily* the count of rows in the corresponding V$OPEN_CURSOR view. And my apologies to the sticklers of the list who have noticed my V$SESSSTAT and V$OPEN_CURSORS... sigh Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hi! This is troubleshooting, not performance tuning ;) As far as Ixora states, v$sesstat opened cursors current shows PL/SQL cached cursors as well, even when they are explicitly closed (assuming that session_cached_cursors is set). But v$open_cursor doesn't show the number of cursor structures in UGA, but it shows you (some kind of count) of parse locks which get created in SGA for a SQL statement or PL/SQL block. They provide a link from schema objects to shared SQL area, so the cursors can be invalidated when doing DDL on referenced objects. They are called breakable parse locks in Concepts Manual. As the name says breakable - even though you got a lock on schema object, you still can alter it, the lock is just broken, the cursor is invalidated (but remains cached in UGA) and has to be reloaded on next execution. Here we can have a situation, when as result of DDL, we don't have any breakable parse locks on SGA anymore, but we still have open cursors in UGA. Thus the difference between v$sesstat and v$open_cursor. (this story is based on Concepts manual and Ixora) But for ORA-1000 errors, you should maybe set event for ORA-1000 and dump errorstack. Or sample v$sesstat quite often (once per few seconds), to catch the point where number of open cursors jumps to ceiling (as I understand, it's fairly low normally). And for TAR's - I recommend you to do few Oracle Applications upgrades, especially to fresh versions of major new releases, such 11.5.1 or 2, then you start even seeing severity 1 TARs in your dreams ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 07, 2003 11:14 PM No takers on this from the perf tuning gurus? Please don't make me open a TAR. Think of the children... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Thursday, July 24, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hey all, We recently had a problem with a 3rd-party app getting ORA-1000 max open cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500 in the init.ora -- should be more than generous for a tiny app on a tiny DB -- we started looking into how many cursors the app actually has open at any given time. While investigating this, I see that the number of rows in V$OPEN_CURSORS isn't consistent with the value of stat 3 (opened cursors current) of V$SESSSTAT. Of the two processes I looked at, each had a V$SESSSTAT value of 3 for stat 3, while the first had a single entry in V$OPEN_CURSOR and the second had four. Should these values match? I looked on Metalink but was unable to find any reference to the relationship between these, other than a forum article where the OraSupport person was extraordinarily unhelpful. TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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 there PL/SQL for case
To overcome this in PL/SQL you can run sql, which includes case, as dynamic sql: EXECUTE IMMEDIATE SELECT Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guang Mei Sent: Thursday, August 07, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: ** is there PL/SQL for case Below is an example (with Oracle 8173),case works in sql, not in pl/sql. Guang [EMAIL PROTECTED] create table t1 (name varchar2(30), salary number ); Table created. [EMAIL PROTECTED] insert into t1 (name,salary) values ('Bill', 1000); 1 row created. [EMAIL PROTECTED] insert into t1 (name,salary) values ('George', 2000); 1 row created. [EMAIL PROTECTED] insert into t1 (name,salary) values ('Gore', 3000); 1 row created. [EMAIL PROTECTED] insert into t1 (name,salary) values ('Dick', 4000); 1 row created. [EMAIL PROTECTED] commit; Commit complete. [EMAIL PROTECTED] select * from t1; NAME SALARY -- -- Bill 1000 George 2000 Gore 3000 Dick 4000 [EMAIL PROTECTED] select count(case when salary 2000 then 1 else null end) poor, count(case when salary between 2000 and 3000 then 1 else null end) middle_class, count(case when salary 3000 then 1 else null end) rich from t1; POOR MIDDLE_CLASS RICH -- -- 1 2 1 [EMAIL PROTECTED] declare c1 number; c2 number; c3 number; begin select count(case when salary 2000 then 1 else null end) poor, count(case when salary between 2000 and 3000 then 1 else null end) middle_class, count(case when salary 3000 then 1 else null end) rich into c1,c2,c3 from t1; end; / select count(case when salary 2000 then 1 else null end) poor, * ERROR at line 6: ORA-06550: line 6, column 16: PLS-00103: Encountered the symbol CASE when expecting one of the following: ( * - + all mod null an identifier a double-quoted delimited-identifier a bind variable avg count current distinct max min prior sql stddev sum unique variance execute forall time timestamp interval date a string literal with character set specification a number a single-quoted SQL string -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of A Joshi Sent: Thursday, August 07, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: ** is there PL/SQL for case Guang, Thanks for your help. Do you have an example you can send me. I thought whatever one can do in sql one can do in pl/sql. meaning sql is a subset of pl/sql. Correct me if i am wrong. Thank You. Guang Mei [EMAIL PROTECTED] wrote: I am not sure in 9i. But in 8i I think you can use case in sql but not in pl/sql. You have to use if elsif in pl/sql. Guang -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of A Joshi Sent: Thursday, August 07, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Subject: ** is there PL/SQL for case Hi, Is there a statement in pl/SQL like case or is if elsif the only way. Meaning if I need to transalate state depending on input number asfollows : 1 - CA 2 - OR 3 - WA 4 - AR Can I have one statement like case 'state# : 1: state := 'CA' 2: state := 'OR' etc. or do i have to do : IF state# = 1 THEN state := 'CA'; ELSIF state# = 2 THEN state := 'OR'; etc Thank You. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: TNS errors
The Citrix ica calls a program called sams.exe and I don't know how it accesses the db. I haven't tried the console from the remote machine, just the citrix .ica file. More stuff for me to read... Ken -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Saturday, August 09, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: TNS errorsKen, I don't see your connection string in here, but I'm going to guess that it does not include '@TNS_NAME', which is what you will have to do when connecting via a client such as citrix. Remember, you're not really on the console, though it may look like it. Don't know how many times I did this with Terminal Services on Win2k before it finally sunk in. Jared "Ken Hitchcox" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/08/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:TNS errorsHi everyone,Been a very long time since I posted, but finally running into a problem.New system:Win 2k Server, Citrix XPe, Powerbuilder 5.0 App, Oracle 8i. If I run thePowerbuilder executable on the server, it connects to Oracle just fine.When I try to connect using Citrix (from this machine or a differentmachine) on the same network, I get TNS-12560, When I look at the nmi.log,I see:Fatal NI connect error 12560, connecting to:(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PROGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEMVERSION INFORMATION:TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NTProtocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - ProductionTime: 07-AUG-2003 10:48:22Tracing not turned on.Tns error struct:nr err code: 0ns main err code: 12560TNS-12560: TNS:protocol adapter errorns secondary err code: 0nt main err code: 530TNS-00530: Protocol adapter errornt secondary err code: 2nt OS err code: 0I'm STILL a newbie, you would think that after 5 years of managing my rinkydink database, I'd know something, but...Anyway, can anyone help me to resolve this problem? Yes, I will turntracing on as soon as I figure out how to for DBSNMP.Thanks,Ken HitchcoxPS Hi Rachael C still have DBA101 on my desk.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ken HitchcoxINET: [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: URGENT: Trying to duplicate database from cold backup - auxi
You heard him. Top men. ;) Verifying backups is something we do in our spare time, one of those skunk works projects we don't tell our bosses about. ;) Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 03:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Jared Okay, I'll bite. What do you mean about a separate project for verifying backups. It reminds me of the ending to the movie Indiana Jones - we have a team of top experts working on that, you know, the scene where they're packing the ark away in an enormous warehouse. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 05, 2003 5:19 PM To: Multiple recipients of list ORACLE-L auxi I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape unless absolutely necesssary. It's much faster to plug two servers into a gigabit switch and copy the files across a private network at approx 100 gigabytes per hour. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: URGENT: Trying to duplicate database from cold backup - auxi Robert - What I've done over the years is tie the creation of test databases to backup verification. The old issue of how can you trust your backups unless you've done a recovery. It has seemed that I get a request to build a test database at about the right interval to periodically verify the backup. It is nice to say that I would just periodically verify the backups, but like most DBAs, there is always a more pressing task. With RMAN, I assumed that I would continue this practice. It has been a pain, but I ended up with a method that works. The biggest problem is that when the test database is recovered, it initially has the same name as the production database, then I change the name. I would be interested how other sites that rely on RMAN handle this issue. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Implementing different document types with different attribut
If you're on Oracle 9i sounds like a perfect example of the use of hierarchical object types. Cheers, John In message [EMAIL PROTECTED], STEVE OLLIG [EMAIL PROTECTED] writes how about 2 tables w/ a 1:many relationship? document_types each with many document_type_attributes. read up on data modeling. i think several good books were mentioned on this list recently. -Original Message- Sent: Thursday, August 07, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Hello I've an installation/implementation question! We've to analyse 50 document types, in total those 50 has 70 different attributes. We don't want to put all those document types into one table, because more than the half (35) of the attributes are not always used for each document type. This will have to much disk space for each record, if most of the fields are just blank. Has anyone suggestions how to build our table-structure? I've heart something about FlexFields, what are they? Takes every field diskspace, even if it's blank (null)? Thanks in advance for the response! Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- John Thomas -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Thomas 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: SharePlex
Title: Message Hi! Mladen, does DG really have additional fee when using EE? I tried to check from oraclestore, but got - instead: "The Oracle Store is temporarily unavailable due to required maintenance. We apologize for the inconvenience. For further assistance, please contact an Oracle Sales Representative." They must be upgrading :) But for shareplex Financials issues, I think that Financials isn't probably supported running on "shareplexed" database. You ought to go with an Oracle solution, but I think logical standby mechanism is currently too buggy for a complex app (in sense of db feature usage)as Financials 11i (for example, materialized view refreshing has do be done manually IIRC, nested tables don't work, CTAS over dblinkmay failetc..). Your next option would be going with physical standby (opened as read only , but that depends on your MTTR constraint and how real-time your reporting environment has to be. Physical standby will be much more safe in sense of replicating data to stdby, but even with physical standby you have to worry about some logging issues, as some concurrent manager jobs do nologging operations etc. Luckily in 9i you can use alter database/tablespace force logging command to force logging on any nologging commands. OTOH, this might mean a performance hit. Note that when talking about Financials HA, you might also want to replicate/mirror concurrent manager output and log files in addition to database. You should really check metalink notes 216212.1 and 216211.1 when thinking Apps and standby. Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Saturday, August 09, 2003 2:04 AM Subject: RE: SharePlex Actually, logical standby database does have a hidden cost because you need Data Guard which is licensed separately. The product that mimics SharePlex is called Oracle Streams and it is a redo log based replication tool, sort of Logminer on steroids. By the way, logminer was published because of the Quest who reengineered the format of redo logsand based recovery mechanism on reading the changes from the logs and applying them to "replicated" database. Neither logminer, SharePlex nor Streams can handle DDL. One has to propagate schema changes using Quest Schema Manager or the same thing from Embarcadero or, for masochists, OEM Change Management Pack.Iusedevery expletive in the book while I was testing OEM and I even invented a few of my own. If you opt for any of those tools (and Data Streams is a pretty cool stuff, based on the demos, white papers from OTN, marketing brochures and spam about the database enlargement), you will also need a schema manager tool. Quest Schema Manager is a very good tool which I tested extensively. I'f you decide to go cheap and use trigger/stored procedures based replication ("advanced replication"), you'll need a gun, preferrably 44-magnum. That is known as "go ahead, make my data" option. Do you feel lucky? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Friday, August 08, 2003 5:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SharePlex Nelson, SharePlex does the same basic thing that Oracle does for the logical standby, as a matter of fact if your running 9i why not use that instead of Quests's pricey tool? I don't believe there is any additional cost to using logical standby over the second server license that your going to have to pay anyway. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex Hello, Quest is trying to sell us a product named SharePlex. It sounds very attractive, but then sales people are supposed to be good at that. We are a mid sized company, about 2.2 billion per year, running Financials 11.5.7. We are interested in this for HA and for reporting instance use. rant We use Cognos as our query tool and the owners of this product tells me that we can't tune the SQL it emits. It makes pretty poor choices, which is not surprising for a gooey, sticky tool designed for end users. It is sort of pretty and if you can drool you too can generate cross products. Anyway , I'd like to get them off the production box. rant/ Does SharePlex allow you to stay close to the production instance in time? Does the store and forward work well? Do you love it? Hate it? Anything you'd like to say about this product I'd like to hear Thanks in advance
RE: Q. To RAC or go vertical
Hi Jared Yes I have read his article and also Dave Ensor's thoughts in it. I personally am not convinced and am looking for reasons why I should go with RAC other than fault tolerance given the risk involve in being one of the 1st few genuine pigs. I probably say, I would go with single instance with lots of CPU in the 1st instance and then reconsider my options in about 12 months time. Hi Mogens, if you are reading, Tony here from melb. Do you have any thoughts on this and would you have an 'alternative' version of the article that you wouldn't mind sharing. ta tony At 09:04 AM 05/08/2003 -0700, [EMAIL PROTECTED] wrote: ... though now that I've read the original post ( missed it somehow ) I would say that you may just want a bigger box. See Mogen's article You Probably Don't Need RAC at selectonline.org. You may want to ask Mogens for an alternative version of the article, in fact, I think you should. Jared Jared Still [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 08:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Q. To RAC or go vertical While fault tolerance is certainly one of the features of RAC, it isn't correct to say that it is not also for scalability. Buy a bigger box? That works fine until you're in the biggest box you can get, then what? I realize that it's a small market segment that requires that kind of hardware, but it still exists. Sun has been testing a cluster of 15k servers with RAC, ostensibly for scalability. Some nodes are populated with 78 CPU's and 288 Gig of RAM. ( yes, that is correct ). Jared On Tue, 2003-08-05 at 07:54, Stephen Lee wrote: I think the point of RAC is fault tolerance, not scalability. If it's performance you want then you want a bigger box, not more boxes. 8 CPUs is not big. You sure don't need the expensive hardware if all you want to run is 8 CPUs. It would be better to go with a smaller frame and use the money you save to get more CPUs and additional I/O capacity. For example, instead of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans to push the E12K out to its limits in the future. Don't forget to consider the backup requirements of a 5 - 10 TByte database. Another consideration, I think, is that those big, fancy boxes require additional sys admin skills. -Original Message- Hi All I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu) Background Txn - OLTP like txn during day but batch extracts at night and very big batch extract periodically Data Volume - 5-10 TByte Data volatility - 99 % of data is very much like a ware house (unchanged) other 1% is read/update/delete/insert Options 1. Say a very large server like a HP Superdome or SUN E12000 with 8 CPUs Server already exist so cost is in obtaining additional CPU/Blades ie Traditional Server using plain old vanilla Oracle EE - can still increase head room. - batch programs can utilise all 8 CPUs - storage system need not cater for clustering 2, Same large server like a HP Superdome or SUN E12000 but partitioned into two. Each with 4 CPU. Oracle RDBMS + RAC option - storage server need to cater for cluster config - max performance for batch is with 4 CPUs only Which would you prefer and why. I am not convinced with the RAC option. Now if I was going with cheaper Intel servers like Dell servers with 4 CPUS each, and purchase say 4 nodes of 4 cpus each, that would be a different story. In this case I have the equipment and ability to grow vertically. ta tony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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
rman implementation
hi can someone give me pointers on pros and cons of implementing rman with netapp filers. any pointers,white papers,case study,implementation doc will be very helpful. thanks sai
RE: ORA-3113
I tried relinking all and rebooting server then relink again but no luck. -Original Message- Sent: Wednesday, August 06, 2003 10:10 AM To: Multiple recipients of list ORACLE-L left over memory segments/shared memory/semaphores? ipcs is your friend, oh and its destructive brother ipcrm :) joe [EMAIL PROTECTED] wrote: No, There is no log generated. Below is the only message I am getting. hp204:NAMES :/home/oracle svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-03113: end-of-file on communication channel SVRMGR -Original Message- Sent: Wednesday, August 06, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Any log file output? Mike -Original Message- [mailto:[EMAIL PROTECTED] Sent: 06 August 2003 16:29 To: Multiple recipients of list ORACLE-L Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database holds RMAN catalog for more than 30 databases and really very critical. Please share your ideas. I already tried to relink and rebooting the server. Database is 816 64bit on HP-UX 11.11 DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Can't insert into partition
No, you can put a hint in inner sql and subselects. Some hints you NEED to put on a subselect to make any sense. Is that sql verbatim? The hint has a syntax error. There is a dot rather than a comma after ps which - pooof - may turn the princely hint into an ugly toad (no pun intended) comment. Another thnig you can try, since you are using bind variables, is to jack up db_file_multiblock_read_count, hash_multiblock_io_count, hash_area_size, optimizer_index_cost_adj (to 1), create a stored outline of the sql - hopefully it will use hash joins with all the help, and then revert to the normal init_ora settings and tell oracle to use the stored outline. At 02:19 PM 8/7/2003 -0800, you wrote: Thanks Wolfgang! And thanks to the others who have helped us unravel this problem. Your suggestion put us on the right track. I started running a SQL trace/tkprof, and lo and behold, when the stored procedure submits the SQL, CBO does everything as NESTED LOOPS. The next question is how to induce CBO to consider HASH JOIN? The original query had USE_HASH hints on the subqueries. Somewhere I thought I recalled that you could only put hints on the outer SQL statement -- is that true? So we tried adding the USE_HASH hint to the overall INSERT statement, to no effect. Here is the relevant portion of the tkprof output. Thanks again to eveyone. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] INSERT /*+ APPEND use_hash(CJS, PS, APC, MD, C, WV1, WV) */INTO CURRJOBFACT NOLOGGING ( JOBNBR,SOURCEFISCALYEAR,LIFETOUCHID,PROGRAMID,MARKETINGCODE, PLANTRECEIPTDATE,PHOTOGRAPHYDATE,SHIPDATE,SELLINGMETHODCODE,MDRPRIMARYID, SUBPROGRAMCODE,TERRCODE,SUBTERRCODE,BIDIND,PDKIND,PDKPARTNBR,RETAKEIND, RETAKENBR,SHIPPEDJOBIND,PAIDJOBIND,PAYSTATUSIND,PAIDSHIPPEDJOBIND,PREJOBIND, PLANTCODE,SHOTQTY,MTDSHIPPEDPKGQTY,MTDCHARGEBACKAMT,MTDTERRCMSNAMT, MTDTERREARNINGSAMT,MTDCASHRECEIVEDAMT,MTDCASHRETAINEDAMT,MTDESTACCTCMSNAMT, MTDACCTCMSNPAIDAMT,MTDGROSSCASHAMT,MTDSALESTAXAMT,YTDSHIPPEDPKGQTY, YTDCHARGEBACKAMT,YTDTERRCMSNAMT,YTDTERREARNINGSAMT,YTDCASHRECEIVEDAMT, YTDCASHRETAINEDAMT,YTDESTACCTCMSNAMT,YTDACCTCMSNPAIDAMT,YTDGROSSCASHAMT, YTDSALESTAXAMT,YTDPERFECTSALEAMT,PRELIMYTDSHIPPEDPKGQTY, PRELIMYTDCHARGEBACKAMT,PRELIMYTDTERRCMSNAMT,PRELIMYTDTERREARNINGSAMT, PRELIMYTDCASHRECEIVEDAMT,PRELIMYTDCASHRETAINEDAMT,PRELIMYTDESTACCTCMSNAMT, PRELIMYTDACCTCMSNPAIDAMT,PRELIMYTDGROSSCASHAMT,PRELIMYTDSALESTAXAMT, PRELIMYTDPERFECTSALEAMT,YTDJTEPAIDPKGQTY,YTDPAIDPKGQTY,YTDUNPAIDPKGQTY, YTDXNOPURCHASEQTY,PRELIMYTDPAIDPKGSHIPQTY,PRELIMYTDUNPAIDPKGSHIPQTY, PROOFPOSEQTY,PROOFCOUNTQTY,EXTRACTDATE,ORIGINALRECEIVEDDATE,CMSNSTATUSCODE, FIRSTPOSITIVECASHDATE,RENEWALSTATUSCODE,ORIGESTACCTCMSNAMT,AVGPKGPRICE ) SELECT /*+ use_hash(cjs, ps. md, a, o, x, wv, apc, wv1) */CJS.JOBNBR, (columns omitted) PS.PRELIMYTDESTACCTCMSNAMT)) ORIGESTACCTCMSNAMT,APC.AVGPKGPRICE FROM CURRJOB_STAGE CJS,PERIOD_STAGE PS,MARKETINGDIM MD,(SELECT A1.JOBNBR, DECODE(SUM(PAIDOFFERQTY),0,0,SUM(A1.OFFERPRICEAMT * A1.PAIDOFFERQTY ) / SUM(A1.PAIDOFFERQTY) ) AVGPKGPRICE FROM (SELECT DISTINCT A.JOBNBR, A.OFFERNAME,A.PAIDOFFERQTY,A.OFFERPRICEAMT FROM OFFERLOAD_STAGE A WHERE A.OFFERNAME IN ( 'A','B','C','D','E','F','G','H','I','J','K' )) A1 GROUP BY A1.JOBNBR ) APC,(SELECT DISTINCT C.LIFETOUCHID,C.PROGRAMID, MD.MARKETINGCODE FROM CURRJOBFACT C,MARKETINGDIM MD WHERE C.SOURCEFISCALYEAR :b1 AND C.MARKETINGCODE = MD.MARKETINGCODE ) C, (SELECT JOBNBR,MIN(DEPOSITDATE) FIRSTPOSITIVECASHDATE FROM CASHTXNFACT WHERE SOURCEFISCALYEAR = :b1 GROUP BY JOBNBR ) WV1,(SELECT X.JOBNBR, X.WEEKENDDATE,X.PRELIMYTDESTACCTCMSNAMT FROM WKLYJOBFACT X,(SELECT JOBNBR, MAX(WEEKENDDATE) MAXWEEKENDDATE FROM WKLYJOBFACT WHERE SOURCEFISCALYEAR = :b1 AND NVL(PRELIMYTDESTACCTCMSNAMT,0) 0 GROUP BY JOBNBR ) W1 WHERE X.JOBNBR = W1.JOBNBR AND X.WEEKENDDATE = W1.MAXWEEKENDDATE ) WV WHERE CJS.JOBNBR = PS.JOBNBR (+)AND CJS.JOBNBR = APC.JOBNBR (+)AND CJS.MARKETINGCODE = MD.MARKETINGCODE AND CJS.LIFETOUCHID = C.LIFETOUCHID (+)AND CJS.MARKETINGCODE = C.MARKETINGCODE (+)AND CJS.JOBNBR = WV1.JOBNBR (+)AND CJS.JOBNBR = WV.JOBNBR (+) call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.01 0.01 0 0 0 0 Execute 1351.171349.5112086871212777866 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total2351.181349.5212086871212777866 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 21 (recursive depth: 1) Rows Row Source Operation --- --- 0 LOAD AS SELECT 0 NESTED LOOPS OUTER 1