Oracle applications

oracle e-business suite [sql,plsql,ora-apps,reports,forms(oaf,adf)]

Labels

  • adf
  • apps
  • bip
  • EDI
  • oaf
  • OBIEE
  • ODI
  • pl\sql
  • Reports
  • Rtf
  • sql
  • URL's

Thursday, September 29, 2016

To find locks in Oracle Database

select * from dba_locks;

select * from dba_locks where blocking_others!='Not Blocking';
- September 29, 2016
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: sql

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Search This Blog

Developer,Oracle

Unknown
View my complete profile

Archive

  • ►  2018 (3)
    • ►  February (1)
    • ►  January (2)
  • ►  2017 (26)
    • ►  December (1)
    • ►  November (5)
    • ►  October (9)
    • ►  September (3)
    • ►  August (1)
    • ►  July (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (2)
  • ▼  2016 (94)
    • ►  December (5)
    • ►  November (11)
    • ►  October (7)
    • ▼  September (5)
      • To find locks in Oracle Database
      • Price list setup Query
      • Import Data from csv to DB Table through ADF page
      • Import Data from Excel sheet to DB Table through O...
      • URL's
    • ►  August (25)
    • ►  July (13)
    • ►  June (18)
    • ►  May (10)

New Posts

RANGE UNBOUNDED

  • Home

Report Abuse

My Blog List

Picture Window theme. Powered by Blogger.