Oracle Database Administration

Hi all, Today i am going to write another one of mine analysis by using My oracle support site document. In one of our client's database, we are getting the following error message continuously. Alert log entry: Wed Jul 23 11:45:43 2014 Errors in file /home/oracle/app/oracle/diag/rdbms/db/db/trace/db_ora_14547.trc  (incident=149824): ORA-00600: internal error code, arguments: [7005], [0], [], [], [], [], [], [], [], [], [], [] SQL_TEXT involved in this error is  select iso_country_code  from countries  where (SDO_RELATE(geom,SDO_GEOMETRY(:"SYS_B_0",:"SYS_B_1"),:"SYS_B_2")=:"SYS_B_3") So one of our dba has reported like below after searching the document for the error. According to Doc ID 138935.1 The error occurred due to Bug 8770557 Description: ORA-600 [7005] from SQL with user defined selectivity function (eg: Text queries) Solution: The issue is fixed in 11.2.0.2, 12.1.0.1 But o...

Hi all, We have received a mail from customer to investigate above error reported in the database's alert log. Please find the details below. Can you please investigate below error against EBSPRD and let me know the next course of action? Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x24] [PC:0x2587EB9, kglIsOwnerVersionable()+123] [flags: 0x0, count: 1] Errors in file /sw/oraebs/EBSPRD/db/tech_st/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSPRD/trace/EBSPRD_ora_17713.trc  (incident=624688): ORA-07445 : exception encountered: core dump [kglIsOwnerVersionable()+123] [SIGSEGV] [ADDR:0x24] [PC:0x2587EB9] [Address not mapped to object] [] Incident details in: /sw/oraebs/EBSPRD/db/tech_st/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSPRD/incident/incdir_624688/EBSPRD_ora_17713_i624688.trc Non critical error ORA-48913 caught while writing to trace file "/sw/oraebs/EBSPRD/db/tech_st/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSP...

We received a mail from customer stating that - Heavy business activity today after 10AM and especially between 16:00 to 17:00 hrs where we see 47 archive log switch and 100GB archive generated today in today after 10AM. Using below sql query you can check in which interval more archive log generated in the database. col day for a12 set lines 1000 set pages 999 col "00" for a3 col "01" for a3 col "02" for a3 col "03" for a3 col "04" for a3 col "05" for a3 col "06" for a3 col "07" for a3 col "08" for a3 col "09" for a3 col "10" for a3 col "11" for a3 col "12" for a3 col "13" for a3 col "14" for a3 col "15" for a3 col "16" for a3 col "17" for a3 col "18" for a3 col "19" for a3 col "20" for a3 col "21" for a3 col "22" for a3 col ...