| instance [message #293199] |
Fri, 11 January 2008 03:29  |
armaan_dba
Messages: 3
Registered: January 2008
Location: india
|
Junior Member |
|
|
hello every one my queation is when we create an instance in 10g what is the default size of that intance? can we maximize our instance size?
[Updated on: Fri, 11 January 2008 03:36] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: instance [message #293312 is a reply to message #293303] |
Fri, 11 January 2008 12:04  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
There is no log file or data file size in init.ora, I think this is the question.
Anyway, what are the default pool sizes if there are not in init.ora, this is another question.
Regards
Michel
[Updated on: Fri, 11 January 2008 12:05] Report message to a moderator |
|
|
|
|
|
| Re: instance [message #293396 is a reply to message #293199] |
Sat, 12 January 2008 02:31 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I think the OP needs to know instance size and not database size.
An instance size is the size of the SGA.
SGA size is the memory parameters defined in init.ora file.
Default SGA size is what you set in your init.ora file when you create database.
You can use DBCA to see and modify your instance size.
|
|
|
|
| Re: instance [message #293397 is a reply to message #293396] |
Sat, 12 January 2008 02:55 |
|
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: |
Default SGA size is what you set in your init.ora file when you create database.
|
This is wrong.
And what if you NEVER set anything in your init.ora?
Regards
Michel
[Updated on: Sat, 12 January 2008 02:56] Report message to a moderator |
|
|
|
| Re: instance [message #293401 is a reply to message #293199] |
Sat, 12 January 2008 03:19 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
| Quote: |
And what if you NEVER set anything in your init.ora?
|
Is it possible?
How would the instance be started then?
|
|
|
|
|
|
|
|
|
|
| Re: instance [message #293428 is a reply to message #293199] |
Sat, 12 January 2008 10:36 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
but you said| Quote: |
As far I remember, there is only ONE mandatory parameter: db_name.
|
Michel, Can you demonstrate what you said?
|
|
|
|
|
|
| Re: instance [message #293466 is a reply to message #293431] |
Sun, 13 January 2008 01:40 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
Michel Cadot is correct. The design of Oracle database is such that even if you do not specify/use any any of configuration file such as PFILESPFILE ,listener.ora, tnsnames.ora, sqlnet.ora than also a database can be created, connected to & run smoothly. The credit goes to default values assumed while an instance or listener is started. The rule is simple if values are available in configuration files than use them else silently assume defaults. This is the beauty of Oracle & you do not get this beauty in any other enterprise class software.
If you want to have a taste than go ahead & try for yourself on a test machine, you will be happy to discover this behavior of Oracle. The only basic requirement is you should understand what you are doing. But before you do it just brush up little on oracle fundamentals. In Oracle world Every file which oracle expects has a default location & if file is not there than there is a default behavior in absence of file similarly every parameter is expected in some configuration file is not found there than there is a default value.
Do not ever try this test on a production. If attempting on a already existing database than do not forget to relocate controlfiles , logfiles & data files to expected default locations.
Regards
Manjit Kumar [ mkbhati]
[Updated on: Sun, 13 January 2008 01:42] Report message to a moderator |
|
|
|
|
|
| Re: instance [message #293657 is a reply to message #293199] |
Mon, 14 January 2008 07:49 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I am on 9.2.0.1
| Quote: |
startup nomount pfile=/.users/mount/mcadot/temp/initMCA.ora
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 2028656 bytes
Variable Size 113249168 bytes
Database Buffers 50331648 bytes
Redo Buffers 6356992 bytes
|
So these are the default values..
I did the same thing but got the error the following error:
SQL> startup nomount pfile='C:\oracle\admin\testdb\pfile\init_testdb.ora'
LRM-00109: could not open parameter file 'C:\oracle\admin\testdb\pfile\init_testdb.ora'
ORA-01078: failure in processing system parameters
SQL>
As you told,i have only parameter "db_name=testdb" in my init file.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: instance [message #293706 is a reply to message #293199] |
Mon, 14 January 2008 12:59 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
Ok finally done,,,
| Quote: | Michel Cadot is correct. The design of .....
|
ofcourse i know he is correct.All i wanted to do is to try it myself but was unsure.
this might be on behalf of Armaandba.
Where are these default values stored or from where does oracle retrieve these values?
[Updated on: Mon, 14 January 2008 13:01] Report message to a moderator |
|
|
|
| Re: instance [message #293709 is a reply to message #293706] |
Mon, 14 January 2008 13:19 |
|
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | Where are these default values stored
|
Inside the code.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
