An Oracle Spin by Alex Lima

Sharing Tips & Tricks from my Database Experience

Menu Skip to content
  • Home
  • GoldenGate
  • General DBA
  • Oracle White Papers
  • Disclosure
  • About

Tag: lock

May 13, 2012February 9, 2016 Alex Lima

Example shows how “DISABLE TABLE LOCK” works

October 4, 2010February 9, 2016 Alex Lima

List locks held by a session

April 4, 2010February 9, 2016 Alex Lima

Find locks on a table

March 20, 2010February 9, 2016 Alex Lima

How to find sessions that are blocked?

October 9, 2008January 23, 2017 Alex Lima

How to lock/unlock statistics on a table?

September 14, 2008January 23, 2017 Alex Lima

How to find DDL lock on objects?

Follow Me

  • Twitter
  • LinkedIn
  • YouTube

Categories

  • 18c (2)
  • 19c (4)
  • AIX (1)
  • Archivelog (3)
  • Auditing (2)
  • AWR (10)
  • Backup (4)
  • Backup & Recovery (35)
  • Batch (1)
  • Big Data (2)
  • Built-in stored procedures (1)
  • Connections (1)
  • Control file (3)
  • Cursor (3)
  • Database (12)
  • Dataguard (4)
  • Dataguard (3)
  • Datatypes (6)
  • Date (2)
  • Docker (1)
  • exp (2)
  • Export (6)
  • Flashback (5)
  • General DBA (275)
  • Globalization (6)
  • GoldenGate (32)
  • Grant (5)
  • Initialization (4)
  • install (2)
  • Internal (4)
  • JDBC (5)
  • Jobs (4)
  • Linux (1)
  • Listener (4)
  • LOB (2)
  • Lock (3)
  • Log Miner (1)
  • mac (2)
  • Microservices (16)
  • Monitor (1)
  • MySQL (2)
  • NetApp for Oracle (2)
  • OCI (2)
  • OEM – Grid Control (5)
  • OpenWorld 2010 (3)
  • ORA Errors (3)
  • Oracle RAC (4)
  • oradebug (9)
  • OS (2)
  • osql (1)
  • Parameters (8)
  • partition (1)
  • Password (3)
  • performance (1)
  • PL/SQL (5)
  • postgres (1)
  • Power Shell (2)
  • Primavera (3)
  • Profiler (1)
  • Project Management (3)
  • REST API (4)
  • RMAN (36)
  • role (3)
  • Scheduler (9)
  • Scripts (26)
  • Security (7)
  • sga (4)
  • Shared Pool (3)
  • Shell (15)
  • snapshot (1)
  • SQL – DDL (5)
  • SQL Developer (3)
  • SQL Server (69)
  • SQL*Plus (18)
  • SQLcl (2)
  • startup (4)
  • Statistics (14)
  • Statspack (3)
  • Table (3)
  • tablespace (2)
  • trace (32)
  • Transaction (5)
  • Tuning (35)
  • Tuning (6)
  • Undo (1)
  • Unix (33)
  • Upgrade (1)
  • vi (5)
  • windows (9)

Follow Alex's Blog

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

Join 3,597 other subscribers

Twitter Updates

  • one person followed me and one person unfollowed me // automatically checked by fllwrs.com 17 hours ago
  • https://t.co/XsbS6zMeNp 23 hours ago
  • #marchmadness2023 https://t.co/oItRcYdHhH 23 hours ago
  • #FridayFeeling https://t.co/7urUgX4j6p 1 day ago
  • I don't think I can do this. @BMWMotorrad #bmwmotorrad #r1250gsa https://t.co/1aFiPa0vwt 1 day ago
Follow @aoflima

Recent Posts

  • Useful GoldenGate ACDR Views
  • Oracle GoldenGate 2023 Virtual Customer Summit
  • Oracle GoldenGate Advantages
  • GoldenGate Automation with REST API and Python
  • Where is the TNS_ADMIN in GoldenGate Microservices 21c?

Top Posts

  • How to find jobs currently running or history about the jobs?
  • How to see current utilization of processes/sessions and max utilization?
  • How to find the NLS_LANG to set for a database?
  • How to stop a job scheduled in DBMS_SCHEDULER?
  • How to delete archive logs already archived to backup device?
  • How to grant SELECT access to v$session to other users?
  • ALTER DATABASE BEGIN/END BACKUP
  • How to lock/unlock statistics on a table?
  • How to delete/reset a parameter in spfile using ALTER SYSTEM?
  • How to pass host, port, SID/Service name to connect to a database?
Powered by WordPress.com.
 

Loading Comments...
 

You must be logged in to post a comment.