Re: SharePlex

2003-08-10 Thread Mladen Gogala
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

RE: database hanging during mount

2003-08-10 Thread Mladen Gogala
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

Re: After Logon Trigger and Import

2003-08-10 Thread Prasada . Gunda
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

RE: PERL reference

2003-08-10 Thread Jesse, Rich
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

ora-600 when analyzing IOT

2003-08-10 Thread Igor Neyman
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,

FW: RMAN Backup piece being placed in wrong directory

2003-08-10 Thread Stefick Ronald S Contr ESC/HRIDD
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

RE: ** is there PL/SQL for case

2003-08-10 Thread A Joshi
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

2003-08-10 Thread Mercadante, Thomas F
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

RE: SharePlex

2003-08-10 Thread Tim Onions
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

Re: Consolidating Servers

2003-08-10 Thread Tim Gorman
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

RE: 100 instances on same server !!!

2003-08-10 Thread Adams, Matthew (GECP, MABG, 088130)
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,

RE: Multiple Datafiles and performance?

2003-08-10 Thread Fermin Bernaus
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

Re: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-10 Thread rgaffuri
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

RE: why does block cleanout incur redo?

2003-08-10 Thread Cary Millsap
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,

RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-10 Thread Jesse, Rich
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

RE: ** is there PL/SQL for case

2003-08-10 Thread Igor Neyman
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,

RE: TNS errors

2003-08-10 Thread Ken Hitchcox
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

RE: URGENT: Trying to duplicate database from cold backup - auxi

2003-08-10 Thread Jared . Still
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:

Re: Implementing different document types with different attribut

2003-08-10 Thread John Thomas
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

Re: SharePlex

2003-08-10 Thread Tanel Poder
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

RE: Q. To RAC or go vertical

2003-08-10 Thread tjambu_fatcity
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

rman implementation

2003-08-10 Thread Sai Selvaganesan
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

2003-08-10 Thread Avnish.Rastogi
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

RE: Can't insert into partition

2003-08-10 Thread Wolfgang Breitling
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.