1.Let me create a test case : I will take different OS statistics and run time statistics to compare with AWR report generated after execution. Case A.About test case in lower CPU:- I will create a table first create table t (id number, sometext varchar2(50),my_date date) tablespace data; Now I will create a simple procedure to load bulk data create […]
Hi All Please download following file from Google drive and keep in unix directory say /home/oracle https://drive.google.com/open?id=0B8-3R318F39hQUJOcnVPMUdrNzg The files to be downloaded:- Please use ojdbc7.jar downloaded for 12c.For 11g,you can use ojdbc6.jar. Please provide execute permissions Now you can test connection using below:- [oracle@SBJ1ITESBDBV01 ~]$ sh sqlScript_new.sh 2017-10-26 09:45:53.0 Please note you may get following error if you use […]
1 Introduction The next document will describe the steps to restore database with CDB and PDB point in time using Data protector and RMAN. 2. Restore Database with PDB PITR using command prompt (Best/Preferred way) [oracle@orclbkp admin]$ rman target / Recovery Manager: Release 12.2.0.1.0 – Production on Mon Jun 26 21:32:29 2017 Copyright (c) 1982, 2017, Oracle and/or […]