Here I introduce a trigger which can log logon information on specific schemas. It will kill their sessions if they are not from specific subnet.… Read More »How to Kill Session in Logon Trigger
Sometimes, you switched the connection to another schema for more operations and forgot where you are. Here are some ways to know who am I… Read More »Oracle Who am I
PASSWORD_LIFE_TIME UNLIMITED The password expiration notice is actually an Oracle error, ORA-28002: the password will expire within days. To avoid the error, we have to… Read More »How to Set Password Never Expire
DBAs usually set PROCESSES when initializing a new database:SQL> alter system set processes=3000 scope=both;System altered.Another important parameter SESSIONS will be derived from PROCESSES automatically in this… Read More »Timings to Set SESSIONS Explicitly
SYSDBA vs SYSOPER According to Oracle documentation about administrative accounts and privileges, I compared their privileges between SYSDBA and SYSOPER as below: Allowed Actions SYSDBA… Read More »SYSDBA vs SYSOPER Privileges