-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Using the following SQL you can monitor the progress of RMAN process, as channels completes creating the backpiece new sessions… READ MORE
The following 2 links explains transaction isolation. http://www.acs.ilstu.edu/docs/Oracle/server.101/b10743/consist.htm http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html READ MORE
|
Each schema may require a PLAN_TABLE to debug performance so instead of creating the PLAN_TABLE within each schema, one can… READ MORE
|
To change default number of bytes to be displayed when selecting LONG and CLOB columns. SQL> SET LONG 2000 SQL>… READ MORE
Adding the following line before running a SQL Script will terminate the SQL script from running and rollback the change… READ MORE
One can view the password change history by querying oracle’s internal table SYS.USER_HISTORY$, note this table gets updated only if… READ MORE
|
If you have ‘&’ as part of your data that is part of the string and needs to inserted/updated/deleted and… READ MORE
|
Using the command it will show the processes that has the file open. E.g: $ fuser /u01/oradata/TEST/system01.dbf /u01/oradata/TEST/system01.dbf: 2650128 2662644… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 