Skip to content
orahow-logo
orahow
Oracle Database Articles & Cloud Tutorials
  • Home
  • Oracle DBA
  • AWS RDS
  • PostgreSQL
  • Aurora PostgreSQL
  • Contact Us

Category: Oracle Script

Find Redo Log Size / Switch Frequency / Location in Oracle

October 6, 2020 admin

Redo logs are the most crucial part of the Oracle database. As a part of tuning, you must check the…

Continue Reading →

Posted in: Oracle DBA, Oracle Script

Killing Hung RMAN Session in Oracle

May 30, 2019 admin

Kill the hung RMAN session if stuck in Oracle

Continue Reading →

Posted in: Oracle DBA, Oracle Script, RMAN

How to check RMAN log file and Backup status in Oracle

admin

It is very easy to monitor RMAN backup status and see the log file if you have redirected RMAN output…

Continue Reading →

Posted in: Oracle DBA, Oracle Script, RMAN

How to find long running queries in Oracle

May 24, 2019 admin

Sometime SQL queries takes long time to complete. You can check long running sessions using v$session_longops script which will show…

Continue Reading →

Posted in: Oracle DBA, Oracle Script

Steps to Run SQL Tuning Advisor Against Slow Running Queries in Oracle

April 10, 2019 admin

Tuning slow running query in Oracle is one of the most challenging tasks for the DBA. When you run SQL…

Continue Reading →

Posted in: Oracle DBA, Oracle Script

Checking Temporary Tablespace Usage in Oracle

December 24, 2018 admin

Temporary tablespaces often referred as Temp tablespace in Oracle are used for sorting operations and can grow huge in size.…

Continue Reading →

Posted in: Oracle DBA, Oracle Script

How to Identify SID Based on OS PID in Oracle

December 21, 2018 admin

In order to drill down database performance issue like top memory, I/O and CPU consumers, you need to check SID…

Continue Reading →

Posted in: Oracle DBA, Oracle Script

How to Shrink Temp Tablespace and Reclaim Unused Space in Oracle

December 20, 2018 admin

Over a period of time temporary tablespace grow in size and we must resize tempfile to overcome space issue. In…

Continue Reading →

Posted in: Oracle DBA, Oracle Script

How to shrink Datafiles and Reclaim unused Space in Oracle

December 19, 2018 admin

In this article we will discuss about shrinking datafiles to reclaim unused space in an Oracle database. Below are the…

Continue Reading →

Posted in: Oracle DBA, Oracle Script

Linux Shell Script for RMAN Archivelog Backup

December 16, 2018 admin

If you want to perform hot backup then your database must be in archivelog mode. Using below shell script you…

Continue Reading →

Posted in: Oracle DBA, Oracle Script, RMAN

Post navigation

Page 1 of 2
1 2 Next →

Categories

  • Aurora PostgreSQL (2)
  • AWS RDS (4)
  • DB2 Admin (3)
  • Exadata (1)
  • Linux Admin (15)
  • Middleware (5)
  • MYSQL DBA (8)
  • OHS (1)
  • Oracle Apps EBS (1)
  • Oracle DBA (112)
  • Oracle Script (17)
  • Oracle Script (2)
  • Patching (3)
  • PostgreSQL (16)
  • RAC (3)
  • RAC (3)
  • RDS Oracle (3)
  • RMAN (11)
  • Uncategorized (8)
  • Vertica DBA (3)
  • WebLogic (4)
  • Window Admin (1)

Archives

Get Latest Updates

Stats

  • 2,656,027 hits
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Categories

Aurora PostgreSQL AWS RDS DB2 Admin Exadata Linux Admin Middleware MYSQL DBA OHS Oracle Apps EBS Oracle DBA Oracle Script Oracle Script Patching PostgreSQL RAC RAC RDS Oracle RMAN Uncategorized Vertica DBA WebLogic Window Admin
Copyright © 2025 orahow