How to Kill Session in Logon Trigger
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
DB User
Oracle Who am I
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
How to Duplicate a Schema from One to Another
Suppose you are planning to duplicate user01 schema into user02 schema. Tools like TOAD, SQL Developer can be helpful. But you may also like to… Read More »How to Duplicate a Schema from One to Another
How to Set Password Never Expire
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
Alter System Kill Session, Disconnect Session
Kill Session vs Disconnect Session Oracle SQL provides end_session_clauses syntax to terminate sessions: ALTER SYSTEM { DISCONNECT SESSION 'integer1, integer2' [ POST_TRANSACTION ] | KILL… Read More »Alter System Kill Session, Disconnect Session
How Many Schema Object Types Can You Have
It seems that Oracle does not list all the schema object types exhaustively in the documentation: Schema Object Types So, if you'd like to know… Read More »How Many Schema Object Types Can You Have
Timings to Set SESSIONS Explicitly
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
How to Grant Multiple Object Privileges in One Statement
You don't have to grant object privileges line by line, they can be merged into one statement under some conditions. Here are some cans and… Read More »How to Grant Multiple Object Privileges in One Statement
How to Resolve "The database status is currently unavailable" in Enterprise Manager 11g
Oracle Enterprise Manager DB Console is a somewhat independent software but attached under Oracle database. For some reasons, sometimes it cannot be started, or it… Read More »How to Resolve "The database status is currently unavailable" in Enterprise Manager 11g
SYSDBA vs SYSOPER Privileges
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