-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
Here are some of the scenarios when one gets ORA-01031: 1) Insufficient privileges error is when “oracle” user is not… READ MORE
|
There are few ways to change case of text in a file from lower case to upper case or vice-versa.… READ MORE
|
When you are copying oracle files (datafiles, archivelogs, controlfiles, etc) or any binary file one can compare if the files… READ MORE
|
Using chsh one can change their login shell. To show the shells that are available $ chsh -l /bin/sh /bin/bash… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 