Friday, November 26, 2021

DB ORACLE DB UPGRADE

 DB ORACLE DB UPGRADE



WATCH COUNT:    /100

LIST COUNT :       /100



################################### WATCHED VIDEOS ########################################


********************************** AWR REPORTS 




################################### LISTED VIDEOS ########################################



********************************** AWR REPORTS   




Thursday, November 25, 2021

DB ORACLE INMEMORY

 DB ORACLE DB VERSION FEATURES



WATCH COUNT:    /100

LIST COUNT :       /100





################################### WATCHED VIDEOS ########################################


********************************** INMEMORY




################################### LISTED VIDEOS ########################################



********************************** INMEMORY  




Oracle Database 12c demos: In-Memory Column Store Architecture Overview


https://www.youtube.com/watch?v=fMW2-TDheec



What is In-Memory Database and how In-Memory DB is different from Normal DB in Hindi By - Amit Goyal


https://www.youtube.com/watch?v=KzC8eohfvM8





DataBase - Difference between In-Memory Database, Normal DataBase & Caching | In Memory Database #2


https://www.youtube.com/watch?v=4pW_DUimJV0





Database In-Memory and Indexes


https://www.youtube.com/watch?v=xM94-DQDRYg



DB ORACLE DB VERSION FEATURES

 DB ORACLE DB VERSION FEATURES



WATCH COUNT:    /100

LIST COUNT :       /100





################################### WATCHED VIDEOS ########################################


********************************** 19c REPORTS   


Oracle 19c New Features


https://www.youtube.com/watch?v=5kWuqgCLbW8&t=1s



################################### LISTED VIDEOS ########################################



********************************** 19c REPORTS   









Release and Features Oracle Database 12c, 18c, 19c


https://www.youtube.com/watch?v=tDOdR96odG8&t=2s





********************************** OTHER DIFFFS




Oracle New Features for developers | ORACLE LISTAGG function from oracle 11g to 19c


https://www.youtube.com/watch?v=_mZ-22SePH0


Monday, November 8, 2021

DB PL/SQL

 

DB PL/SQL



PL SQL Tutorial | Oracle PL SQL Tutorial For Beginner | PL SQL Training | Intellipaat

https://www.youtube.com/watch?v=9dNFCgpAGfI&t=1s


Oracle - Pl/SQL - Introduction


https://www.youtube.com/watch?v=J5wjIf4gdq4&list=PLWPirh4EWFpHj0kKqqYudPNOrGEa0fFIr



1. What is Database

https://www.youtube.com/watch?v=-LGYPtidSmw&list=PLB5DA82419C2D99B6



/SQL tutorial 1: PL/SQL Block Types in Oracle Database By Manish Sharma

https://www.youtube.com/watch?v=rbarR4_gaH8&list=PLL_LQvNX4xKyiExzq9GKwORoH6nvaRnOQ



rning PL/SQL programming

https://www.youtube.com/watch?v=xofpqdU3cD4&t=137s

Friday, October 22, 2021

FOR TO TAKE ANY INTERVIEW

 FOR TO TAKE ANY INTERVIEW


---DB Performance Tunning

https://mindmajix.com/oracle-performance-tuning-interview-questions


---DB Standby

https://www.wisdomjobs.com/e-university/oracle-data-guard-interview-questions.html


---DB Rman Backup & Recovery

https://ora-data.blogspot.com/2018/04/oracle-rman-interview-questions-and-answers.html


---DB patching

http://dbagalaxy.blogspot.com/2014/02/oracle-patchingcloning-upgrade-oracle.html


---DB Version Diff



---DB Clonning



---DB Critical Senarios



---DB Architecture



---DB ASM



---DB 

Saturday, August 28, 2021

APPS JD AND SKILLS

 APPS JD AND SKILLS

#####################################START ##############################


Oracle apps DBA for our client "Vigilant Technologies"

Location :Remote
Mode: Permanent
Experience: 8+ Yr
NP:Less than 30 Days
Rotational Shift

  • We are looking for EBS 12.2 /12.1.3 support and upgrade
  • Database 12c/19 c multitenancy support/upgrade
  • Some knowledge on SOA/ Middleware components
  • CLouD is an added advantage.
**************************


·        Proficient in installation, configuration, & administration of Oracle E-business Suite R12.1.3/R12.2.x environments.

 

·        Expertise in:

o   Installation, upgrading and administration of Oracle EBS R12.1/R12.2 env’s.

o   Patching and Cloning of EBS/Database env’s.

o   ADOP and online patching, analyzing/resolving patching issues.

o   Managing and Supporting Oracle EBS 12.1.x/12.2.x multitier env’s.

o   Debugging EBS/Database Performance issues and tuning skills.

o   Load balancing of application tier and setting up parallel concurrent processing.

o   Oracle 12c, 19c Database administration.

o   Upgrading Oracle Database to 12c/19c versions.

o   Multitenant architecture. Container and Pluggable database administration and cloning.

o   Configuration, Managing & Supporting Oracle RAC databases.

o   Installation, Setup & Managing Oracle ASM.

o   Oracle Data Guard, RMAN.

o   Setting up DR environment and supporting periodic DR drills.

o   Working with Oracle Support.

 

·        Good working knowledge in:

o   Oracle Enterprise Manager 12c/13c installation, configuration & administration.

o   Oracle WebLogic Server Administration.

o   TLS/SSL setup, TDE setup.

o   Linux/Unix flavors.

o   Shell, SQL, pl/sql scripting skills will be an added advantage.

o   Middleware WebLogic, Apex, SOA, OBIEE/OBIA will be an added advantage.

o   Installation, configuration and supporting OID/OAM will be an added advantage.

 

·        Work as part of a team and provide 24x7 support.

·        Knowledge on Exadata and ODA will be an added advantage.

·        Knowledge on Oracle Cloud (like OCI, DBAAS) would be an added advantage.

·        Experience working in supporting multiclient environments.

·        Excellent written and verbal communication skills.



##################################### END ##############################



##################################### START ##############################

##################################### END ################################

##################################### START ##############################

##################################### END ###############################

##################################### START ##############################

##################################### END ################################

##################################### START ##############################

##################################### END ################################

##################################### START ##############################

##################################### END ################################

##################################### START ##############################

##################################### END ################################

##################################### START ##############################

##################################### END ################################

##################################### START ##############################

##################################### END ################################

##################################### START ##############################

##################################### END ################################

Monday, August 23, 2021

ORACLE SSO

 ORACLE SSO

https://www.youtube.com/watch?v=KUSwhIV29MQ


https://www.youtube.com/watch?v=udUeJsz4Z3k


https://www.youtube.com/watch?v=bCpxuO0wmC0


https://www.youtube.com/watch?v=3v3AJ38pKC4


https://www.youtube.com/watch?v=DFwCjebqovw


https://www.youtube.com/watch?v=kRGPKh3NgHU


https://www.youtube.com/watch?v=uH80ud5yKOs


https://www.youtube.com/watch?v=-3CKXn9P8lo




Thursday, August 19, 2021

ALL SKILLS DEVOLOPMENT PLATFORM

 

ALL SKILLS DEVOLOPMENT PLATFORM










ALL INVESTMENTS SKILLS DEVOLOPMENT PLATFORM

 ALL INVESTMENTS SKILLS DEVOLOPMENT PLATFORM

ALL IT SKILL YOUTUBE CHANNELS

ALL IT SKILL YOUTUBE CHANNELS







ORACLE PERFORMANCE TUNNING

 ORACLE PERFORMANCE TUNNING


WATCH COUNT:    5/100

LIST COUNT :       21/100





################################### WATCHED VIDEOS ########################################


********************************** AWR REPORTS 

AWR Report - Oracle

https://www.youtube.com/watch?v=mgWYtR5D1jU&t=1s

3/5


What is an AWR Report? - DBPerf Video 17


https://www.youtube.com/watch?v=0h_KcoxRUss&t=8s

2/5


What is ASH report and how is it different from AWR Report


https://www.youtube.com/watch?v=VdcHH2V1imo&t=643s

4/5


AWR, ADDM and ASH reports


https://www.youtube.com/watch?v=8Xc-Rjhr1fE&t=7s

3/5



Real Time – AWR Report Analysis


https://www.youtube.com/watch?v=gblbndO7kZs

4/5




################################### LISTED VIDEOS ########################################



********************************** AWR REPORTS   


AWR Report Analysis - How to Read AWR Report? Performance Tuning and Troubleshooting - PT 2


https://www.youtube.com/watch?v=DD30b7D9AKM&t=1439s






How to Read Oracle AWR Report | Oracle Automatic Workload Repository


https://www.youtube.com/watch?v=QPJL1fswbO4




AWR Report Analysis - How to read AWR Report - Oracle Performance Tuning


https://www.youtube.com/watch?v=tLoc7w3cO8A&t=64s





Oracle Performance Tuning - Oracle Enterprise Manager - Reading AWR Reports


https://www.youtube.com/watch?v=KwB6oZknWQo&t=2s



AWR analysis in detail


https://www.youtube.com/watch?v=-VXIFMyuT0k





Oracle database wait events - Oracle Database Performance Tuning tutorial


https://www.youtube.com/watch?v=CDOGByswsew&list=PLSxEgw5vjPxXtafBaWbZcvOF2N8neevFg




AWR Report Analysis - How to read AWR Report - Oracle Performance Tuning


https://www.youtube.com/watch?v=tLoc7w3cO8A&list=PLSxEgw5vjPxXtafBaWbZcvOF2N8neevFg&index=3




Real-World Performance - 19 - Architecture with an AWR Report


https://www.youtube.com/watch?v=2QggbUdNsfI



Analysis of a Couple AWR Reports - OTW2018


https://www.youtube.com/watch?v=xSXQ3EwU8t0&t=27s




Oracle Midlands #13: Interpreting AWR Reports - Franck Pachot


https://www.youtube.com/watch?v=P4WdxYVzgQk&t=8s



Real-World Performance - 19 - Architecture with an AWR Report


https://www.youtube.com/watch?v=2QggbUdNsfI







**************************** ASH REPORTS


ASH Report - How Different than AWR Report? How to Generate ASH Report? Read & Interpret ASH report


https://www.youtube.com/watch?v=Qf1A-58nnzs&t=1s


What is ASH report and how is it different from AWR Report


https://www.youtube.com/watch?v=VdcHH2V1imo







Oracle Database Performance Tuning for Admins and Architects


https://www.youtube.com/watch?v=6uXqH0f3aG4&t=2s



Troubleshooting a Complex Oracle Performance Issue


https://www.youtube.com/watch?v=hxy8sfrezYo