I have recently noticed the "startup" and "shutdown immediate/abort" command are taking a whole lot longer. It went from 10 seconds to 7 minutes for all environments. I checked everything on my HPUX server and everything seems to functioning ok. I have about 8 oracle databases that on this server and all of them have this seem lag.
Any ideas to what can be causing this problem.
This question is in progress.
Our experts are working on an answer right now.
Sign up for immediate access to the solution once it becomes available.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Check TOP resource consuming Oracle processes from OS command.
Check if any query is performing any kind of of rollback using the following query.
SELECT l.inst_id, l.SID, username, osuser, /*o.object_name,*/ start_time, used_ublk "blocks used", used_urec "records used", log_io "Logical I/O",
phy_io "Physical I/O", cr_get "Consistent gets ", cr_change "Consistent changes ", sql_hash_value
FROM gV$TRANSACTION t, gV$LOCK l, gv$session s --, dba_objects o
where t.XIDSQN = l.ID2
and t.INST_ID = l.INST_ID
and s.SADDR = t.SES_ADDR
and s.INST_ID = t.INST_ID
order by osuser;
---AND
select *from gv$session_longops where time_remaining > 0
Generate AWR and ADDM Report to find out if there is any Database issue.
I'd guess that since they are all on the same server, and this behaviour was observed simultaneously on all instances, that it is nothing to do with Oracle and something with memory or cpu. Overall memory usage may be up, and much of the Oracle virtual memory may be swapped out. shutdown abort still has to free up IPC and memory structures, and memory that is swapped on disk is slower to free. So possibly the busier OS kernel is just slower at this now. Look at your overall memory usage on the OS, also look at resident size vs virtual size for each Oracle process. Also look at vmstat to review swap usage.
Business Accounts
Answer for Membership
by: dvzPosted on 2009-10-21 at 08:01:35ID: 25624635
Can we presume you have checked the alert logs, trace files, listener log(s), and the O/S syslog as an obvious first step?
No changes to the database parameters?
HPUX glance shows normal CPU cycling and resource use?
Databases are or are not in archivelog mode?
Mostly commonly, IMO, you have a resource conflict, but such should show up in one or more of your log files. My next usual culprit is the network / LAN. At this point I would begin doing diagnostic tracing at the network packet level to check the execution times for each part of the transaction's round trip. Details are in previously asked questions, so a query against the EE (or Metalink) knowledge bases should provide you with the syntax and procedure for this.
Regards,
dvz