Database istatistik toplama

procedure;

CREATE OR REPLACE PROCEDURE SYS.gds IS

BEGIN

dbms_stats.gather_database_stats();


END gds;
/
----------------------------------
job;

BEGIN
SYS.DBMS_JOB.REMOVE(6);
COMMIT;
END;
/

DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'SYS.GDS;'
,next_date => to_date('23.12.2009 15:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+7)'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/

ORACLE HATALARI

- ORA-00600: internal error code, arguments: [2141], [147671159], [147633032], [], [], [], [], []
- Error: Controlfile was changed externally while mounted Please check if another Oracle database is running and accessing the same controlfile notes: ID 1035098.6

- ORA-19502: write error on file "/oracle/sid/oraarch/sidarch1_21018_644937590.dbf", blockno 32769 (blocksize=512)
ORA-27063: number of bytes read/written is incorrect
- IBM AIX RISC System/6000 Error: 28: No space left on device