-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
undefine usr db col usr new_value usr col db new_value db set termout off select lower(user) usr, instance_name db from… READ MORE
To see current stats of your session, one can run the following query. SELECT a.name, b.value FROM v$statname a, v$mystat… 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
By having a logon trigger in a database one can monitor or audit OS user, programs, DB users, time users… READ MORE
If you are doing migrating to a new filesystem and moving files, it may be a good idea to check… READ MORE
|
If you are not using RMAN to backup data and use technologies like NetApp snapshot which doesn’t check for physical… READ MORE
|
Using incorrect format when backing up to tape can cause an issue during recovery if the backup pieces have the… READ MORE
Killing the rman main process from the command line doesn’t immediately kill the rman sessions using the script below which… READ MORE
— view oracle internal parameters, note this can be run by SYS user — name, value, default value, session modifiable,… READ MORE
|
On Oracle9i if you get the following error when running export (exp) utility, to fix this issue one would need… READ MORE
NLS_LANG=<language>_<territory>.<character set> Example: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 Setting NLS_LANG tells Oracle what characterset the client is using so Oracle can do conversion… READ MORE
For SQL*Plus to process french accents characters when using SQL*Plus, you would need to set NLS_LANG On Windows set NLS_LANG=.AL32UTF8… READ MORE
Move from single instance to RAC 1- Install CRS 2- Install new RDBMS binaries rac enable 3- Make sure there… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 