SELECT Statement Selection : SQL statements are being used to returning the selected lines from related tables. Projection : SQL’s projection ability is being used to returning the selected columns …
Read More »Oracle
Oracle SQL Tutorials – Chapter 1 (Part 1 of 3)
CHAPTER 1 – INTRODUCTION TO SQL Explaining the capabilities of the SELECT statement Writing simple SELECT statements Select columns and aliases Arithmetic operators NULL value Union operator Usage of DISTINCT …
Read More »Oracle Kill Session Scripts -4 and gv$lock view
Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions, RMAN sessions or All sessions.
Read More »How to Solve resmgr:cpu quantum ( resource_manager_cpu_allocation ) Wait Event in Oracle 12c
You can see resmgr:cpu quantum ( resource_manager_cpu_allocation ) wait event in Performance page of Oracle Enterprise Manager Cloud Control 13c.
Read More »Restore Tablespace, Archivelog and Datafile via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -5
Hi, I will tell you about the RMAN (Recovery Manager) tool that we use frequently Backup and Restore operations in Oracle Databases in this fourth article of my tutorial series.
Read More »Restore Database & Recover Database with Set Until Time via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -4
Hi, I will tell you about the RMAN (Recovery Manager) tool that we use frequently Backup and Restore operations in Oracle Databases in this fourth article of my tutorial series.
Read More »Oracle 12c Client Step by Step Installation on Windows
I will explain the Oracle 12c Client Download & Installation on Windows in this post.
Read More »Restore Database and Recover database via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -3
Hi, I will tell you about the RMAN (Recovery Manager) tool that we use frequently Backup and Restore operations in Oracle Databases in this third article of my tutorial series.
Read More »Restore Controlfile and Spfile | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -2
Hi, I will tell you about the RMAN (Recovery Manager) tool that we use frequently Backup and Restore operations in Oracle Databases in this second article of my tutorial series.
Read More »Restore Validate via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -1
Hi, I will tell you about the RMAN (Recovery Manager) tool that we use frequently Backup and Restore operations in Oracle Databases in this first article of my tutorial series.
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial