- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Doubt in pfile
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-18-2007 08:23 AM
тАО06-18-2007 08:23 AM
Is it possible to change the pfile dynamically by issuing
"Alter system parameter=parameter value" .
Note : The parameter is not declared in the pfile.
EXAMPLE:
i didnot decalare large_pool_size in pfile.whether i can change the pfile dynamically by issuing
Alter system large_pool_size=1000M;
i declared sga_max_size in pfile.
Help apperciated...
Thanks,
Nirmal.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2007 07:12 PM
тАО06-18-2007 07:12 PM
Re: Doubt in pfile
I dun have the answer to your question but you can subscribe to the mailing lists at lazydba.com, after that you will have one more group of db experts in addition it itrc experts to get the answers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2007 08:35 PM
тАО06-18-2007 08:35 PM
Re: Doubt in pfile
Which version of Oracle are you using?
In 10g, you would do the following:
1. alter system set large_pool_size=80M scope both;
2. create pfile from spfile;
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2007 12:34 AM
тАО06-19-2007 12:34 AM
Re: Doubt in pfile
show parameter large_pool_size - will tell you the current value.
You can modify with
alter system set...
The default scope is BOTH, so the parameter will be changed dynamically and in the spfile. If you set sga_max_size, then you can only change parameters that will not cause the sga to grow beyond max_sga_size. If you try and increase the total sga size beyond max_sga_size it will error.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2007 08:06 AM
тАО06-19-2007 08:06 AM
Re: Doubt in pfile
Thank you for ur suggestions...
iam not asking whether we can change the value dynamically after declaring the large_pool_size parameter in pfile.
my question is without declaring large_pool_size parameter in pfile.
whether we can issue the below query
alter system large_pool_size=1000M;
Note: we are not using SPFILE in our environment.
yogeeraj - we are using 9i version oracle.
Thanks,
Nirmal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2007 10:02 AM
тАО06-19-2007 10:02 AM
SolutionAlso, you noted that you have set sga_max_size, which is good. Increasing the large_pool from a non-zero value will cause an increase in the SGA size. If max_sga_size is unset, then the SGA cannot grow beyond the initial allocation (mostly from shared_pool, db_cache_size, and java_pool), and the attempt to increase the large_pool would fail with ORA-4033, Insufficent memory to grow pool. In this case, however, you could dynamically shrink one of the other memory pools to allocate space for the large_pool. This holds whether or not the large_pool_size was explicitly declared in the init file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2007 07:21 PM
тАО06-19-2007 07:21 PM
Re: Doubt in pfile
YES. without declaring large_pool_size parameter in pfile, you can issue the below query:
alter system large_pool_size=1000M;
However, beware that on the next database restart the value will be reset to the default (as specified in the pfile)
One of the advantages of using the spfile is that you do not have to go manually change the physical file when you make a change at the database level. Changes to the spfile is "made" using SQL commands...
good luck!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2007 05:57 AM
тАО06-20-2007 05:57 AM
Re: Doubt in pfile
Thank u very much..
- Nirmal.