- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: system or networking??
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2006 12:17 AM
тАО09-29-2006 12:17 AM
system or networking??
our oracle dbase is on a HP-UNIX platform.
however the db-administrator sits at the floor above ours.
He recently issued a complaint that his sql transactons while working on an explorer interface get timed-out after about 20 minutes while still executing.
As for the unix-administrator, the timeout was set to no-time outs!.
Am wondering if this scenario is due the unix parameters or the windows network that he uses for connection and how to go about it
My Regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2006 12:27 AM
тАО09-29-2006 12:27 AM
Re: system or networking??
The db admin should install oracle stats pack and examine his sql code.
Unless he's reading the entire database without an index his sql statements should not take that long to execute.
stats pack will do a few things:
1) It will collect data over time and help the database improve its own performance.
2) It will enable the db admin to see if an index is needed to cut the execution time on his sql statements.
This is almost certainly and oracle issue and not an OS issue. You can check os stats for free with the following script set:
http://www.hpux.ws/system.perf.sh
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2006 12:45 AM
тАО09-29-2006 12:45 AM
Re: system or networking??
You have to find out how he was connected. If it was through an interactive terminal (telnet, ssh, what-have-you), then there might be some server-side settings that you can change. If it was through a client that establishes a connection directly with DB, then that is almost assuredly an issue with the DB itself, with the client he was using, or with settings on his particular SQL session.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2006 08:54 PM
тАО09-29-2006 08:54 PM
Re: system or networking??
However i left out a other fact. If on is working on the the servers 192.168.11.### segment, this hitch does no arise. It only comes when one connects through say 192.168.14.### and any other segment other than the server segment. Network admin suggested a firewall issue...
I think with this fact, the servers have no configuration problem
my regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2006 01:39 AM
тАО09-30-2006 01:39 AM
Re: system or networking??
Check all the road.
HTH
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2006 05:03 PM
тАО10-01-2006 05:03 PM
Re: system or networking??
What type of application are you running?
The default session timeout for the OC4J server is 20 minutes.
it could be related.
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2006 02:02 AM
тАО10-04-2006 02:02 AM
Re: system or networking??
Now the NetAdmin points out that the timeouts are due to PIX-Firewall setting that auto-time outs all sessions coming in from the other subnets. He dreads an increase in the timeout interval might cause a security worry.
However, i used PuTTY and it seems my telnet sesseions don't suffer from the timeouts even when off the server subnet. Only configured the time interval between keepalives.
However, much as this provides a solution to some few parties, the database guys especially those using OFA, SQL*Plus, PL/SQL Developer, Reports Developer, toad. are still having the timeouts.