-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
When a user account is created on SQLServer on 2005 with user account set to “Enforce password policy” and “Enforce… 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
Shows a way to find if table was truncated, using object_id, data_object_id one can tell possibly if the table was… READ MORE
Using OPatch with lsinventory and bugs_fixed options one can list the PSU patches installed in ORACLE_HOME Example: localhost:/home/oracle $ $ORACLE_HOME/OPatch/opatch… READ MORE
On AIX ran into the following issue where sqlplus generated the following error when using local connection (bequeath). scott@localhost:/home/scott:$ sqlplus… READ MORE
Tom Kyte’s following routine is a utility that can be used to to collect statistics of a session at the… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 