- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: two database on a single server
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-27-2006 09:58 PM
тАО08-27-2006 09:58 PM
two database on a single server
I am using True 64 Unix 5.1 OS. When i am using two database on this server both database comes down very slow. Single database is working fine, But when i create second database then this problem occurs
server configuration is
1.5 GB RAM
Dual processor
70 GB HDD
Database Details
ONE
database size 8 GB
SGA size 300 MB
Second
database size 12 GB
SGA size 300 MB
What could be the reason????
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2006 06:32 PM
тАО08-28-2006 06:32 PM
Re: two database on a single server
If you can, try to install more RAM.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2006 06:49 PM
тАО08-28-2006 06:49 PM
Re: two database on a single server
How much RAM should be increased.????
I think something is wrong with shared memory kernel parameters also. Can you please tell me the configuration for the same scenerio.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2006 07:03 PM
тАО08-28-2006 07:03 PM
Re: two database on a single server
before taking any further action, can you please post the output of the following command:
kmtune |grep shmmax
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2006 11:41 PM
тАО08-30-2006 11:41 PM
Re: two database on a single server
what should be the value of shmmax and other kernel parameters according to the scenerio.
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2006 02:01 AM
тАО08-31-2006 02:01 AM
Re: two database on a single server
http://docs.hp.com/en/939/KCParms/KCparams.OverviewAll.html
and there for semaphore parameters :
http://docs.hp.com/en/939/KCParms/KCparam.SemaphoreParamsList.html
http://www.dbforums.com/t497029.html
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=504530
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=607147
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-04-2006 01:16 AM
тАО09-04-2006 01:16 AM
Re: two database on a single server
put on a shell file :
LANG=fr_FR.iso88591;
export LANG;
date
fic=/tmp/SAR_`date '+%Y%m%d' `
echo $fic
sar -o $fic 60 1440 > /dev/null
This command put in a file something like a day of sar out put
After analyse the result .
Other way : check the swap
because a new database take memory and increase i/o demands.
for the memory : SGA + X Mb by each connection.
Regards Thierry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-04-2006 03:07 AM
тАО09-04-2006 03:07 AM
Re: two database on a single server
Then you may want to re-post in the Tru64 forum, or some Oracle forumm, for better exposure.
Which Oracle version? May we assume 10g?
Did you follow the Tru64 pre-installation tasks? I guess not, otherwise you would not ask for shm_max advice: it's all in the doc!
"Oracle├В┬о Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide
10g Release 2 (10.2) for hp Tru64
Part Number B14206-01"
http://download-east.oracle.com/docs/cd/B19306_01/install.102/b14206/pretru.htm#sthref435
For advanced tuning see:
http://download-east.oracle.com/docs/html/A97297_01/appd_tru.htm
What is 'very slow'? Seconds or Minutes?
With users or just up and down again?
What is happening when it is comming down?
Disk IO? Nothing? CPU time? system CPU time?
If it is (system) CPU times, then I'd recommend a quick 'kprofile' or 'dcpi' run to see where the system is spending time.
I recall cases of slow Oracle rundown in older versions of Tru64 (called OSF back then!) with large numbers of users. GH memory was designed to solved that.
If the it is CPU busy, then I suspect a shared memory issue and woulc doublecheck settings for GH (sysconfig -q vm | grep gh) and ssm_threshold
Good luck!
Hein.