?
Solved

Inactive session after 2 hours of SQL

Posted on 2015-01-15
2
Medium Priority
?
211 Views
Last Modified: 2015-02-13
Experts -

I've a "tableau" reporting session comes from a Window Server to Oracle Linux. It's executing an SQL which runs around 2 hours and then the session is marked as "INACTIVE". The client is getting ORA errors like ORA-00028 and ORA-01013.

The SAME sql was running/completing fine in 2 hours from other workstations.

What could be the issue?

Thanks,
Sve.
0
Comment
Question by:sventhan
2 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 total points
ID: 40552129
I would look at the network first.  If the 'bad' workstation and good workstations are on the same subnet/switch/???, look at a configuration, cable or NIC in the 'bad' workstation.
0
 
LVL 23

Assisted Solution

by:David
David earned 1000 total points
ID: 40555443
http://ora-00028.ora-code.com/ is pretty clear:


ORA-00028:
your session has been killed
Cause:      A privileged user has killed your session and you are no longer logged on to the database.
Action:      Login again if you wish to continue working.

Have a chat with your helpdesk or DBA.  An inactive session is the state where there's no active I/O -- typical if the work is being done on a remote host.  Another thought, you may be bumping up against a timeout constraint in your user profile.  These aren't areas you're going to have access to.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question