-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Last updated: 17-Nov-2008 When exporting/importing one can minimize risk of losing data during import/export by setting NLS_LANG. – Before starting… READ MORE
|
The following example shows how to find lock on a store procedure, the following store procedure has infinite loop. A… READ MORE
— note this will work when not logged in as SYS, as the session id is the same for all… 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
|
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
“Control what I can control”
~ Alex Lima
Alex Lima 