1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Alternative for v$lock and V$Instance

Discussion in 'Server Administration and Options' started by Nirubama, Aug 5, 2012.

  1. Nirubama

    Nirubama Active Member

    Likes Received:
    Trophy Points:
    Is there any alternative for v$lock and V$Instance.

    I found below are the alternatives.

    Is v$Intance : select sys_context('USERENV','db_name') from dual;
    Is v$Lock : SYS.DBA_LOCK

    As our DBA is not recommending this , as this also requires Grant on select from sys.

    Please tell me a workaround for the views alternative that are not from sys.

    Is there any way of creating tables using our schema itself as an alternative and store data in it ?If so what would be the Columns and values.