- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Bad performance in my database & dedlock very urge...
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
тАО07-05-2003 12:07 AM
тАО07-05-2003 12:07 AM
Bad performance in my database & dedlock very urgent
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 12:18 AM
тАО07-05-2003 12:18 AM
Re: Bad performance in my database & dedlock very urgent
could it be a "resource_manager_plan=SYSTEM_PLAN " related problem?
please post more details about what type of problem you are encountering.
thanks
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 12:45 AM
тАО07-05-2003 12:45 AM
Re: Bad performance in my database & dedlock very urgent
The user they lock many time when start to work in the system when I check the log oracle file give this system do deadlock in this way the system hang
I need to know how I can use the best performances of 2 CPU
What the best parameters
And how I can stop resource the plan of the system in oracle
What is the suitable parameters in kernel UNIX system
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 01:53 AM
тАО07-05-2003 01:53 AM
Re: Bad performance in my database & dedlock very urgent
1.First check what is the value for
dbc_max_pct.
This parameter defines the dynamic buffer cache and takes half the memory be default i.e a value of 50.
For the memory of 1.5GB place the parameter to around 20.
Bring down the dbc_min_pct to 10.
Also
Are you running three or four databases on the same machine.
If only one It looks like these parameters are high
semmni 8200
semmns 16400
semmnu 4096
substantiate that these values are required.
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 01:54 AM
тАО07-05-2003 01:54 AM
Re: Bad performance in my database & dedlock very urgent
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 02:24 AM
тАО07-05-2003 02:24 AM
Re: Bad performance in my database & dedlock very urgent
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 02:35 AM
тАО07-05-2003 02:35 AM
Re: Bad performance in my database & dedlock very urgent
dbc_min_pct to 20
one database
what the good value for that parameters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 02:47 AM
тАО07-05-2003 02:47 AM
Re: Bad performance in my database & dedlock very urgent
semmni 8200
semmns 16400
semmnu 4096
It looks high for me
These parameters take away the memory and increase the amount of locked memory.
About the buffer cache values you can bring them down to the value suggested in the previous post.
Just browsed your trace file and looks like the memory is getting exhausted.
I will go the same again and will revert
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 03:05 AM
тАО07-05-2003 03:05 AM
Re: Bad performance in my database & dedlock very urgent
For semmsl,
Set it to 10 plus the largest initsid.ora PROCESSES parameter of an
Oracle database on the system.
For SEMMNS,
Set it to the sum of the PROCESSES parameter for each Oracle database
, plus 2 times the largest PROCESSES value, plus 10
number of Oracle databases.
For example, consider a system that has three Oracle instances with the PROCESSES parameter in their initsid.ora files set to the following values:
ORACLE_SID=A, PROCESSES=100
ORACLE_SID=B, PROCESSES=100
ORACLE_SID=C, PROCESSES=200
The value of SEMMNS is calculated as follows:
SEMMNS = ((A=100) + (B=100)) + ((C=200) * 2) + ((# of instances=3) * 10) = 630
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2003 03:21 AM
тАО07-05-2003 03:21 AM