- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Max db_files
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-20-2004 11:43 PM
тАО08-20-2004 11:43 PM
Max db_files
I tried editing the spfile but it is not working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-21-2004 05:44 AM
тАО08-21-2004 05:44 AM
Re: Max db_files
Hello Kiran,
We are talkign Oracle here right? What version? What does 'not working' mean?
sqlplus "/ as sysdba"
... sql> show parameter db_files
change
shutdown
startup
sql> show parameter db_files
From the Oracle Doc:
"When starting an Oracle instance, the DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and thus, the maximum number of datafiles that can be created for the instance. This limit applies for the life of the instance. You can change the value of DB_FILES (by changing the initialization parameter setting), but the new value does not take effect until you shut down and restart the instance."
The spfile is a 'newish' method to controll params like db_files on startup. This used to be initXXX.ora. Just google for spfile, or hit the Oracle online doc for furhter details on how to (not) use that file.
Some potentially useful references below.
Cheers,
Hein.
http://www.oracle.com/pls/db92/db92.print_hit_summary?search_string=spfile
http://www.oracle.com/technology/documentation/oracle9i.html
http://www.oracledba.co.uk/tips/9i_spfile.htm
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2200190221847
http://www.praetoriate.com/oracle_tips_spfile.htm
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-21-2004 06:22 AM
тАО08-21-2004 06:22 AM
Re: Max db_files
Please find the enclosed attachment.
Hari
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-21-2004 10:51 PM
тАО08-21-2004 10:51 PM
Re: Max db_files
create
I edited the pfile(init
This solved the problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2005 02:30 AM
тАО11-02-2005 02:30 AM
Re: Max db_files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2005 12:32 PM
тАО11-02-2005 12:32 PM
Re: Max db_files
alter system set max_db_files = xxx scope=spfile;
Brian