-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session altered. SQL> SELECT TRUNC(sysdate) FROM DUAL; TRUNC(SYSDATE) ——————– 2009-MAY-10… READ MORE
|
There are few ways to calculate end of day i.e when the time is 23:59:59. In the example below it… READ MORE
The following article gives some background on how to stop the transaction log from growing Using the steps below one… READ MORE
Using the steps below one can find the object that is unrecoverable from UNRECOVERABLE_CHANGE# in the v$datafile, one would use… READ MORE
One can flush the shared pool using the following DDL. SQL> ALTER SYSTEM FLUSH SHARED_POOL; System altered. Using the following… READ MORE
|
Immediately after a successful RDBMS installation (perhaps even including a sample DB instance creation), sqlplus will not start: [oracle@test ~]$… READ MORE
Using the following query one can find the datafiles that had nologging turned on, direct load or unrecoverable option was… READ MORE
|
To use automatic shared memory management, the value of statistics_level must be set to “typical” or “all”. The parameter can… READ MORE
|
Using stty one can set some of keys like backsapce, interrupt, suspend and kill. $ stty -a # shows the… READ MORE
|
Using strace (linux)/truss (AIX) one can trace the system calls as program executes. It can be useful in identifying where… READ MORE
|
In v$session osuser, program are not set when oracle client 10.2.0.1 is used when SQLDeveloper and oracle client are installed… READ MORE
|
When an java app connects to oracle depending on the driver such as osuser, program in v$session will not be… READ MORE
|
h – Left l – Right k – Up j – Down w – Move forward to beginning of next… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 