Customer got the following internal error message : ORA-600 [kdsgrp1] SQL> analyze table OPS$DWHPOPR_TEST.DWH_EURTABLE validate structure online; ERROR at line 1: ORA-01498: block check failure - see trace file.
Found out a scheduled export- and import job was broken. Error: ORA-31626: job does not exist. After checking the scheduled jobs I realized that it’s not the scheduled job, but the datapump-job. And it’s all related to being cost-effective in the cloud….
Remember the old days. You had just a few processes to watch. Something has changed along the way. A lot of processes should be running on your database system (with infrastructure), but how are they connected to eachother and what is the startup sequence ? Or.. what processes I can kill without any other proces starting it up... :-)
Since 184.108.40.206 there's a new parameter, "_datafile_write_errors_crash_instance" to prevent the intance to crash when a write error on a datafile occurs. But.. should I use this or not.
As the documentation about restoring an OCR did not work as it should be, hereby a method to do this.
After "alter table DWHINCIDENT.TEST_TABLE drop unused columns checkpoint 100000" And after a while: ERROR at line 1: ORA-00600: internal error code, arguments: , [0x12CB1C820], , , , Table in usable state. New bug !
Something about running statistics. Got quite a large database of a few TB, and was curious how fast the statistics are running, and if I could speed it up a little.
I had to install a 11g release 1 on Windows for demonstration purpose of APEX. APEX comes standard with 11g, so that's nice. When using Embedded PLSQL you don't even need Apache... But when I'm using http://localhost:8080/apex/apex_admin, the login-page popped up after a minute or two.And every page I use has the same horrible performance. Using the loopback by the way like http://127.0.0.1:8080/apex/apex_admin on the server gives the same result.
Working on 11g, release 1 (220.127.116.11), managers wanted to know what kind of compression factor we achieved in the datawarehouse. Amount of (compressed) data: just about 1,5 TB. In all my naivity I thought Oracle delivered the package 'DBMS_COMPRESSION' which will show me the rate of achieved compression per table. But first of all, in 11gr1 there was no package like 'DBMS_COMPRESSION', this is only delivered with release 2.
Apex, version 3.2.1.00.10, on a 10.2.0.3-database is working fine for some time. Then, while clicking the 'application builder' home-page, we got the 'page not found'-error in the browser. Logging of Apache shows: mod_plsql: /pls/apex_schd/f HTTP-404 ORA-03113: end-of-file on communication channel\n mod_plsql: Unable to reset state for mode 0: Err 3114 url=>/pls/apex_schd/f