Home » RDBMS Server » Server Administration » Database in not respondin (Oracle 9i)
Database in not respondin [message #282152] Wed, 21 November 2007 00:43 Go to next message
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..

Re: Database in not respondin [message #282159 is a reply to message #282152] Wed, 21 November 2007 00:58 Go to previous messageGo to next message
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
Re: Database in not respondin [message #282163 is a reply to message #282152] Wed, 21 November 2007 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
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
Re: Database in not respondin [message #282166 is a reply to message #282163] Wed, 21 November 2007 01:09 Go to previous messageGo to next message
funnyguyoracle07
Messages: 2
Registered: November 2007
Junior Member
for all the queries it showing same..
Re: Database in not respondin [message #282170 is a reply to message #282152] Wed, 21 November 2007 01:16 Go to previous messageGo to next message
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.
Re: Database in not respondin [message #282173 is a reply to message #282166] Wed, 21 November 2007 01:21 Go to previous messageGo to next message
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 ???
Re: Database in not respondin [message #282178 is a reply to message #282166] Wed, 21 November 2007 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:

My DB is not responding when issue a query

Quote:

for all the queries it showing same..

Quote:

I checked [...] v$session every thing fine.

Don't you see any inconsistency in what you said?

Regards
Michel

Re: Database in not respondin [message #282259 is a reply to message #282152] Wed, 21 November 2007 05:15 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
When your database is not responding,how did you check v$session view?
Re: Database in not respondin [message #282277 is a reply to message #282259] Wed, 21 November 2007 06:31 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Maybe OP check different instance Smile
that is why I checked [...] v$session every thing fine.
Previous Topic: WARNING: db_create_file_dest is same as db_recovery_file_dest
Next Topic: Archive logs
Goto Forum:
  


Current Time: Fri Dec 06 13:57:19 CST 2024