-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
SQL>grant select on dba_objects to <username>; SQL>conn <username>/<password> SET PAGESIZE 0 SET LONG 100000 SET LONGCHUNKSIZE 10000 SET LINESIZE 1000… READ MORE
|
If you are using the RMAN and using the RMAN catalog to write directly to tape you can use the… READ MORE
To change the Sysman password: 1. Stop the OMS instances that are associated with the repository a. opmnctl stopall 2.… READ MORE
|
CREATE OR REPLACE TRIGGER sys.session_trace_on– to be created by sys userAFTER LOGON ON databaseDECLAREmachinename VARCHAR2(64);osuserid VARCHAR2(30);ora_username VARCHAR2(30) DEFAULT NULL;os_username VARCHAR2(30);v_sid… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 