-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
In “ALTER SYSTEM” one can include a comment which gets recorded in the spfile and also in v$parameter as shown… READ MORE
Using ALTER SYSTEM RESET one can delete parameter from spfile if the parameter is in the spfile. Example: — shows… READ MORE
This parameter controls the format of the archive log file name. This parameter can’t be changed on the fly therefore… READ MORE
To make trace files visible to all users, set the parameter _TRACE_FILES_PUBLIC=TRUE, this is undocumented parameter. This parameter requires a… READ MORE
There are couple of ways of finding if the database was started with spfile or pfile. One way would be… READ MORE
To identify the parameter one can query v$parameter view to find the parameters that were modified. The column ISMODIFIED is… READ MORE
— view oracle internal parameters, note this can be run by SYS user — name, value, default value, session modifiable,… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 