Results 1 to 14 of 14

Thread: u01 space issue

  1. #1
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2

    Unanswered: u01 space issue

    Hi,

    We assigned 150 GB to /u01. since few weeks we noticed its filling very fast.
    df -h shows available 3.2gb...i clean up the logs alerts and dumps. then it will came back to 15gb. but i am not sure what is root cause....

    oracle 11gr2 enterprize edition....with linux6 version....

    i am planning to use the ADRCI but not sure about the licensing. please suggest...

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Do you backup your archivelogs?

  3. #3
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    yes we do but we have separate file system for that...

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    do you have a few BIG files or many small files?

    do any tempfiles, REDO, or UNDO have AUTOEXTEND enabled?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    yes the AUTO EXTEND IS ON... yes we do have some two large file systems.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >yes the AUTO EXTEND IS ON...
    so you now suffer the consequence for enabling AUTOEXTEND.
    Oracle never voluntarily returns disk space to the OS once it has acquired it.

    post results of SQL below
    Code:
    SELECT tablespace_name, 
           AUTOEXTENSIBLE,
           Round(SUM(bytes / ( 1024 * 1024 ))) SIZE_IN_MB 
    FROM   dba_data_files 
    GROUP  BY tablespace_name , AUTOEXTENSIBLE
    ORDER  BY 3 DESC;
    Last edited by anacedent; 06-10-14 at 14:09.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    i found that its generating lot of traces which is filling the space really fast.
    is there a way to find out the what our trace level is set at and, whether or not that is a node setting or a cluster/rac-wide setting. Please suggest..thanks

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    without knowing the actual content of the trace files I can't begin to guess the source.

    in what directory are these trace files found?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    this is the directory....i am surprise to see the
    /u01/app/oracle/diag/rdbms/comdb/comdb1/trace

    [oracle@rac1 trace]$ du -sh
    19G

    and it has the traces which is more than 2.4gb....and its all udumps which is writing long traces....Please advise... any thing related to the trace level setting ....

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post results of following OS command

    ls -ltr /u01/app/oracle/diag/rdbms/comdb/comdb1/trace/ | tail -20
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  11. #11
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    -rw-r----- 1 oracle asmadmin 50M Jun 11 08:25 comdb1_ora_15375.trm
    -rw-r----- 1 oracle asmadmin 121M Jun 11 08:25 comdb1_ora_15375.trc
    -rw-r----- 1 oracle asmadmin 184M Jun 11 08:44 comdb1_ora_7373.trm
    -rw-r----- 1 oracle asmadmin 448M Jun 11 08:44 comdb1_ora_7373.trc
    -rw-r----- 1 oracle asmadmin 94M Jun 11 09:06 comdb1_ora_28204.trm
    -rw-r----- 1 oracle asmadmin 229M Jun 11 09:06 comdb1_ora_28204.trc
    -rw-r----- 1 oracle asmadmin 234M Jun 11 09:11 comdb1_ora_30786.trm
    -rw-r----- 1 oracle asmadmin 569M Jun 11 09:11 comdb1_ora_30786.trc
    -rw-r----- 1 oracle asmadmin 96M Jun 11 09:29 comdb1_ora_20924.trm
    -rw-r----- 1 oracle asmadmin 233M Jun 11 09:29 comdb1_ora_20924.trc
    -rw-r----- 1 oracle asmadmin 186 Jun 11 09:37 comdb1_dia0_7795.trm
    -rw-r----- 1 oracle asmadmin 2.6K Jun 11 09:37 comdb1_dia0_7795.trc
    -rw-r----- 1 oracle asmadmin 192M Jun 11 09:53 comdb1_ora_6888.trm
    -rw-r----- 1 oracle asmadmin 467M Jun 11 09:53 comdb1_ora_6888.trc
    -rw-r----- 1 oracle asmadmin 96M Jun 11 09:54 comdb1_ora_3192.trm
    -rw-r----- 1 oracle asmadmin 234M Jun 11 09:54 comdb1_ora_3192.trc
    -rw-r----- 1 oracle asmadmin 383M Jun 11 10:05 comdb1_ora_28202.trm
    -rw-r----- 1 oracle asmadmin 933M Jun 11 10:05 comdb1_ora_28202.trc
    -rw-r----- 1 oracle asmadmin 97M Jun 11 10:14 comdb1_ora_27545.trm
    -rw-r----- 1 oracle asmadmin 235M Jun 11 10:14 comdb1_ora_27545.trc
    -rw-r----- 1 oracle asmadmin 193M Jun 11 10:21 comdb1_ora_10732.trm
    -rw-r----- 1 oracle asmadmin 471M Jun 11 10:21 comdb1_ora_10732.trc
    -rw-r----- 1 oracle asmadmin 388M Jun 11 10:46 comdb1_ora_17833.trm
    -rw-r----- 1 oracle asmadmin 945M Jun 11 10:46 comdb1_ora_17833.trc
    -rw-r----- 1 oracle asmadmin 972M Jun 11 11:06 comdb1_ora_27547.trm
    -rw-r----- 1 oracle asmadmin 2.4G Jun 11 11:06 comdb1_ora_27547.trc
    -rw-r----- 1 oracle asmadmin 98M Jun 11 11:08 comdb1_ora_539.trm
    -rw-r----- 1 oracle asmadmin 239M Jun 11 11:08 comdb1_ora_539.trc
    -rw-r----- 1 oracle asmadmin 585M Jun 11 11:32 comdb1_ora_10737.trm
    -rw-r----- 1 oracle asmadmin 1.4G Jun 11 11:32 comdb1_ora_10737.trc
    -rw-r----- 1 oracle asmadmin 197M Jun 11 11:33 comdb1_ora_7428.trm
    -rw-r----- 1 oracle asmadmin 479M Jun 11 11:33 comdb1_ora_7428.trc
    -rw-r----- 1 oracle asmadmin 99M Jun 11 11:53 comdb1_ora_14294.trm
    -rw-r----- 1 oracle asmadmin 240M Jun 11 11:53 comdb1_ora_14294.trc
    -rw-r----- 1 oracle asmadmin 100M Jun 11 11:56 comdb1_ora_19959.trm
    -rw-r----- 1 oracle asmadmin 243M Jun 11 11:56 comdb1_ora_19959.trc
    -rw-r----- 1 oracle asmadmin 200M Jun 11 12:11 comdb1_ora_23081.trm
    -rw-r----- 1 oracle asmadmin 486M Jun 11 12:11 comdb1_ora_23081.trc
    -rw-r----- 1 oracle asmadmin 105M Jun 11 13:30 comdb1_ora_22242.trm
    -rw-r----- 1 oracle asmadmin 255M Jun 11 13:30 comdb1_ora_22242.trc
    -rw-r----- 1 oracle asmadmin 106M Jun 11 13:58 comdb1_ora_11820.trm
    -rw-r----- 1 oracle asmadmin 257M Jun 11 13:58 comdb1_ora_11820.trc



    and today
    -rw-r----- 1 oracle asmadmin 105K Jun 13 14:05 comdb1_lms0_7822.trc
    -rw-r----- 1 oracle asmadmin 88K Jun 13 14:05 comdb1_lmon_7801.trm
    -rw-r----- 1 oracle asmadmin 182K Jun 13 14:05 comdb1_lmon_7801.trc
    -rw-r----- 1 oracle asmadmin 2.4M Jun 13 14:07 alert_comdb1.log
    -rw-r----- 1 oracle asmadmin 12K Jun 13 14:08 comdb1_lgwr_7867.trm
    -rw-r----- 1 oracle asmadmin 86K Jun 13 14:08 comdb1_lgwr_7867.trc
    -rw-r----- 1 oracle asmadmin 11K Jun 13 14:14 comdb1_mmon_7889.trm
    -rw-r----- 1 oracle asmadmin 103K Jun 13 14:14 comdb1_mmon_7889.trc
    -rw-r----- 1 oracle asmadmin 62K Jun 13 14:15 comdb1_smon_7875.trm
    -rw-r----- 1 oracle asmadmin 547K Jun 13 14:15 comdb1_smon_7875.trc
    -rw-r----- 1 oracle asmadmin 41K Jun 13 14:16 comdb1_diag_7771.trm
    -rw-r----- 1 oracle asmadmin 296K Jun 13 14:16 comdb1_diag_7771.trc
    -rw-r----- 1 oracle asmadmin 1.9K Jun 13 14:17 comdb1_ora_2016.trm
    -rw-r----- 1 oracle asmadmin 12K Jun 13 14:17 comdb1_ora_2016.trc
    -rw-r----- 1 oracle asmadmin 93K Jun 13 14:17 comdb1_lmd0_7811.trm
    -rw-r----- 1 oracle asmadmin 458K Jun 13 14:17 comdb1_lmd0_7811.trc
    -rw-r----- 1 oracle asmadmin 141K Jun 13 14:17 comdb1_lck0_8079.trm
    -rw-r----- 1 oracle asmadmin 1014K Jun 13 14:17 comdb1_lck0_8079.trc
    -rw-r----- 1 oracle asmadmin 2.5K Jun 13 14:17 comdb1_ora_20470.trm
    -rw-r----- 1 oracle asmadmin 14K Jun 13 14:17 comdb1_ora_20470.trc

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post results from following OS command

    head -128 /u01/app/oracle/diag/rdbms/comdb/comdb1/trace/comdb1_ora_20470.trc
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  13. #13
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    Trace file /u01/app/oracle/diag/rdbms/comdb/comdb1/trace/comdb1_ora_20470.trc
    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    ORACLE_HOME = /u01/app/oracle/product/11.2.0.2/dbhome_1
    System name: Linux
    Node name: oracle.com
    Release: 2.6.18-128.el5
    Version: #1 SMP Wed Jan 21 08:45:05 EST 2009
    Machine: x86_64
    Instance name: comdb1
    Redo thread mounted by this instance: 1
    Oracle process number: 79
    Unix process pid: 20470, image: oracle@oracle.com


    *** 2014-06-10 13:54:58.750
    *** SESSION ID2364.6803) 2014-06-10 13:54:58.750
    *** CLIENT ID) 2014-06-10 13:54:58.750
    *** SERVICE NAMEoracle.com) 2014-06-10 13:54:58.750
    *** MODULE NAMEJDBC Thin Client) 2014-06-10 13:54:58.750
    *** ACTION NAME) 2014-06-10 13:54:58.750

    TTX id1: 1e000d id2: 16ab5b ret: 0 waitopt: 2

    *** 2014-06-10 13:55:08.805
    TTX id1: 12000d id2: 1b405b ret: 0 waitopt: 2

    *** 2014-06-10 14:06:28.881
    TTX id1: d0005 id2: 1b26a8 ret: 0 waitopt: 2

    *** 2014-06-10 14:08:22.353
    TTX id1: 110003 id2: 14927f ret: 0 waitopt: 2

    *** 2014-06-10 14:09:02.710
    TTX id1: 160018 id2: 1d7fdd ret: 0 waitopt: 2
    TTX id1: f0013 id2: 1b315f ret: 0 waitopt: 2

    *** 2014-06-10 14:13:00.092
    TTX id1: b0010 id2: 148da2 ret: 0 waitopt: 2

    *** 2014-06-10 14:16:15.725
    TTX id1: d0008 id2: 1b2671 ret: 0 waitopt: 2
    TTX id1: d000b id2: 1b25d2 ret: 0 waitopt: 2
    TTX id1: 130006 id2: 1b4c99 ret: 0 waitopt: 2

    *** 2014-06-10 14:50:56.792
    TTX id1: f0011 id2: 1b31c3 ret: 0 waitopt: 2

    *** 2014-06-10 14:54:12.025
    TTX id1: c0010 id2: 1b4e8d ret: 0 waitopt: 2

    *** 2014-06-10 14:55:55.823
    TTX id1: d0002 id2: 1b2592 ret: 0 waitopt: 2

    *** 2014-06-10 14:59:41.698
    TTX id1: c0013 id2: 1b4c3c ret: 0 waitopt: 2
    TTX id1: 130021 id2: 1b4d7c ret: 0 waitopt: 2

    *** 2014-06-10 15:03:49.684
    TTX id1: 110017 id2: 149260 ret: 0 waitopt: 2

    *** 2014-06-10 15:04:41.743
    TTX id1: 240008 id2: b7b8 ret: 0 waitopt: 2
    TTX id1: d000f id2: 1b271d ret: 0 waitopt: 2

    *** 2014-06-10 15:28:13.550
    TTX id1: f000b id2: 1b315d ret: 0 waitopt: 2

    *** 2014-06-10 15:28:44.822
    TTX id1: 140015 id2: 149309 ret: 0 waitopt: 2

    *** 2014-06-10 15:32:00.578
    TTX id1: 120010 id2: 1b4235 ret: 0 waitopt: 2
    TTX id1: c0015 id2: 1b4eac ret: 0 waitopt: 2
    TTX id1: c0018 id2: 1b4d8a ret: 0 waitopt: 2
    TTX id1: d0017 id2: 1b261b ret: 0 waitopt: 2
    TTX id1: f001f id2: 1b3156 ret: 0 waitopt: 2

    *** 2014-06-10 16:50:22.622
    TTX id1: 190007 id2: 1d8570 ret: 0 waitopt: 2

    *** 2014-06-10 16:50:32.714
    TTX id1: 160014 id2: 1d9af3 ret: 0 waitopt: 2
    TTX id1: c0019 id2: 1b4e0c ret: 0 waitopt: 2

    *** 2014-06-10 17:33:16.853
    TTX id1: 24001c id2: b7f2 ret: 0 waitopt: 2
    TTX id1: 10000f id2: 1b4c2a ret: 0 waitopt: 2
    TTX id1: 1d0017 id2: 1dbd98 ret: 0 waitopt: 2

    *** 2014-06-10 18:46:39.250
    TTX id1: 11001b id2: 1491b8 ret: 0 waitopt: 2

    *** 2014-06-10 18:46:59.384
    TTX id1: 1d0003 id2: 1dbb0f ret: 0 waitopt: 2
    TTX id1: 1b0001 id2: 169574 ret: 0 waitopt: 2

    *** 2014-06-10 19:02:19.992
    TTX id1: e0010 id2: 14990d ret: 0 waitopt: 2

    *** 2014-06-10 19:02:30.048
    TTX id1: b0011 id2: 148c09 ret: 0 waitopt: 2
    TTX id1: e0000 id2: 1499d1 ret: 0 waitopt: 2
    TTX id1: 24001f id2: b815 ret: 0 waitopt: 2
    TTX id1: f000a id2: 1b30fc ret: 0 waitopt: 2
    TTX id1: 140014 id2: 149227 ret: 0 waitopt: 2

    *** 2014-06-10 20:32:39.149
    TTX id1: f000f id2: 1b31b7 ret: 0 waitopt: 2

    *** 2014-06-10 20:32:59.343
    TTX id1: 130007 id2: 1b4d86 ret: 0 waitopt: 2

    *** 2014-06-10 20:33:40.778
    TTX id1: d000a id2: 1b2542 ret: 0 waitopt: 2
    TTX id1: 11001e id2: 14938c ret: 0 waitopt: 2
    TTX id1: 1a0014 id2: 1e4392 ret: 0 waitopt: 2
    TTX id1: 120000 id2: 1b41f9 ret: 0 waitopt: 2
    TTX id1: 240006 id2: b806 ret: 0 waitopt: 2
    TTX id1: 1a0018 id2: 1e40c2 ret: 0 waitopt: 2

    *** 2014-06-10 22:24:08.547
    TTX id1: 1c0021 id2: 1d8543 ret: 0 waitopt: 2
    TTX id1: 17000e id2: 1e4fd0 ret: 0 waitopt: 2

    *** 2014-06-10 22:31:38.302
    TTX id1: 170017 id2: 1e589d ret: 0 waitopt: 2

  14. #14
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Changes
    This problem has been introduced with patch-set 11.2.0.2.
    Cause
    Unnecessary trace has been added into the 11.2.0.2.
    This is Bug 9943960 (not public on My Oracle Support).
    Solution
    Bug has been fixed on RDBMS patchset 11.2.0.3 and release 12.1.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •