• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle database
  • Oracle Ebusiness Suite
  • Oracle weblogic
  • Oracle Performance Tuning
  • Oracle Hyperion
  • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads

Database Useful scripts

27 oracle dba scripts for Oracle Database for Administration and Monitoring

July 2, 2022 by techgoeasy 2 Comments

We often need to monitor the oracle database session for performance reason, check for locks,get location of datafiles, redo files , get the information about db_links .Here are Top oracle dba scripts  for Oracle  Database for Administrative and Monitoring purpose Script to find the sid of the session you are logged in as select distinct(sid) […]

Filed Under: Oracle, Oracle Database Tagged With: Database Useful scripts, Top useful scripts for Monitoring Oracle Database

Latches and Mutex in Oracle database

August 21, 2021 by techgoeasy Leave a Comment

Introduction To Latch in Oracle Database Latches are low-level serialization mechanisms used to protect shared data structures in the Oracle SGA. The implementation of latches is operating system-dependent, particularly in regard to whether a process will wait for a latch and for how long. A latch is a type of lock that can be very […]

Filed Under: Oracle, Oracle Database Tagged With: Database Useful scripts, Latches

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to clone Oracle Home in 10g/11g/12c/19c/23c
  • How to find the FND_FILE output of the running concurrent request
  • srvctl commands in Oracle
  • Top SQL Patch Queries in Oracle Database
  • how to find if the sql is using the SQL Patch

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us