Posts

Featured Post

Query to check hidden parameters in oracle

  col P_VALUE format a20 col P_NAME format a50 select n.ksppinm p_name, c.ksppstvl p_value from sys.x$ksppi n, sys.x$ksppcv c where n.indx=c.indx and lower(n.ksppinm) like lower('\_%') escape '\';

Query to find running procedure name with duration

Query to find Reference key with Table name & column

Query to find out specific Segment growth from Datafile

Query to check PGA memory usage

Query to get table object DDL with_table_index

Query to get the IP Adress of connected User in Oracle

Everythin Regarding Oracle Role

Query to extract DDL of oracle roles

Query to show all privileges for a oracle user

Query to fetch DDL for User including Privileges and Roles Using dbms_metadata.get_ddl

Query to Compile_dependent_objects in Oracle

Query to find Blocking Session History in Oracle