the status column in v$session for the ones that don't
match?
IIRC, there can be a status of "SNIPED" where the session is not
actually connected but has not been cleaned up.
curiosity -- why is a user looking at v$session?
--- "Wiegand, Kurt" <[EMAIL PROTECTED]>
Title: MTS v$session
Yes;
at least on the server side.
#
SQLNET.ORA Network Configuration File:
/u01/app/oracle/product/817/network/admin/sqlnet.ora# Generated by Oracle
configuration tools. #NAMES.DIRECTORY_PATH=
(TNSNAMES)SQLNET.EXPIRE_TIME= 10
-Original Message-From: Nual
Title: RE: Redo Logs Problem
Update activity is
obviously occuring at an alarming rate. Look at the times of the log
switches
and you should be able to pinpoint the 'when' Then, catch them in the
act! Look at v$sess_io and
find your 'heavy hitters', then grab their SQL or ,bet
Title: Message
Sure. Check v$backup. STATUS will give you
part of your answer, but TIME will be the real key.
Match
it to the alert log and/or to the time you normally run your backup and you
should discover
what
happened. Typically this is caused by a failed backup. Some backup
scripts
Title: MTS v$session
I've got an 8.1.7.4.0 instance running under Solaris 2.8.
I've never worked with MTS before, but got a call from a user telling me that there
were about 700 rows in v$session but they only had about 130 sessions open.
The user believes that when the session is ended,
Title: RE: Things to validate / collect before Killing a session
I always check to see how much rollback they have in case I want to watch
it rollback and I always make sure I get the pid for the associated UNIX
process in case I decide I need to kill it. Of course, I always almost
Title: PL/SQL- cursors and commits
I've been 'experimenting' with the following code in 8.1.5 and it seems to work fine. However,
my "ORACLE PL/SQL" book from O'REILLY (Steven Feuerstein Bill Pribyl 1997) leads me to
believe that it should not work. They state "As soon as a cursor with a
Title: OCP Hands-On Course Requirement
Can anyone direct me towards an "Oracle Authorized Education Center or Partner" in
the Washington D.C. area? I'm planning on getting certified but only see Oracle
University offering 9-5 Monday-Friday courses. Thanks.
Kurt
SQL> select password from dba_users where username = 'TEST';
PASSWORD
--
7A0F2B316C212D67
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-505
#x27;.
The source box
uses dns first but the target box resolves names locally first and then uses
dns. The nodenames
are the same.
owsctl start -nodemgr works
owsctl status -T works
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL
LE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE your
T spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafa
grade steps to perform for
JServer? Is this correct?
What Is the banner saying? "JServer Release 8.1.7.0.0 - Production"
Thanks.
Kurt Wiegand
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services
3, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L
On Tue, 22 Jan 2002, Wiegand, Kurt wrote:
> sort of on the subject.I once had a table with ~88000 extents
> (most 1 block!) it took 8 hours to delete and a subsequent coalesce
> ran for 2 hours before failing as it ran out of
http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE your
e the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
cide whether they can all be ignored or not.
Thanks
Kurt Wiegand
IBM Global Services
Cable & Wireless Communications
Vienna VA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
e message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL P
ist you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 53
ions
[EMAIL PROTECTED]
703 760-3619
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
ormation (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
nclude a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
INET: [EMAIL PROTECTED]
F
22 matches
Mail list logo