I have seen it hang usually when dbms_jobs are running.
>>> [EMAIL PROTECTED] 01/23/02 12:35PM >>>
Shutdown immediate still is not fixed in 8.1.7.2. I still have it hang once in awhile.
Work around is to:
sqlplus /nolog
connect internal
shutdown abort
exit
Key is to start sqlplus and tell it not to log in.
Since internal goes away in 9, not sure what the workaround would be there.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"Hit any PHB to continue..."
M.Jenner@southamp
ton.gov.uk To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: sqlplus vs. svrmgrl
01/23/02 04:55 AM
Please respond to
ORACLE-L
Just to make everyone aware (if you don't already know), about bug 1053405
which I came accross this week.
My live database was stuck in a 'shutdown immediate' state. I wanted to
perform a shutdown abort and proceed from there but shock, horror : sqlplus
'/ as sysdba' told me :
ORA-01090: immediate shutdown in progress - connection is not permitted
(OEM instance manager would not allow what I wanted either..)
It appears that in this situation you still need svrmgrl ... connect
internal....
This worked fine for me and I was able to shutdown abort.
I'm on 8.1.6 with Solaris 2.7.
Metalink searches and responses from Oracle have indicated that this fixed
in both 8.1.7 and 9.x.
I'm moving to 8.1.7 within a few weeks. Is anyone able to confirm whether
8.1.7 has it fixed?
I know that 9.x will have it fixed because svrmgrl is not included (I
certainly hope so anyway!).
- Mike.
-----Original Message-----
Sent: 23 January 2002 10:53
To: '[EMAIL PROTECTED]'
Looks good and portable. If you have UCB Unix commands on your system then
simply try:
/usr/ucb/ps -auxw | head -37
- Mike.
-----Original Message-----
Sent: 23 January 2002 08:40
To: Multiple recipients of list ORACLE-L
Nice one Michael, works on Tru64 as well. I shall be rolling this one out
today.
Regards
Lee
-----Original Message-----
Sent: 22 January 2002 19:10
To: Multiple recipients of list ORACLE-L
Here's a Korn Shell script that I use to identify all of the top CPU hogs in
Solaris. It is better than "top" because it gives you the actual command
that is running:
#!/bin/ksh
# Show the PS version of the top 37 processes (by CPU usage)
print "UID\tPID\tPPID\tSTIME\t\tTIME\tCMD"
top -n 37 2>/dev/null| tail -38 | head -37 | awk '{print $1}' | while read
PID
do
PS=`ps -fp $PID 2>/dev/null| tail -1`
if [[ `echo $PS | grep -c "UID PID PPID C STIME TTY TIME CMD"` -ne 1 ]]
then
echo $PS | awk '{for (i = 8; i <= NF; i++) O = O " " $i; print $1 "\t"
$2 "\t" $3 "\t" $5 "\t" $7 "\t
" substr(O,2,59)}'
fi
done
--Michael
-----Original Message-----
Sent: Tuesday, January 22, 2002 1:26 PM
To: Multiple recipients of list ORACLE-L
This query will show current sessions CPU usage. It may
indicate a particular session is hogging the CPU.
select
sess.username,
stat.sid,
name.name name,
sum(stat.value)/100 valuesum_seconds
from v$sesstat stat, v$statname name, v$session sess
where
stat.sid = sess.sid
and stat.statistic# = name.statistic#
and name.name like '%CPU%'
group by sess.username, stat.sid, name.name;
You should also use 'top' or some similar tool to
identify the process.
At times a session may have a 'runaway' process that
is hogging the CPU. If a single dedicated server process
is using a very high percentage of the CPU, it's would
probably be a good idea to kill it. Be sure to identify
the user or batch program first to make sure it can be
killed.
The output of 'ps -fuoracle' will show a dedicated session
as similar to this:
oracleVDRPROD (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
The following query will match an
process to an Oracle session:
select
s.username,
s.sid,
s.serial#,
p.pid ppid,
s.status,
s.osuser,
substr(s.program,1,20) client_program,
s.process client_process,
substr(p.program,1,20) server_program,
p.spid server_pid
from v$session s, v$process p
where s.username is not null
-- use outer join to show sniped sessions in
-- v$session that don't have an OS process
and p.addr(+) = s.paddr
-- uncomment to see only your own session
--and userenv('SESSIONID') = s.audsid
order by username, sid
/
Jared
Uma Mohoni <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/02 07:20 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: High CPU usage by Oracle
Hi,
I would like help with this problem I am grappling with since yesterday.
One
of the test boxes with Sun Solaris 2.7 OS and Oracle 8.1.7.2 on it has
started showing 97% and above CPU usage mostly by Oracle . It has slowed
down the application to a point where the testers can not test. Does any
one
have any idea why Oracle would suddenly hog CPU so much? The normal CPU
usage on these boxes is 2%-3%. All help is greatly appreciated. Thanks in
advance.
Thanks,
Uma Mohoni
Consultant, CDI Corporation
@ iKimbo Inc.
500-A Huntmar Park Drive
Herndon, VA 20170
(703) 904-4150 Ext:237
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Uma Mohoni
INET: [EMAIL PROTECTED] RACLE-L
Here's a
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 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.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 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.orafaq.com
--
Author: Jenkins, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 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).
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 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.orafaq.com
--
Author: Jenner Mike
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 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.orafaq.com
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 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.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT 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).
