Oracle get explain plan Tips
Oracle Dataguard GAP Recovery Tips
Oracle 19c on Linux 8 Installation Tips
Oracle 19c on Linux 8 Installation Tips
Virtualbox Upgrade error Tips
There is the following error after the update virtualbox version and can NOT create network in virutualbox
VBoxNetAdpCtl: Error while adding new interface: failed to open /dev/vboxnetctl: No such file or directory.
Use the following command in command line.
sudo "/Library/Application Support/VirtualBox/LaunchDaemons/VirtualBoxStartup.sh" restart
sudo /Library/Application\ Support/VirtualBox/LaunchDaemons/VirtualBoxStartup.sh restart
Mac System Preferences/security&Privacy/General -> allow and restart!
Have a good work&life! 2021/07 via LinHong
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.
