- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - HP-UX
- >
- System Administration
- >
- oracle login slow
-
- Forums
-
Blogs
- Alliances
- Around the Storage Block
- Behind the scenes @ Labs
- HPE Careers
- HPE Storage Tech Insiders
- Infrastructure Insights
- Inspiring Progress
- Internet of Things (IoT)
- My Learning Certification
- OEM Solutions
- Servers: The Right Compute
- Shifting to Software-Defined
- Telecom IQ
- Transforming IT
- Infrastructure Solutions German
- L’Avenir de l’IT
- IT e Trasformazione Digitale
- Enterprise Topics
- ИТ для нового стиля бизнеса
- Blogs
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Enterprise.nxt
- Marketplace
- Aruba Airheads Community
-
Forums
-
Blogs
-
InformationEnglish
- 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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-07-2011 10:18 PM
03-07-2011 10:18 PM
oracle login slow
OS:HP-UX 11.11
Oracle Application server
RAM:8GB
swap:12GB
Kernel parameters:
nkthread 7184
nproc 4096
total processes : 1179
Total forms connections : 744
Total HTTP server processes: 242
Iam facing a problem of Oracle Application 9.0.1.4.0 process damm slow access to the oracle login users via java applet.
Although the RAM usage is only approx 15% , But swapping is higher, Why it is not consuming more RAM for fast processing.
Does this require to change "any kernel parameters"
Kindly find below more details about the memory utilization:
total processes : 1179
Total forms connections : 744
Total HTTP server processes: 242
# swapinfo -tam
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 734 3362 18% 0 - 1 /dev/vg00/lvol2
dev 4092 738 3354 18% 0 - 1 /dev/vgswapapp1_1/lvswap1_1
dev 4092 738 3354 18% 0 - 1 /dev/vgswapapp1_2/lvswap1_2
localfs 800 0 800 0% 800 0 1 /logs/paging
reserve - 9625 -9625
memory 6301 762 5539 12%
total 19381 12597 6784 65% - 0 -
#Regard's
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 12:11 AM
03-08-2011 12:11 AM
Re: oracle login slow
Any valuable input's will be appreciated .....
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 12:57 AM
03-08-2011 12:57 AM
Re: oracle login slow
you might have been started jvm with low memory, as connection increases jvm makes more garbage collection with more durations. look at the oc4j logs in opmn/logs directory anc check GC durations.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 01:52 AM
03-08-2011 01:52 AM
Re: oracle login slow
I appreciate your quick response,
The 172.1.100.4 belongs to infrastructure DB node.
Kindly find an attached for your review and feedback to over-come with this issue .
Thanks& Regards
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 01:52 AM
03-08-2011 01:52 AM
Re: oracle login slow
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 01:53 AM
03-08-2011 01:53 AM
Re: oracle login slow
You can't tell if it is swapping unless you provide the "vmstat 1 8" and look at the "po" column.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 02:56 AM
03-08-2011 02:56 AM
Re: oracle login slow
=================
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
54 1 0 2294623 99604 55 0 6 8 0 0 50 753 6057 1586 8 5 88
54 1 0 2294623 98919 411 1 35 0 0 0 0 2289 12734 7550 35 14 51
54 1 0 2294623 98141 348 0 28 0 0 0 0 2280 12726 7288 33 17 50
54 1 0 2294623 97525 329 0 23 0 0 0 0 2197 12648 7367 29 15 56
54 1 0 2294623 97437 307 0 24 0 0 0 0 2117 12356 7164 20 12 68
54 1 0 2294623 98032 253 0 19 0 0 0 0 2000 11877 6758 19 9 72
54 1 0 2294623 97307 192 0 13 0 0 0 0 1896 11460 6408 28 13 59
54 1 0 2294623 100893 158 0 19 0 0 0 0 1845 11081 6369 22 14 65
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 03:02 AM
03-08-2011 03:02 AM
Re: oracle login slow
avm free re at pi po
2294623 99604 55 0 6 8
2294623 98919 411 1 35 0
2294623 98141 348 0 28 0
2294623 97525 329 0 23 0
2294623 97437 307 0 24 0
2294623 98032 253 0 19 0
2294623 97307 192 0 13 0
2294623 100893 158 0 19 0
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 03:43 AM
03-08-2011 03:43 AM
Re: oracle login slow
>2294623 99604 55 0 6 8
>2294623 98919 411 1 35 0
Basically you aren't paging out (swapping).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 04:09 AM
03-08-2011 04:09 AM
Re: oracle login slow
But below output shows system swapping 65% where as real time memory RAM only 12%,
total processes : 1179
Total forms connections : 744
Total HTTP server processes: 242
# swapinfo -tam
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 734 3362 18% 0 - 1 /dev/vg00/lvol2
dev 4092 738 3354 18% 0 - 1 /dev/vgswapapp1_1/lvswap1_1
dev 4092 738 3354 18% 0 - 1 /dev/vgswapapp1_2/lvswap1_2
localfs 800 0 800 0% 800 0 1 /logs/paging
reserve - 9625 -9625
memory 6301 762 5539 12%
total 19381 12597 6784 65% - 0 -
Regard's
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-08-2011 11:23 PM
03-08-2011 11:23 PM
Re: oracle login slow
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-10-2011 02:34 AM
03-10-2011 02:34 AM
Re: oracle login slow
This isn't what that means.
TYPE AVAIL USED FREE USED
dev 4096 734 3362 18%
dev 4092 738 3354 18%
dev 4092 738 3354 18%
localfs 800 0 800 0%
reserve - 9625 -9625
memory 6301 762 5539 12%
total 19381 12597 6784 65%
What this says is:
65% of your total swap has been reserved.
Only 12% of pseudo swap is being used.
So this means that you may have asked for 12.6 Gb of VM. You may have only touched a very small part of it.
So you have reserved 12.6 Gb of VM but you haven't started actively swapping the whole 12.6 Gb. From vmstat(1m) po field.
You have reserved 9.6 Gb and only used 2.1 Gb of your device swap.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-11-2011 09:53 PM
03-11-2011 09:53 PM
Re: oracle login slow
How can i use this memory completely for smooth production.
I mean which area need to be workout to over come with this issue.
Thanks & Regard's
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-11-2011 10:25 PM
03-11-2011 10:25 PM
Re: oracle login slow
Is this bcz i change dbc_max_pct=20 from dbc_max_pct=50 where as on the other node like database dbc_max_pct=35 from dbc_max_pct50.
And the DB memory consumption is 77% swapping 44%.
Do i need to make the application dbc_max_pct=35 , so it use the memory as DB.
Regard's
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-12-2011 05:34 AM
03-12-2011 05:34 AM
Re: oracle login slow
>Do I need to make the application dbc_max_pct=35, so it use the memory as DB.
I assume you don't have Oracle on this machine?
Yes, you could try increasing it.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-12-2011 04:08 PM
03-12-2011 04:08 PM
Re: oracle login slow
Please check the resolv.conf, wheather the DNS server is reachable or not.
That maybe a problem.
Regards,
Arockiasamy K
Arockiasamy K
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2019 Hewlett Packard Enterprise Development LP