Difference between revisions of "Oracle"

@@ Line 1: / Line 1: @@
+=DBA=
+* [[Datafile operations]]
+* [[Alter logfiles]]
+* [[RAC 12c installation on OEL]]
+* [[RAC commands sheet]]
 =DBA / Tuning=
-==Index monitoring==
+* [[List connected sessions]]
-Enable monitoring:
+* [[Index Monitoring]]
-<source lang="sql">
+* [[Index Maintenance]]
-select 'alter index ' || owner || '.' || index_name || ' monitoring usage;'
+* [[Optimized reads]]
-  from dba_indexes
+* [[ExpDP / ImpDP]]
- where owner = '?'
+* [[Log Switching / Archive Logging]]
-   and index_type not in ('LOB');
+* [[Flash Cache]]
-</source>
+* [[Show temp tablespace usage]]
+* [[Reclaiming free space in datafiles]]
+* [[Transactions and undo related things]]
+* [[Oracle Backup & Restore]]
+=DML=
+* [[Forall insert]]
-Verify, make sure to connect as the owner of the objects you are monitoring:
+=Various=
-<source lang="sql">
+* [[Run multiple tasks in parallel]]
-select *
-   from v$object_usage;
-</source>

Latest revision as of 11:59, 20 June 2016