- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Recommendations for tunable shmmax in preparat...
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
тАО03-16-2007 04:36 AM
тАО03-16-2007 04:36 AM
Re: Recommendations for tunable shmmax in preparation for Oracle10g
at the moment the value is set to abt. 22 GB (of 32 GB RAM), so I would think I could well leave it at that.
# kmtune -q shmmax|perl -alne 'print hex($F[1])/2**30 if $F[0] eq "shmmax"'
22
How can I find out how much memory was assigned to the old 9i DB?
In the pfile init
There must exist a view in the data dictionary that one can query by a simple SQL statement?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2007 04:43 AM
тАО03-16-2007 04:43 AM
Re: Recommendations for tunable shmmax in preparation for Oracle10g
# ipcs -mob|grep oracle
m 368649 0xe0377310 --rw-rw---- oracle dba 13 98275328
m 3082 0xe71d289c --rw-r----- oracle dba 797 13826273280
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2007 04:57 AM
тАО03-16-2007 04:57 AM
Re: Recommendations for tunable shmmax in preparation for Oracle10g
>show sga
That will show the sga size.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2007 04:59 AM
тАО03-16-2007 04:59 AM
Re: Recommendations for tunable shmmax in preparation for Oracle10g
http://orafaq.com/node/8
I believe that it will answer a lot of your questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2007 05:32 AM
тАО03-16-2007 05:32 AM
Re: Recommendations for tunable shmmax in preparation for Oracle10g
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2007 06:01 AM
тАО03-16-2007 06:01 AM
Re: Recommendations for tunable shmmax in preparation for Oracle10g
I think all responses are valid and helpfull enough to help Ralph make his decision.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2007 12:41 AM
тАО03-21-2007 12:41 AM
Re: Recommendations for tunable shmmax in preparation for Oracle10g
SQL>
Total System Global Area 1.3809E+10 bytes
Fixed Size 756808 bytes
Variable Size 1795162112 bytes
Database Buffers 1.2012E+10 bytes
Redo Buffers 1060864 bytes
which indeed is the shm seg @ ID 522 as I already have assumed:
# ipcs -mob|grep ora
m 167945 0xe0377310 --rw-rw---- oracle dba 12 98275328
m 522 0xe71d289c --rw-rw---- oracle dba 1165 13826273280
- « Previous
-
- 1
- 2
- Next »