- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to familiarise my database's behaviour?
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
тАО06-10-2002 07:18 PM
тАО06-10-2002 07:18 PM
How to know if SGA is enough?
If Oracle doesn't use OS buffer cache, can I reduce it by reducing dbc_max_pct?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 07:33 PM
тАО06-10-2002 07:33 PM
SolutionHave you already done a search on the ITRC forums?
> Can anyone tell me how I can know my Oracle8i database's behaviour on HPUX11, such as % of read/write, % of sequential/random read/write?
One way is to use OEM I believe. There are some third-party Oracle performance monitoring tools which can be found by performing a search on google.
> How to know if SGA is enough?
It is also limited by how big your shmmax is and how many shared memory segments you are having on the system.
> If Oracle doesn't use OS buffer cache, can I reduce it by reducing dbc_max_pct?
Yes, to prevent double-buffering. Oracle uses its own buffer cache. You can reduce dbc_max_pct to 5% and dbc_min_pct to 3% if you like.
Hope this helps. Regards.
Steven Sim Kok Leong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 07:34 PM
тАО06-10-2002 07:34 PM
Re: How to familiarise my database's behaviour?
It is spotlight on oracle.If you are not familiar with sqlplus queries.you can install it on a windows machine and connect to your database.Try it.
http://www.quest.com/requests/?RequestDefID=182
THanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 07:43 PM
тАО06-10-2002 07:43 PM
Re: How to familiarise my database's behaviour?
For a starters I would have your shmmax is at least 1gb. How much RAM do you have ?
The buffer cache should be set to somewhere
around 300mb.
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 08:03 PM
тАО06-10-2002 08:03 PM
Re: How to familiarise my database's behaviour?
#kmtune|grep shm
shmem 1
shmmax 0X0000000040000000
shmmni 512
shmseg 120
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 08:41 PM
тАО06-10-2002 08:41 PM
Re: How to familiarise my database's behaviour?
Reduce the dbc_max_pct parameter there
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 08:51 PM
тАО06-10-2002 08:51 PM
Re: How to familiarise my database's behaviour?
There are lots of site which give the bencmark results in terms of tpc etc etc . You can try looking at :
http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
However for the specific question that u ahve posed well it depends on lots of factors like
memory of the machine , SGA etc etc , Yes oracle does vary in behaviour on OS cache , all you can do it to cahnge it and see the behaviour
also look at these
Parameter Required
==================================
SHMMAX 1gb
SHMMIN 1
SHMMNI 100
SHMSEG 10
SEMMNI 70
SEMMNS 200
MAX_THREAD_PROC >= 256
Manoj Srivastava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 08:51 PM
тАО06-10-2002 08:51 PM
Re: How to familiarise my database's behaviour?
Suggest you use this as a guide. Your shmmax is
certainly not large enough. If you have 4gb RAM
you may need a larger shared memory.
# kmtune | grep -i shm
shmem 1 - 1
shmmax 2147483648 Y 2147483648
shmmni 1024 - 1024
shmseg 1024 Y 1024
For your 'dbc_max_pct' set to 8%, this will
reduce the size to 327Mb should be plenty.
As mentioned before anywhere around 300Mb is enough.
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 08:53 PM
тАО06-10-2002 08:53 PM
Re: How to familiarise my database's behaviour?
DB_CACHE_SIZE(DB_BLOCK_BUFFERS),SHARED_POOL_SIZE,LARGE_POOL_SIZE,PROCESSES,etc.
It depends how you set these parameters.So when you are creating the database these parameters are set and the size of the SGA is dynamically altered.
There is no problem that you can change these parameters on the run which dynamically changes the SGA size.
Unless you specify the max_sga_size parameter which limits the SGA,you can alter these above parameters to dynamically change the SGA size.
It depends whether your database is a small,medium or large one.The init.ora file(initialization file for database) you can find the values for small,med and large database recommened size of the above parameters.Find the suitable one and create the database.Later if the value requires to be bumped up you can do it
Thanks
G Manikandan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2002 01:26 AM
тАО06-11-2002 01:26 AM