RE: tuning : file number translation table

2003-07-18 Thread carol . legros
Hi Mladen, Thanks for the advice.  I *never* would've guessed this! A quick look at the Oracle Install Guide mentions NINODE for an HP environment. But I don't see what the comparable parameter would be in Solaris.  (Or, is it the same, but the install guide just doesn't  mention it.) Thanks ag

tuning : file number translation table

2003-07-18 Thread carol . legros
I'm hoping someone out there has experienced this problem... I can't seem to find many posts on MetaLink that discuss this. My environment : - I am running a 500 Gig OLTP database in a Solaris environment.  I have some 0+1 disk available, but mostly RAID5 (array) for the d

Re: VLDB (oltp) and RMAN

2003-06-23 Thread carol . legros
I'm aware of the fact that I may bump into hardware limitations, and I'm going to discuss the hardware and tape limitations (if there are any) with my Sun server sys admin. Thanks in advance, Carol Legros

VLDB (oltp) and RMAN

2003-06-20 Thread carol . legros
100Gig in size).  I'm aware of the fact that I may bump into hardware limitations, and I'm going to discuss the hardware and tape limitations (if there are any) with my Sun server sys admin. Thanks in advance, Carol Legros

RE: Cascading Triggers

2003-06-09 Thread carol . legros
Thanks for the responses so far... The transactions weren't declaraed as autonomous, so I, too, expect what you suggest. The two columns in question are of the same datatype -- numeric. This is a strange one. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/09/2003 04:14 PM Please respond

Cascading Triggers

2003-06-09 Thread carol . legros
Hi listers... I have a question related to triggers.  One of the developers here has created two triggers as follows : Trigger #1 is an AFTER UPDATE trigger on TABLE-A        - the trigger has PL/SQL code including an UPDATE dml statement on TABLE-B.COL-2 Trigger #2 is an AFTER UPDATE trigger o