Archive Daily Archives: January 22, 2008
Performance – Transfering Stats 11i
Source: Oracle Documentations It is possible to transfer statistics between servers allowing consistent execution plans between servers with varying amounts of data. First the statistics must be collected into a statistics table. In the following examples the statistics for the APPSCHEMA user are collected into a new table, STATS_TABLE, which is owned by DBASCHEMA: SQL> […]
Read MoreCollection of Queries/Scripts
1)How to check if the partitions of a table are set to LOGGING select partition_name, logging from dba_tab_partitions where table_name=’WF_LOCAL_ROLES’; 2)How to Correct Session Cookie Name. a)select session_cookie_name from icx_parameters; b)update icx_parameters set session_cookie_name = ‘<hostname_sid>’; c)select session_cookie_name from icx_parameters; 3) How to find database SID from a Concurrent request. column process heading “FNDLIBR PID” […]
Read More