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
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_
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
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
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,
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
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
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
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
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
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
___
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
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:/
13 matches
Mail list logo