TO FIND THE CURRENT SCN ======================== select current_scn from v$database; TO FIND THE SCN FROM TIMESTAMP =============================== select timestamp_to_scn(to_timestamp(’05-09-2018 12:46:21′,’dd-mm-yyyy hh24:mi:ss’)) scn from dual; TO FIND THE TIMESTAMP FROM SCN…
Read MoreHow to take Thread dump from weblogic administration console. Login in to the console Under Domain Structure Go to Environments Click on servers( It will display the list of servers)…
Read Moreset pages 1000 lines 1000 col column_name for a40 col index_name for a45 col column_expression for a40 set lines 120 pages 50000 select c.index_name, c.column_name “COLUMN_NAME”, c.column_position, a.column_expression from dba_ind_columns…
Read MoreIn a data recovery context, it is useful to be able to query the state of a table at a previous time. If, for instance, you discover that at 4:25…
Read Morecol sql format a35 col username format a20 col child format 999 col secs format 9999 col machine format a12 col event format a25 col state format a10 select /*+…
Read MoreThis query is to analyse the type of items that a customer is buying in specific period through out his orders. In the below example we have taken only the…
Read MoreThis is a simple SQL Query used to show how the pivot option is used. Here in this example the columns JAN, FEB and MAR would be having single quotes…
Read MoreEnvironment: Oracle OLAP – Version 11.2.0.3 and later Symptoms: OLAP is valid in dba_registry but the following OLAP objects are invalid: SQL> select owner,object_name,object_type from dba_objects where status=’INVALID’ order by…
Read MoreStop the application services. 2. Take backup of the context file 3. Run Autoconfig. 4. Start the Application services. 5. Evaluate the Instance is working as desired. CHANGED PARAMETERS…
Read More