Miscellanious


6 comments:

  1. Unknown14 October 2014 at 06:14

    Suppose you have installed 64 bit on Linux now you want 32 bit to be done then
    st1thas02n:/opt/oracle $
    vi install_32_bit_libs_only.sh
    cd /opt/oracle/oracle_base/product/11.2.0
    cp /mte/oraproj/oracle/software/Linux/install_files/lib32.tar.gz .
    gunzip lib32.tar.gz
    tar -xvf lib32.tar
    Now run the install_32_bit_libs_only.sh
    ./install_32_bit_libs_only.sh
    then
    cd $ORACLE_HOME/bin
    relink all
    change in your .profile
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib32
    thats it

    ReplyDelete
  2. Unknown14 October 2014 at 06:16

    This comment has been removed by the author.

    ReplyDelete
  3. Unknown14 October 2014 at 06:17

    To purge the SYSAUX


    exec dbms_stats.purge_stats(SYSDATE-10);



    SQL> select * from (select segment_name, bytes/1024/1024, segment_type from dba_segments where tablespace_name='SYSAUX' order by 2 desc) where rownum < 20;

    SEGMENT_NAME BYTES/1024/1024 SEGMENT_TYPE
    ---------------------------------------- --------------- ------------------
    WRM$_SNAPSHOT_DETAILS_INDEX 104 INDEX
    WRM$_SNAPSHOT_DETAILS 96 TABLE
    WRH$_SYSMETRIC_HISTORY 50 TABLE
    WRH$_SYSMETRIC_HISTORY_INDEX 39 INDEX
    I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST 25 INDEX
    WRH$_SYSMETRIC_SUMMARY 21 TABLE
    WRH$_RSRC_CONSUMER_GROUP 19 TABLE
    WRI$_OPTSTAT_HISTGRM_HISTORY 16 TABLE
    SMON_SCN_TO_TIME_AUX 14 CLUSTER
    I_WRI$_OPTSTAT_H_ST 12 INDEX
    SYS_LOB0000006306C00038$$ 11 LOBSEGMENT

    SEGMENT_NAME BYTES/1024/1024 SEGMENT_TYPE
    ---------------------------------------- --------------- ------------------
    WRH$_SQL_PLAN 10 TABLE
    WRH$_SYSMETRIC_SUMMARY_INDEX 9 INDEX
    WRH$_RSRC_CONSUMER_GROUP_PK 9 INDEX
    WRH$_ENQUEUE_STAT 8 TABLE
    SCHEDULER$_EVENT_LOG 7 TABLE
    WRI$_ADV_PARAMETERS_PK 7 INDEX
    WRH$_BG_EVENT_SUMMARY 6 TABLE
    WRH$_LATCH 6 TABLE PARTITION

    19 rows selected.



    alter table WRM$_SNAPSHOT_DETAILS move;
    alter table WRH$_SYSMETRIC_HISTORY move;
    alter table WRH$_SYSMETRIC_SUMMARY move;
    alter table WRH$_RSRC_CONSUMER_GROUP move;
    alter table WRI$_OPTSTAT_HISTGRM_HISTORY move;
    alter table WRH$_SQL_PLAN move;



    alter index WRM$_SNAPSHOT_DETAILS_INDEX rebuild online;
    alter index WRH$_RSRC_CONSUMER_GROUP_PK rebuild online;
    alter index WRH$_SYSMETRIC_SUMMARY_INDEX rebuild online;
    alter index WRH$_SYSMETRIC_HISTORY_INDEX rebuild online;
    alter index WRH$_SQL_PLAN_PK rebuild online;
    alter index I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST rebuild online;
    alter index I_WRI$_OPTSTAT_H_ST rebuild online;


    exec dbms_stats.alter_stats_history_retention(8);

    ReplyDelete
  4. Unknown14 October 2014 at 06:18

    Purge AUDIT table

    delete from sys.aud$ where sessionid in (select sessionid from dba_audit_trail where timestamp < sysdate - 90);
    commit;

    ReplyDelete
  5. Unknown14 October 2014 at 06:19

    Command To Kill defunc Process owned by Oracle

    ps -ef |grep defunct|grep -v grep |awk '{print "preap " $2}'


    ps -ef |grep defunct|grep oracle|wc -l


    xargs
    -exec {} \;

    ReplyDelete
  6. Unknown14 October 2014 at 12:18

    Hello Everyone.
    Can someone explain what is the drawback/use of defunc in oracle box/server,If it will be available/Not Available ?

    ReplyDelete

Subscribe to: Posts (Atom)