How to Extend an Oracle TABLESPACE Extending an Oracle TABLESPACE is a crucial task in managing the storage of an Oracle database. TABLESPACE is the largest storage area within the database, where tables, indexes, and other database objects reside. During installation, five essential tablespaces are created to ensure the proper Read more…
With the article “Query REDO LOG Switch Count,” we can quickly identify the time periods when the database is in full activity. Furthermore, in case you find numerous messages of “Checkpoint not complete” in the database’s alert log like the following message: Thu Nov 26 15:16:35 2019Thread 1 cannot allocate Read more…
In the article “Query REDO LOG file name and status,” we can see the names of the files composing the groups, their sizes, and the status of Oracle redo logs. Redo log files, essential for data recovery in case of corruptions, are sometimes not sized appropriately for the volume of Read more…
In the DDL Objects in ORACLE article, we have the ability to extract the DDL (Data Definition Language) of objects. The DDL of an object is the code by which the object is defined. In some cases, it is necessary to extract the creation code to verify the complete information Read more…
Con l’articolo dbms_ijob remove JOB Oracle, forniamo uno statement che permette di rimuovere definitivamente un JOB dal database Oracle. Il dbms_ijob è un package nascosto che viene richiamato dal package dbms_job. Questo permette la creazione, cancellazione o la messa in broken di un JOB Oracle ossia fermare la schedulazione del Read more…
With the article DBMS_IJOB BROKEN FALSE, we provide a statement that allows enabling a JOB of another user from the BROKEN state. In other words, we re-enable it with the scheduled scheduling as specified during creation. When a scheduled JOB in the Oracle database encounters a failure, it is rerun Read more…
With the article DBMS_IJOB BROKEN, we provide a statement that allows blocking the normal scheduling of a specific JOB. When a scheduled JOB in the Oracle database encounters a failure, the JOB is rerun after 1 minute. If it fails again, it is run after 2 minutes. If it fails Read more…
In the article Query JOB Running, we provide a query that allows identifying the running JOBS of all users in the database. The view that allows access to the information of the running JOBS is the table DBA_JOBS_RUNNING, from which it is possible to retrieve many useful information including the Read more…
With the article Query JOB Oracle status, we provide a statement to retrieve information about scheduled JOBS in the database. A JOB is a scheduling of a procedure, a PL/SQL package, or a simple statement that is programmed to start at a specific day and time when we want to Read more…
Query to generate the DDL for User Creation, Roles, and Privileges With the article “DDL for User Creation Roles and Privileges”, we provide a series of statements with which we can extract the creation code of a USER. Additionally, it is possible to extract the roles, system privileges, object privileges, Read more…