Why is database hanging?

Published: 28 Oct 2003

What is the best way to determine why a database is hanging while it's hanging? I can't run a SQLPlus command or a svrmgrl command because these are stuck hanging. Database is Oracle 8.1.7.4 on HPUX 11.11.
If you can't get a session started to be able to look at V$ tables etc., I'm afraid that you'll be out of luck. Sometimes Statspack can capture some information if you have it implemented to snapshot periodically. If you're having a fairly routine occurrence of "hang-ups", I'd recommend you put something in place to monitor your database and alert you to conditions approaching threshold values that may signal a problem. You can write your own procedures to do this or you can use OEM to send you alerts or buy a third-party tool (Quest software has several for instance) that will assist you.

Dig Deeper on Oracle database design and architecture

Oracle won’t patch four-year-old zero-day in TNS listener Despite the accidental release of attack code for a bug in Oracle’s database, the company won’t change the code for fear of “regression.”

Messages and spool hanging up SAVLIB jobs when OUTPUT(*PRINT) is specified Override QPSAVOBJ to eliminate messages hanging up SAVLIB jobs when utilizing the OUTPUT(*PRINT) command.

Determining the cause of Windows server hang Using the Windows Kernel Debugger (Windbg), learn to fix Windows server hang by analyzing a forced crash dump to determine the cause of the hung server.

Redo log file problems Expert Brian Peasland explains why it is important to make sure online redo logs are multiplexed.

Oracle RAC: Database performance issues Oracle's RAC databases share resources with other applications which are also in demand. Sometimes resource management runs into a deadlock. This excerpt from "Oracle Database 10g: Real Applications Clusters Handbook" examines what happens to a hung database and how to fix it.

Oracle RAC troubleshooting Oracle RAC shared disk method of clustering databases increases scalability and lowers costs. However, it can be challenging to find and fix bugs in Oracle 10g. This chapter excerpt from "Oracle Database 10g: Real Application Clusters Handbook" provides diagnostic frameworks and tools needed to tackle even complicated database problems.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Why is database hanging?

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchSAP

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SearchSQLServer

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

TheServerSide.com

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

SearchDataCenter

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.