Differences

This shows you the differences between two versions of the page.

--- oracle [2020/01/03 10:05]
ss_wiki_admin
+++ oracle [2021/04/23 07:54] (current)
ss_wiki_admin [ASM]
@@ Line 549: / Line 549: @@
 ==== Auditing Control ====
+== Get size of Audit Table ==
+<code sql>
+select segment_name table_name ,bytes/1024/1024 size_in_megabytes from dba_segments where segment_name in ('AUD$');
+</code>
+== Show count of audited actions ==
+<code sql>
+select username,OWNER,OBJ_NAME,ACTION,ACTION_NAME,count(*) from dba_audit_trail group by username,OWNER,OBJ_NAME,ACTION,ACTION_NAME;
+</code>
 ==Show audited options==
 <code sql>
@@ Line 697: / Line 707: @@
 select slave_name, sessions, idle_time_cur, cpu_secs_total
   from v$pq_slave order by slave_name;
-<code>
+</code>
 == Show global parallelism details ==
@@ Line 745: / Line 755: @@
 SQL>
 select * from gv$asm_operation;
+</code>
+== Show rebalance operation estimates ==
+<code sql>
+select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
 </code>
@@ Line 765: / Line 780: @@
 == Add disk to diskgroups ==
 <code sql>
-SQL> alter diskgroup dbfs_dg add disk 'o/192.168.3.143/DBFS_DG_CD_04_m1cel03man' name DBFS_DG_CD_04_m1CEL03MAN force rebalance nowait
+SQL> alter diskgroup dbfs_dg add disk 'o/192.168.3.143/DBFS_DG_CD_04_m1cel03man' name DBFS_DG_CD_04_M1CEL03MAN force rebalance nowait
-SQL> alter diskgroup reco_m1 add disk 'o/192.168.3.143/RECO_M1_CD_04_m1cel03man' name RECO_HEM1_CD_04_M1CEL03MAN
+SQL> alter diskgroup reco_m1 add disk 'o/192.168.3.143/RECO_M1_CD_04_m1cel03man' name RECO_M1_CD_04_M1CEL03MAN
 </code>
@@ Line 786: / Line 801: @@
 == Drop old disk ==
 <code sql>
-alter diskgroup DATA_HEM1 drop disk '_DROPPED_0074_DATA_HEM1';
+alter diskgroup DATA_M1 drop disk '_DROPPED_0074_DATA_M1';
 </code>
@@ Line 797: / Line 812: @@
 == Moving multiple files inside ASM ==
 <code bash>
-for i in $(asmcmd ls +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2); do
+for i in $(asmcmd ls +RECOC1/DB/ARCHIVELOG/RESTORE2); do
-   asmcmd cp +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2/$i +DATAC1/TMPARCH/RESTORE2;
+   asmcmd cp +RECOC1/DB/ARCHIVELOG/RESTORE2/$i +DATAC1/TMPARCH/RESTORE2;
-   asmcmd rm +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2/$i;
+   asmcmd rm +RECOC1/DB/ARCHIVELOG/RESTORE2/$i;
 done
 </code>
@@ Line 936: / Line 951: @@
 </code>
+== Stop a running job ==
+<code sql>
+exec DBMS_SCHEDULER.STOP_JOB(job_name => 'OWNER.JOB_NAME',force => TRUE);
+</code>
+== Disable a job (once stopped) ==
+<code sql>
+exec DBMS_SCHEDULER.disable('OWNER.JOB_NAME');
+</code>
+==== Automatic Database Diagnostic Monitor (ADDM) ====
+The CONTROL_MANAGEMENT_PACK_ACCESS has three settings:
+NONE - Oracle Diagnostics Pack and Oracle Tuning Pack is disabled on the database server, is strongly discouraged by Oracle, but you must if you haven't purchased a license.
+DIAGNOSTIC - Oracle Diagnostics Pack is enabled on the database server
+DIAGNOSTIC+TUNING - Both Oracle Diagnostics Pack and Oracle Tuning Pack are enabled on the database server
+<code sql>
+/* Display current value */
+show parameter control_management_pack_access
+NAME                                 TYPE        VALUE
+------------------------------------ ----------- ------------------------------
+control_management_pack_access       string      DIAGNOSTIC+TUNING
+SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;
+  COUNT(*)
+----------
+<----
+/* Disable feature */
+alter system set control_management_pack_access='NONE';
+SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;
+  COUNT(*)
+----------
+<-----
+</code>
+The STATISTICS_LEVEL initialization parameter has been around for quite some time and determines the level of database and operating system statistics that will be collected. Setting this parameter to TYPICAL or ALL will enable automatic database diagnostic monitoring, which is what we want. The three valid values are as follows:
+TYPICAL - the default setting will collect all the major statistics that Oracle deems necessary for database self-management while providing the best overall performance. Typically, no pun intended, TYPICAL is usually adequate for most environments.
+ALL - in addition to the TYPICAL collections, ALL will collect additional statistics such as timed operating system (OS) statistics and plan execution statistics.
+BASIC - disables many of the important statistics and is highly discouraged.
+<code sql>
+show parameters STATISTICS_LEVEL;
+</code>
+====Clusterware Version/Patch Level====
+crsctl resides in //$GRID_HOME\bin// directory.
+==Active Version of Clusterware==
+Display the active version and the configured patch level of the Oracle Clusterware software running in the cluster.
+<code bash>
+$ crsctl query crs activeversion
+Oracle Clusterware active version on the cluster is [12.1.0.0.2]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [456789126].
+</code>
+==Patch Level of Clusterware==
+Display the patch level in the Grid home patch repository.
+The patch level corresponds to only the local node in which the command is executed.
+<code bash>
+$ crsctl query crs releasepatch
+Oracle Clusterware release patch level is [3180840333] and the complete list of patches is [13559647] on the local node.
+</code>
+==Oracle Clusterware Software Version==
+Display the version of the Oracle Clusterware software installed
+<code bash>
+$ crsctl query crs releaseversion
+Oracle High Availablity Services release version on the local node is [12.2.0.1.0]
+</code>
+==Check Patch Level of Clusterware on Specific Node==
+Display the configured patch level of the installed Oracle Clusterware.
+<code bash>
+$ crsctl query crs softwarepatch <node_name>
+Oracle Clusterware patch level on node [node1] is [456789126]
+</code>
+==Latest Running Version of Clusterware==
+Display latest version of the software that has been successfully started on the specified node.
+<code bash>
+$ crsctl query crs softwareversion <node_name>
+Oracle Clusterware version on node [node1] is [12.2.0.1.0]
+</code>
+==Verify a Patch is Installed==
+<code bash>
+$ <gihome>/grid/OPatch/opatch lsinventory -bugs_fixed | grep ^27463879
+</code>

Shaun's Wiki

User Tools

Site Tools

Differences

Page Tools