Advertisement

04.18.2008 at 02:26PM PDT, ID: 23335636
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
5.0

Growing TRC files in BDUMP Directory

Asked by nishex in Oracle 10.x, Oracle Database, PL / SQL

Tags: , ,

Within the last month trc files in the Oracle bdump directory have been growing like crazy. Each of them bear a size ranging from 3 Mb to 100 MB and everyday they seem to be taking up 800 mb to 1 gb space on the HDD. I believe this began about a month back. The HDD is going to fill up soon and this is very worrisome. How this began, I have no clue. A snipped of the log looks like this:

*** ACTION NAME:( ) 2008-04-18 11:35:13.502
*** MODULE NAME:( ) 2008-04-18 11:35:13.502
*** SERVICE NAME:(SYS$USERS) 2008-04-18 11:35:13.502
*** SESSION ID:(124.4633) 2008-04-18 11:35:13.502
oer 8102.2 - obj# 203, rdba: 0x0040dff2(afn 1, blk# 57330)
kdk key 8102.2:
  ncol: 2, len: 15
  key: (15):  07 78 6c 03 0f 0d 01 12 06 00 40 05 c2 00 02
  mask: (2048):
 01 81 83 c4 0c dd d2 75 03 50 ea 47 08 78 f2 cc 0c e8 86 c4 0c d8 38 f1 4c
 14 84 c4 0c 42 d2 75 03 68 3c d2 0c 68 3c d2 0c ac 86 c4 0c a8 9a c4 0c d8
 38 f1 4c 68 3c d2 0c da c9 5d 03 78 f2 cc 0c 74 68 e9 0c d8 38 f1 4c a8 9a
 c4 0c 68 3c d2 0c 58 85 c4 0c d4 e5 5b 03 50 ea 47 08 68 3c d2 00 ac 86 c4
 0c a8 9a c4 0c 00 00 00 00 d8 38 f1 4c d8 38 f1 4c 74 68 e9 0c 84 1d 4f 4f
 28 c4 c4 0c 00 00 00 00 fc 85 c4 0c e8 86 c4 0c 74 68 e9 0c 68 3c d2 0c 50
 ea 47 08 d8 38 f1 4c f5 38 f1 4c bc 99 e7 0c 28 84 c4 0c ac 99 e7 0c 68 85
 c4 0c d0 d8 76 03 68 a3 82 03 e8 99 e7 0c 50 ea 47 08 ac 99 e7 0c 78 85 c4
 0c ff 2c 5f 03 50 ea 47 08 00 00 00 00 44 3a f1 4c e8 99 e7 0c ac 99 e7 0c
 00 00 00 00 7c 88 c4 0c 50 ea 47 08 6c 28 d5 50 ec 8a 02 00 00 00 00 00 01
 00 00 00 00 00 00 00 e8 99 e7 0c 00 00 00 00 70 51 3b 50 6c 28 d5 50 ec 8a
 02 00 00 00 00 00 01 00 00  ............................................................................

--------------------- Binary Stack Dump ---------------------
 
========== FRAME [1] (_ksedmp+524 -> _ksedst+0) ==========
Dump of memory from 0x0CC45C58 to 0x0CC45CEC
CC45C50                   0CC45CEC 00856341          [.\..Ac..]
CC45C60 00000000 0CC45E20 0040DFF2 00000000  [.... ^....@.....]
CC45C70 00000000 0847E608 00000000 00000000  [......G.........]
CC45C80 00000000 00000000 00000000 00000000  [................]
        Repeat 1 times
CC45CA0 033F1028 F33BB47C 00000000 00000000  [(.?.|.;.........]
CC45CB0 00000001 FFFFFF00 00000001 00000000  [................]
CC45CC0 0040DFF2 0CC45E20 00000001 00000000  [..@. ^..........]
CC45CD0 00000001 0CC45C64 0CC45CF0 0CC46E30  [....d\...\..0n..]
CC45CE0 01C98FE0 033E70CC FFFFFFFF           [.....p>.....]    
========== FRAME [2] (_kdiknf.78+407 -> _ksedmp+0) ==========
Dump of memory from 0x0CC45CEC to 0x0CC45DC4
CC45CE0                            0CC45DC4              [.]..]
CC45CF0 00A1DA70 00000003 033F28A0 0CC483C3  [p........(?.....]
CC45D00 00000800 03412B00 0CE73A1C 0000000F  [.....+A..:......]
CC45D10 03412B0C 03412B14 00000002 0000000F  [.+A..+A.........]
CC45D20 03412B2C 0CC45D38 033F28A0 03412B3C  [,+A.8]...(?.<+A.]
CC45D30 00000001 0000DFF2 32303138 0000322E  [........8102.2..]
CC45D40 0CC45DD4 00697B7E 0847EA50 0CCD1858  [.]..~{i.P.G.X...]
CC45D50 3FBDE086 0CCD3840 00000012 00000002  [...?@8..........]
CC45D60 00000000 0847E608 0CCD1858 3FBDE05C  [......G.X...\..?]
CC45D70 3FBDE074 3FBDE086 00001F88 3FBDFFFC  [t..?...?.......?]
CC45D80 00000003 00000149 3EB1DF92 3EB1DF8D  [....I......>...>]
............................................................................................................


KSTDUMP: End of in-memory trace dump
Dump event group for level SESSION
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life
Dump event group for level SYSTEM
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life
*** 2008-04-18 11:38:58.856
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 203, file 1, block 57330 (2)
ORA-12012: error on auto execute of job 26
ORA-08102: index key not found, obj# 203, file 1, block 57330 (2)


The end of the log (above) is consistent among all trace files.

The names of these logs are like SID_j000_1112.trc or SID_j001_XXXX.trc.

Any help would be greatly appreciated.

Thank you.



Start Free Trial
[+][-]04.18.2008 at 02:35PM PDT, ID: 21389829

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 02:44PM PDT, ID: 21389883

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 02:45PM PDT, ID: 21389887

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 02:56PM PDT, ID: 21389943

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 03:48PM PDT, ID: 21390201

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 04:12PM PDT, ID: 21390295

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 04:23PM PDT, ID: 21390335

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.18.2008 at 04:34PM PDT, ID: 21390377

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.19.2008 at 07:26AM PDT, ID: 21392685

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.21.2008 at 10:19AM PDT, ID: 21403972

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.21.2008 at 10:50AM PDT, ID: 21404284

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 12:50PM PDT, ID: 21424619

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 01:18PM PDT, ID: 21424900

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 01:41PM PDT, ID: 21425128

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 02:22PM PDT, ID: 21425554

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.27.2008 at 08:40AM PDT, ID: 21652813

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.27.2008 at 12:57PM PDT, ID: 21655112

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.27.2008 at 01:07PM PDT, ID: 21655211

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.07.2008 at 09:55AM PDT, ID: 21736129

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.08.2008 at 10:46AM PDT, ID: 21739009

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.09.2008 at 08:46AM PDT, ID: 21744127

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.09.2008 at 08:57AM PDT, ID: 21744223

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.10.2008 at 03:19PM PDT, ID: 21755576

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.14.2008 at 11:54AM PDT, ID: 22000883

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Oracle Database, PL / SQL
Tags: Oracle, 10g, 10.1.0.2.0
Sign Up Now!
Solution Provided By: nishex
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628