Oracle Index - Statics Tips
Oracle Index - invisible Tips
Oracle sqlplus plugin rlwrap install Tips
Windows 10 Enable Hyper-V Tips
Oracle Create PDB Tips
Using nologging to reduce the time of creating pdb.
21:48:29 SYS@PRODCDB> @1.sql
21:48:30 SYS@PRODCDB> create pluggable database pdbprod3 from pdbprod1 file_name_convert=('PDBPROD1','PDBPROD3') nologging;
Pluggable database created.
21:49:00 SYS@PRODCDB>
21:49:18 SYS@PRODCDB> @2.sql
21:49:18 SYS@PRODCDB> create pluggable database pdbprod6 from pdbprod1 file_name_convert=('PDBPROD1','PDBPROD6');
Pluggable database created.
21:50:02 SYS@PRODCDB>
nologging: 30 seconds
logging : 34 seconds
Create Pluggable database PDB Tips
Administrator's Guide
--> 38 Creating and Removing PDBs with SQL*Plus
--> Creating a PDB by Cloning an Existing PDB or Non-CDB
--> Cloning a Local PDB
Oracle Exadata Startup Shutdown Tips
Shutdown and Startup Exadata
Oracle AWR Exadata Alert Tips
There is Critial alert in AWR report like the following.
Linux network issue Tips
Problems:
Restart Linux 6 in vmware and met “Device eth0 does not seem to be present” for network service.
(All were good for using in another PC, just move to new PC and can NOT use the vm’s network service.)
service network restart
Shutting down loopback insterface: [ OK ]
Bringing up loopback insterface: [ OK ]
Bringing up interface eth0: Device eth0 does not seem to be present,delaying initialization. [FAILED]
Oracle Datapump lob table Tips
Disable and Enable all Constraint
Postgresql Primary Key CONSTRAINT Study 010 Tips
Postgresql CONSTRAINT Study 009 Tips