12 Mart 2018 Pazartesi

Exadata Lab 3: HCC Performance

TABLE Compress Performance

[oracle@qr01dbadm01 labs]$ sqlplus sh/sh
SQL> set timing on
SQL> alter session force parallel dml;
Session altered.

SQL> alter session force parallel ddl;
Session altered.

SQL> create table mycust_query_low
  2  column store compress for query low
  3  nologging parallel 4
  4  as select * from mycustomers;
Table created.
Elapsed: 00:02:17.89

SQL> create table mycust_query_high
  2  column store compress for query high
  3  nologging parallel 4
  4  as select * from mycustomers;
Table created.
Elapsed: 00:00:28.45

SQL> create table mycust_archive_low
  2  column store compress for archive low
  3  nologging parallel 4
  4  as select * from mycustomers;
Table created.
Elapsed: 00:00:43.35

17 Şubat 2018 Cumartesi

Exadata Lab 2: How To Change FlashCache Mode - WriteTrought to WriteBack

1. First of all, we have to stop Cluster in All Database Node.
/u01/app/12.1.0.2/grid/bin/crsctl stop cluster -all
2. Execute commands in Cell Node
dcli -g mycells cellcli -e list cell attributes flashcachemode
dcli -g mycells cellcli -e alter flashcache all flush
dcli -g mycells cellcli -e drop flashcache ---> If not execute, data will be lost.
dcli -g mycells cellcli -e alter cell shutdown services cellsrv
dcli -g mycells cellcli -e alter cell flashcachemode=WriteThrough 

16 Şubat 2018 Cuma

Exadata Lab 1: How To Change FlashCache Mode - WriteBack to WriteTrought

WriteBack to WriteTrought

1. First of all, we have to stop Cluster in All Database Node.
/u01/app/12.1.0.2/grid/bin/crsctl stop cluster -all

2. Execute commands in Cell Node

dcli -g mycells cellcli -e list cell attributes flashcachemode

dcli -g mycells cellcli -e drop flashcache

dcli -g mycells cellcli -e alter cell flashcachemode=WriteBack

dcli -g mycells cellcli -e alter cell startup services cellsrv

dcli -g mycells cellcli -e list cell attributes flashcachemode

dcli -g mycells cellcli -e create  flashcache all

dcli -g mycells cellcli -e list metriccurrent FC_BY_DIRTY

28 Kasım 2017 Salı

Oracle 12c Lab 4 : Clone PDB From Remote CDB with DB Link


STEP 1: PDB Read Only

SQL> alter pluggable database PDBCDR close immediate; 
SQL> alter pluggable database PDBCDR open read only;