Re:RE: How can I tell if MTS is activated -- more problems

2002-11-06 Thread Pablo Rodriguez
No there isn't. This is my TNSNAMES. PRUE1.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 10.20.81.78) (Port = 1521) ) ) (CONNECT_DATA = (SID = PRUE1) ) ) --- [EM

RE: How can I tell if MTS is activated -- more problems

2002-11-06 Thread Pablo Rodriguez
Dave, I've seen these processes (ora_S00... and ora_d00..) but all connections are being made through dedicated processes. Here's my configuration: mts_listener_address = "(ADDRESS=(PROTOCOL=TCP) (HOST=10.20.81.78) (PORT=1521))" mts_service = PRUE1 mts_dispatchers = "tcp,2" mts_

How can I tell if MTS is activated

2002-11-06 Thread Pablo Rodriguez
Oracle 8i How can I tell if MTS is activated? Which parameters should I look at? (in init.ora and listener.ora) thanks Pablo ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger

Parallel Server Option = TRUE

2002-10-29 Thread Pablo Rodriguez
Hope someone can help me with this one. I have just realized that PARALLEL SERVER = TRUE in v$option and I don't have an OPS instalation. I've installed this Oracle code in a Unix Cluster that's why Oracle has installed this option automatically, I assume. Can anyone tell me if there can be any

Memory usage control in Tru64 - urgent !!!

2002-10-25 Thread Pablo Rodriguez
Hi!! I'm trying to see if a unix machine is having performance problem with any resources: cpu, disk and memory. When I started analyzing the memory statistics, taken previously with vmstat I realized that it's columns are completely different from any other unix I've worked before (solaris, aix,

RE: CPU WAIT I/O statistic

2002-10-15 Thread Pablo Rodriguez
Dennis, Thanks for your answers and your time. I was interested in how the OS (Sun, AIX, HP, etc) classifies the CPU time used by the processes. Taking a look at the WAIT I/O statistic taken with sar -u I started wondering what they really meant: ie %usr %sys %wio %idl 30 5

RE: CPU WAIT I/O statistic

2002-10-10 Thread Pablo Rodriguez
Dennis: Thanks for answering, what do you mean by, or may be what do you think Gaja means by: "He points out that the Solaris sar -q command has a "%wio" column, a measure of processes that are currently using the CPU, but are waiting for I/O requests to be serviced and hence are not making p

RE: CPU WAIT I/O statistic

2002-10-10 Thread Pablo Rodriguez
Dennis: Thanks for answering, what do you mean by, or may be what do you think Gaja means by: "He points out that the Solaris sar -q command has a "%wio" column, a measure of processes that are currently using the CPU, but are waiting for I/O requests to be serviced and hence are not making p

CPU WAIT I/O statistic

2002-10-10 Thread Pablo Rodriguez
Hi list Can anyone explain me what exactly does the WAIT I/O column of the sar -u output mean? Does it represent the % of CPU used by the kernel processes to perform I/O? As far as I know the waiting processes do no wait actively when they ask for an I/O. right? The OS uses the SLEEP a

hash_value and address

2002-09-03 Thread Pablo Rodriguez
I see 2 different addreses for the same hash_value in v$sqlarea. Why do I see this? Here's an example: hash_value address -- --- 3749804 4064082C 3749804 4192941C I wonder if someone can shed some light on this Txs

V$SQLAREA

2002-09-02 Thread Pablo Rodriguez
Hi List. does anybody know what the OPTIMIZER_MODE = NONE mean in v$sqlarea view ? I've found this document Doc ID: 48131.996 in metalink, but it seems that I don't have access to it. The problem I'm facing here is that I am getting this information when analyzing v$sqlarea. Wh

test

2002-09-02 Thread Pablo Rodriguez
___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20Rodriguez?= INE

Re: Raw device backup script

2002-05-09 Thread Pablo Rodriguez
Thank you Connor, but I need a script that backups over 20 raw devices datafiles to a TAPE without using a FS to store these datafiles first. TIA ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente. http:/