set linesize 200
col event for a30
col username for a20
set pagesize 40
col p1 for 999999999999
col OSUSER for a12
select inst_id,v.seq#,SQL_EXEC_ID,v.sid,username,v.event,
v.p1,v.p2,v.p3,sql_hash_value,sql_id,SQL_CHILD_NUMBER,s.seconds_in_wait
from gv$session_wait v, gv$session s where s.sid=v.sid and
s.INST_ID=v.INST_ID and username =’&username’
order by sql_id;

16-June

AWR_SNAPSHOT_TIME_OFFSET: typically the AWR snapshots will be taken at the top of the hour and all the databases in a server triggering snapshot may lead to CPU spikes. You can specify this parameter between 0 – 3599 to specify an offset of an hour. All the instance of a database should share the same value. A constant 1,000,000 will enable automatic mode and the AWR snapshot time will be based on the name of the database.

Temporary UNDO: Oracle 12c can direct the temporary undo (UNDO generated by operations on temporary tables) to the temporary tablespace rather than to instance UNDO tablespace. You may set TEMP_UNDO_ENABLED=TRUE and default value is TRUE. These temporary undo segments are known as Temporary Undo Segments.

taskset linux command to pin a process to a CPU socket. For example the PID 6528 to pin to a socket

# taskset –pc 2-3 6528

07-June

PARALLEL_FORCE_LOCAL: TRUE parameter restricts the slave processes to open in the local instance if FALSE will open the parallel slave connections in all nodes in the cluster.

Global Data Services (GDS): is global service configuration which spans across multiple databases and severs geographically different locations. Global Service Catalog holds the configuration information and directs the connections to an appropriate local service. Various components in the service catalog communicated through ONS (Oracle Notification Services). GDSCTL utility can be used to add, modify and delete Global Service catalog information.

02-June

The view V$RECOVERY_PROGRESS will give the SCN and time of the last applied redo.

COMMENTS : SCN numbers

TIMESTAMP : Last applied log time stamp

V$DATAGUARD_STATE also gives the status of both Transport and Apply lag.