on 02-25-2014 8:46 AM
Hello,
I'm checking Oracle parameters, and the deprecated parameters not appear on initSID.ora, but If I execute the show parameter background_dump_dest, I can see the result og this parameter. Is it the parameter set?
Hello
Please read Oracle documentation to understand how the BACKGROUND_DUMP_DEST parameter works.
The trace files will still be created whether the parameter BACKGROUND_DUMP_DEST is set or not.
If you set the parameter BACKGROUND_DUMP_DEST with a specific directory value then the database will use that directory for the trace files.
If the parameter BACKGROUND_DUMP_DEST is not set then the database will use this:
$ORACLE_HOME/admin/db_name/bdump on UNIX operating systems
%ORACLE_HOME%\admin\db_name\bdump on Windows NT and Windows 2000 operating systems
The logs will be created under the base directory and the base directory is based on the parameter DIAGNOSTIC_DEST
Query the v$diag_info view to find the details.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ruben,
If you have not set the parameter in initSID.ora, sql command show parameter shows default value .
It implies parameters is active with default value which may or may not suit the environment.
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ruben,
Show parameter command will display the parameter values that are currently in effect.
Even if you use "alter system reset" to remove a parameter from a server parameter file, this will cause the default value to take effect the next time you start an instance of the database.
As currently default value already exists , there is no need to execute reset command.
Since these parameters exists with default value you may get information message while starting the database. You may ignore these messages.
Hope this helps.
Regards,
Deepak Kori
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.