Pages

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


Tuesday, November 9, 2021

ORACLE EBS R12.12

 ORACLE EBS R12.12


https://youtu.be/gV5tRxQ6Ibk


ALL FITNESS SKILLS

 ALL FITNESS SKILLS 


############# BODY FAT BELOW 10% ##########

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, September 18, 2021

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




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