var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
What is the meaning of Status='INACTIVE' in Oracle?One of our query is running for hours without any result but the status=INACTIVE?
When status = inactive in v$session it should be just what it says, session is inactive...
Are you sure your query is still running?
Oracle Database Administrator
(OCP certified 8i)
We are trying to run some report and the report works fine as long as it's a short report.But for big reports the status is changing to Inactive after sometime and then nobody knows that what's going on?Any help?Is there any query timeout in Oracle?
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors