OraFAQ Forum: Server Administration » Database in not respondin

Home » RDBMS Server » Server Administration » Database in not respondin (Oracle 9i)

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

Database in not respondin [message #282152]

Wed, 21 November 2007 00:43

funnyguyoracle07
Messages: 2
Registered: November 2007

Junior Member

Hi,

My DB is not responding when issue a query , I checked the alert log file and v$session every thing fine.

plz provide help to me where i have check exactly to identify the problem..

Report message to a moderator

Re: Database in not respondin [message #282159 is a reply to message #282152]

Wed, 21 November 2007 00:58

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

My DB is not responding when issue a query
1. check v$session view user status is "active" which execute your sql query.

2. also check v$session_longops view.

Regards
Taj

Report message to a moderator

Re: Database in not respondin [message #282163 is a reply to message #282152]

Wed, 21 November 2007 01:02

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

My DB is not responding when issue a query

A specific query or any query?

Regards
Michel

Report message to a moderator

Re: Database in not respondin [message #282166 is a reply to message #282163]

Wed, 21 November 2007 01:09

funnyguyoracle07
Messages: 2
Registered: November 2007

Junior Member

for all the queries it showing same..

Report message to a moderator

Re: Database in not respondin [message #282170 is a reply to message #282152]

Wed, 21 November 2007 01:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>for all the queries it showing same..
Congratulations, the problem remains the same.

Any useful or meaningful input might provide a clue.

Report message to a moderator

Re: Database in not respondin [message #282173 is a reply to message #282166]

Wed, 21 November 2007 01:21

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

v$session every thing fine.
What did you check in v$session view and what is fine ?

and from where you execute your query ?
it is sql*plus command prompt, vb or toad ???

Report message to a moderator