- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Very slow database (with a large SGA 10GB) startup
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-11-2002 03:20 PM
тАО09-11-2002 03:20 PM
Very slow database (with a large SGA 10GB) startup
Do we need to setup any parameters
to speed up the database startup (9i RAC on HP-UX 11i)?. We have 16GB RAM , two swap disks (4GB and 12GB).
Thanks for all your help on this..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-11-2002 06:00 PM
тАО09-11-2002 06:00 PM
Re: Very slow database (with a large SGA 10GB) startup
Otherwise, you will most likely have to wait for the system to continue normal startup. Also, if this is a problem, you will want to make sure you don't shutdown abort unless you have to, as the startup recovery portion can take a bit if there is alot of undo to perform.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2002 05:09 AM
тАО09-12-2002 05:09 AM
Re: Very slow database (with a large SGA 10GB) startup
Now the good news is that the gathering of that data occurs once at bootup and subsequent use and updating of the tables will be at memory speeds. So you afre trading a long startup for instant response while it is running.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2002 07:59 AM
тАО09-12-2002 07:59 AM
Re: Very slow database (with a large SGA 10GB) startup
Thanks for your reply. Actually we are just trying to start the system and we have not started the database access yet. We are in the process of configuring the database and our estimate with regards to SGA is that we will need to have a 10GB SGA.
So we are looking for information on recommendations for appropriate values for various kernel parameters.
Thanks and regards
Prakash
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2002 08:07 AM
тАО09-12-2002 08:07 AM
Re: Very slow database (with a large SGA 10GB) startup
In any event, it's going to take some time to start your database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2002 08:16 AM
тАО09-12-2002 08:16 AM
Re: Very slow database (with a large SGA 10GB) startup
I am checking the timeslice parameter. Here is some additional info.
We have 8GB RAM/16GB swap on the each of the nodes.
When the SGA is 4GB the db starts up in couple of minutes. With SGA =6GB db doesn't come up even after an hour. So I guess that is too long.
There is nothing else going on the server. We are just trying to bring up the database with the 6GB or more SGA.
Thanks once again for all your input.
Regards
Prakash
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2002 12:38 PM
тАО09-13-2002 12:38 PM
Re: Very slow database (with a large SGA 10GB) startup
if it is set to TRUE, then u may experience slow startups.
make sure it is FALSE.
Mandar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2002 10:29 AM
тАО09-14-2002 10:29 AM
Re: Very slow database (with a large SGA 10GB) startup
have you restricted your buffer cache to a maximum of about 400MB? That would safe you a lot of RAM... (and your timeout experience sounds alot like a RAM bottleneck)
And do you use the "OnLineJFS" and the additional mount-options "convosync=direct,mincache=direct" to instruct the kernel to bypass the whole buffer cache for the I/O to/from the filesystems mounted that way? Of course those filesystem must only have "datafiles" stored on them, no "logfiles", or "controlfiles", or "codefiles", or anything else...
For the two special init*ora parameters "pre_page_sga" and "lock_sga", I would actually USE them (=true), to ensure that the SGA is allocated in RAM at the very start of your instance, and *stays* in RAM. The difference in time will not be one hour due to these parameters.
HTH,
Wodisch