- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: sql prompt hanging
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
тАО08-08-2004 07:01 PM
тАО08-08-2004 07:01 PM
sql prompt hanging
my client using oracle 8.0.5 on hp-ux,frontend is D2k.If more then 15 users login frontend then sql prompt hanging.this time usr process takes more then 80%.but OS working properly that is we can telnet,ftp and do all other activity on OS side but sql user gets hanging.kindly suggest me some solution.
Thanks& Regards
S.Muthu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-08-2004 07:19 PM
тАО08-08-2004 07:19 PM
Re: sql prompt hanging
what's the nproc,maxdsiz,maxdsiz_64bit values?
issue the command
#kmtune
and grep for nproc,maxdsiz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-08-2004 07:25 PM
тАО08-08-2004 07:25 PM
Re: sql prompt hanging
Also look for the value PROCESSES in the parameter file.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-08-2004 10:04 PM
тАО08-08-2004 10:04 PM
Re: sql prompt hanging
you should consider running a statspack report (15 minutes interval) and analyze too.
does the sql prompt freeze when you run a query or is it another thing?
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2004 04:35 AM
тАО08-09-2004 04:35 AM
Re: sql prompt hanging
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2004 06:39 AM
тАО08-09-2004 06:39 AM
Re: sql prompt hanging
nprocs=1000
PROCESS on init****.ora is 100.
when users are working(all user's having same sql user login) sudeenly gets hanging,but sql sys&system user can login.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2004 02:13 PM
тАО08-09-2004 02:13 PM
Re: sql prompt hanging
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-09-2004 05:37 PM
тАО08-09-2004 05:37 PM
Re: sql prompt hanging
set pages 9999
column NAME format A25
column INIT format A10
column LIMIT format A10
SELECT RESOURCE_NAME "Name", CURRENT_UTILIZATION "Current",
MAX_UTILIZATION "Max", INITIAL_ALLOCATION "Init", LIMIT_VALUE "Limit"
FROM V$RESOURCE_LIMIT;
In stead of wondering what Oracle might be waiting for, why not ask Oracle?
Google for v$session_wait
For example:
http://examples.oreilly.com/oracle2/Chap11/objwait.sql
Or here in the forum:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=657038
Or our friends at ixora:
http://www.ixora.com.au/scripts/waits.htm
Of course it could be an w2k/hpux interaction thingie, maybe with the network, or with control0c polling or whatever...
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-10-2004 12:53 AM
тАО08-10-2004 12:53 AM
Re: sql prompt hanging
I de-installed & installed oracle with ur suggestions.system is working fine.
Thanks&Regards
S.Muthamilan