Re: what causes a memory dump?

2003-09-28 Thread Pete Finnigan
Ryan, Have you checked with an editor or just the o/p of your script that polls the alert log just in case your script missed it. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security

Re: Reality check for filesystem/disk layout

2003-09-28 Thread Pete Finnigan
Hi April, A few years ago in London for a large finance group a colleague and I did a similar job where we used veritas on sun 4500 and 5200 storedge arrays to specify which parts of the physical discs were used so we could control physical locations. We had similar constraints, huge amounts of

portable clusterware of rac10G?

2003-09-28 Thread zhu chao
Hi, list: Reading document rac deployment and performance release 1 document(Still 10i beta that time), it said:  Improvements to adding a node To add a node, you first connect the hardware according to your hardware vendors installation instructions. However, you no longer need to install

Re: FTP big file to little laptop

2003-09-28 Thread Pete Finnigan
Hi Bambi If it is ftp that is your issue and not the filesystem you can try another approach, go to a friend of mines site http://pgibbs.demon.co.uk and look in useful code 'n' stuff and in there, there is a pair of C programs called send and receive, they allow files to be sent between each

Re: Solaris /etc/system values for Oracle8i

2003-09-28 Thread Tim Gorman
I've a customer running a development environment of two OraApps 11.5.8 database instances and one more database instance (for web development under WebLogic), all on a Sun V100. Yes, that is a rack-mountable Solaris machine of 1U rack height with a maximum configuration of one (1) UltraSPARC-III

workarea_size_policy=auto and performance efficiency [was: Re:

2003-09-28 Thread Tim Gorman
Referencing the article mentioned in this thread, I'd also like to understand exactly what is meant by the phrase [PGA_AGGREGATE_TARGET] leads to a more efficient use of RAM memory? From what I've been able to determine about this functionality, efficient merely means space-efficient, not

Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS

2003-09-28 Thread Tim Gorman
Title: Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS NAS mistakes: Not dedicating two (or more) network segments to NAS access only, segregated from other uses Should you just plug a NAS into a general-purpose LAN and start connecting servers to it? Why would more than one

Re: (long and boring) SQL AREA and LIBARARY CACHE size?

2003-09-28 Thread Tanel Poder
Hi! As I understand, when shared pool heap is allocated, half of it's memory is actually hidden at first. Oracle just allocates one big permanent type chunk for that. The rest of memory is put on shared pool freelist. Initially this is just one big free chunk as well, but starts shrinking as

Re: Solaris /etc/system values for Oracle8i

2003-09-28 Thread Tanel Poder
Yep, I have development and even small production 8i instances which take only about 100MB of memory (SGA, listener, dispatcher, shared servers). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 28, 2003 11:59 PM I've a

Re: BAARF

2003-09-28 Thread Tim Gorman
Thomas, Please pardon me, but you are off-target in your criticisms of OFA. It has never advocated separating tables from indexes for performance purposes. Ironically, your email starts to touch on the real reason for separating them (i.e. different types of I/O, different recovery

Re: workarea_size_policy=auto and performance efficiency [was: Re:

2003-09-28 Thread Tanel Poder
Hi! From what I've been able to determine about this functionality, efficient merely means space-efficient, not performance-efficient (i.e. Fewer cycles? Smarter cycles?). Is this correct? Does anyone know of anything in WORKAREA_SIZE_POLICY=AUTO which improves performance over

Re: SQL AREA and LIBARARY CACHE size?

2003-09-28 Thread Tanel Poder
Now that I think about it, it might very well be so :) DBA_ views vs. base tables would be a different story (uet$ fet$ case with LMT for example...) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 26, 2003 2:14 PM Was

Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS

2003-09-28 Thread Tanel Poder
I would still rank undo redologs together with regular data because they're crucial for survivability and consistency ofinformation... Tanel. If there is a policy to place all “corporate data” on the shared storage (NAS), then surely redo, RBS/UNDO etc should not

Re: workarea_size_policy=auto and performance efficiency [was: Re:

2003-09-28 Thread Tanel Poder
I set PGA_AGGREGATE_TARGET to 2,5G in my home computer, but only about 3-4MB of memory was used for my large sort for example. There are parameters _smm_max_size and _smm_min_size for setting boundaries for automatic One more note on these two parameters - setting them didn't work in my

Re: portable clusterware of rac10G?

2003-09-28 Thread jmzhai
chao_ping: See following statsments from OracleWorld WP ORACLE REAL APPLICATION CLUSTERS 10g : THE FOURTH GENERATION: Oracle RAC 10g offers a complete clusterware management solution as an integral component of Oracle RAC 10g available on all platforms Oracle Database 10g runs on. This

Suggestion reg. encryption ??

2003-09-28 Thread Prem Khanna J
Hi List, Application desc: Something similar (not exactly) to a payment gateway ; java/oracle 9iR2 will be used to develop it; need to store credit card numbers (encrypted) in the database ; SSL will