oracle12cTag Archive

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… Continue Reading AWR report analysis in 12c depth-part 1

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… Continue Reading Troubleshoot connection issue using standalone jdbc driver to oracle

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… Continue Reading Restore Database with PDB PITR Oracle 12c