Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 10 May 2016

Query To check Locks on a Table

The relevant query is as follows:

Select object_id, session_id, oracle_username, os_user_name,
Process, locked_mode
From sys.v_$locked_object;

Select a.object_name, b.oracle_username
From all_objects a, v$locked_object b
Where a.object_id = b.object_id
And a.object_name like 'po%';
Share this article :

28 comments:

  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  2. This is my first time visit to your blog and I am very interested in the articles that you serve. Provide enough knowledge for me. Thank you for sharing useful and don't forget, keep sharing useful info: my balance now

    ReplyDelete
  3. locksmith near me Have you lost the keys to your lodge at the lake or failed to remember the mix to a protected at the workplace? Did you simply sever your vehicle key in the start? Possibly somebody took your tote, and you're worried that you need to change the locks at your home. Quit stressing. you can move help immediately from proficient locksmith.

    ReplyDelete
  4. Have you lost the keys to your lodge at the lake or failed to remember the mix to a protected at the workplace? Did you simply sever your vehicle key in the start? Perhaps somebody took your satchel, and you're worried that you need to change the locks at your home. Quit stressing. you can move help immediately from proficient locksmith.locksmiths
    .

    ReplyDelete
  5. These locks are ordinarily delivered using keys, keycards, RFID signals or keycodes. slotenservice-slotenmaker.nl

    ReplyDelete
  6. You should simply get on your telephone and dial locksmith North York one of the neighborhood 24-hour car locksmith administrations.

    ReplyDelete
  7. Cool stuff you have got and you keep update all of us. sos plombier bruxelles

    ReplyDelete
  8. Locksmiths can likewise introduce safes and vaults for your gems, mint piece assortment, the family silver, hides or whatever different resources you need to be careful. emergency Toronto locksmith

    ReplyDelete
  9. Quality and Versatility: There are numerous locksmith organizations that offer administrations redid to meet your necessities. locksmith near me

    ReplyDelete
  10. Nice to be visiting your blog once more, it has been months for me. Well this article that ive been waited for therefore long. i want this article to finish my assignment within the faculty, and it has same topic together with your article. Thanks, nice share. slab leak repair plano

    ReplyDelete
  11. VFIRE has been crazily popular among cannabis communities for years. By inheriting the ideas and adopt our fresh-baked technologies, we formally launch BLAZE, VFRIE’s little sister. Blaze will be the Best Pod System Fixes All Your Concerns. Read the full info here cannabis brand

    ReplyDelete
  12. I really like your writing style, great information, thankyou for posting. AC Repair Arvada, CO

    ReplyDelete
  13. Cilicon Elevate S2 is a great CBD THC vape cartridge, which Solve 99% of cartridge Leaking Problem,ensures your customers a solid and consistent vaping experience. For more information on 510 carts.

    ReplyDelete
  14. Sometimes you can detect these falsely "local locksmiths" as they may have multiple listings - sometimes over 30 listings in a single phone number. locksmith Madison heights

    ReplyDelete
  15. I am grateful for the blog article. Thanks Again. Want more.
    locksmith southfield

    ReplyDelete
  16. Amazon is one the largest multinational companies worldwide that contributes to technological advancements and makes people's lives easier. Amazon is not only the largest online retailer, but it has also been recognized as a leader in multinational technology around the world. Amazon offers a wide range of technological devices including the Echo Dot and Fire TV, as well as Cloud Cam, Kindle, Fire TV, Fire TV, and Fire TV. It also offers entertainment services such as Prime Video, Music Unlimited and Amazon Digital Game Store.Amazon code
    Appstore.com/redeem
    Play.google.com/redeem
    macy's gift card balance

    ReplyDelete
  17. Amazon Prime Video allows you to access media and entertainment faster and more efficiently. Amazon launched Prime Video to meet its users' expectations of unlimited movie and video selections, which can be accessed anywhere, anytime. Prime Video is available on many devices. To activate Prime Video on a specific device, however, you must register it.www.amazon.com/mytv. We have provided the steps to generate the activation Code and register your device on Amazon.com/mytv for Prime Video.
    Sephora gift card balance
    Apple gift card balance
    sephora gift card balance
    Best Buy Gift Card Balance

    ReplyDelete
  18. You can now generate the Prime Video verification code for your Roku TV by following the instructions in this write-up. You can also register your device viawww.amazon.com/mytv.The steps in the blog's procedures are simple. If you have any questions, please contact Amazon customer service.Mastercard gift card balance
    vanilla gift card balance
    Target.com/checkbalance

    ReplyDelete
  19. To verify the balance of your Lowe's Gift Card balance To check your balance, visit lowes.com/giftcards Call 1-800-560-7172, or visit Customer Service Desk at any Lowe's location. Find out more.
    lowes.com/giftcards

    ReplyDelete
  20. The best habit to watch Prime video on speaking your device is to register your device at www.amazon.com/mytv. This will allow you to view your Prime Video movies and shows at the time that suits you best. Amazon Prime Video can now be accessed on all eligible devices. Amazon.com/mytv has increased their list of eligible devices to meet the high demand from Prime video users. You must create an account to view Prime Video on your device.
    amazon com code
    amazon code
    Play.google.com/redeem
    amazon com code
    Prime video mytv

    ReplyDelete
  21. It includes numerous things like website data engineering, UI, website format, symbolism, textual styles and symbols plan, and route ergonomics. onohosting.com/

    ReplyDelete
  22. What would you do if ever we were given a special time together? Masters Study

    ReplyDelete