OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database Hang?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Hang? [message #122729]

Wed, 08 June 2005 05:19

confident
Messages: 28
Registered: March 2005

Junior Member

iam running one of oracle 9.2.0.2 database in HP-UX(IA64)11.23v..
when i run this query
select RPAD('password',16,chr(0)) from dual;
my database is hang...

and i checked in another server database its working fine.....
why? any patch problem

Report message to a moderator

Re: Database Hang? [message #122731 is a reply to message #122729]

Wed, 08 June 2005 05:25

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

enable trace for the session and check for any errors generated.

Report message to a moderator

Re: Database Hang? [message #122732 is a reply to message #122729]

Wed, 08 June 2005 05:26

confident
Messages: 28
Registered: March 2005

Junior Member

Sorry, Session will hang...

other database is 8.1.7

Report message to a moderator

Re: Database Hang? [message #122733 is a reply to message #122732]

Wed, 08 June 2005 05:34

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

I checked on oracle 9.2.0.1 Its working fine.

Do check for the trace file generated for this session. Check upto what statements that file get generated.

Also check if database hangs for these statements as well:
select chr(0) from dual;
&
select rpad('password',16,' ') from dual;

Report message to a moderator

Re: Database Hang? [message #122782 is a reply to message #122729]

Wed, 08 June 2005 09:09

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

I would also consider looking at wait events in the database..along with the explain plan of the statement ...

sai jeedigunta

Report message to a moderator

Re: Database Hang? [message #122901 is a reply to message #122729]

Thu, 09 June 2005 01:50

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

Did you applied any patch recently?

Report message to a moderator

Re: Database Hang? [message #122908 is a reply to message #122729]

Thu, 09 June 2005 02:56

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

Do you restart your DB or just kill the session? Do Oracle dumps core? any trace is generated? Did you got ORA-600?

use sql trace and tkprof to see what actually goin on?

There is a patch available for ORA-600[1158]:

2828026 RDBMS Server: Patch
DATABASE HANGS WITH ORA-600[1158]

Report message to a moderator