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.