-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
We had an issue the other day when one of the Sharepoint database logs became extremely large as the server… READ MORE
If for some reason the online redo log were lost or when cloning the copy of shutdown database you don’t… READ MORE
-- Step 1) set up environment variables needed (ORACLE_HOME, ORACLE_SID and add ORACLE_HOME\bin to PATH) set ORACLE_HOME=e:\oracle\11g\product\11.2.0.1 set PATH=%ORACLE_HOME%\bin;%PATH% set… READ MORE
|
To create a baseline of performance of the system, one create a baseline and used for later comparisons. If a… READ MORE
One can make Oracle suspend a session if it runs out a free space by enabling resumable timeout. This can… READ MORE
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect… READ MORE
The following shows how exceptions can be captured. — Create exceptions table SQL> @?/rdbms/admin/utlexcpt.sql Table created. SQL> desc exceptions; Name… READ MORE
|
Using SESSION_ROLES it will retrieve the current roles that are active for a user in a session. Example: SQL> connect… READ MORE
|
It seems at times when roles are assigned they are not assigned as DEFAULT role to a user. The reason… READ MORE
— Global temporary table which keeps records till session create global temporary table temp1( year number ) on commit preserve… READ MORE
|
SQL> select b.sid, b.serial#, a.spid processid, b.process clientpid from v$process a, v$session b where a.addr = b.paddr and b.audsid =… READ MORE
In 11g the Oracle the hash password is no longer stored in DBA_USERS, it is stored in SYS.USER$ table in… READ MORE
In 11g Oracle supports password to be case sensitive. But the password can be case insensitive depending on value of… READ MORE
The issue occurs when there is a db link which is a loop back database link i.e. points to itself… READ MORE
“RESOURCE_LIMIT” parameter is used to enable/disable “KERNEL” resource type profiles. Password parameters are part of profiles but they are controlled… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 