Query to check hidden parameters in oracle December 31, 2021 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 Reference key with Table name & column December 29, 2021 12c constraints database dba oracle +
Query to find out specific Segment growth from Datafile December 23, 2021 12c database datafile growth oracle segment segment growth +
Query to get the IP Adress of connected User in Oracle November 01, 2021 11g 12c database oracle user +
Query to fetch DDL for User including Privileges and Roles Using dbms_metadata.get_ddl October 22, 2021 11g 12c database ddl.role system user +
Query to Compile_dependent_objects in Oracle September 18, 2021 11g 12c compile database dba invalid objects oracle +