Ask TEM Dba

This script generates a spool file that can be run from a SQL*Plus session to list the differences between 2 tables with identical structure. This can be useful if 2 similar tables need to be compared across different[...]

I found an interesting script that I used sometime back to compare the structure of 2 tables. Thought I should preserve and blog it for the benefit of all. — SCRIPT START — Rem script name – compare_tab[...]

Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view: SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free) FROM V$temp_space_hea[...]

Oracle is the worlds most flexible database and we have many methods for renaming tablespaces and the underlying data files. Tablespace data file rename We can use the alter tablespace rename datafile command, but t[...]

Here are some scripts related to Tablespace Information . Information TABLESPACE INFORMATION NOTES: Tablespace Name – Name of the tablespace Initial Extent – Default initial extent size Next Extent – D[...]

Le principe des annulations est assez simple. En effet, lorsqu’on travaille dans sa session, nous allons créer des transactions (suite d’ordres DML considérée comme indivisible, pour maintenir les données consist[...]

Ce petit script permet de savoir si nos redo log switchent trop souvent ou pas assez. Si ils switchent trop souvent alors cela peut engendrer des problèmes d’I/O, engendrer du redo-log contention. Si ils ne switchent [...]

One of the best ways I have found to resize or recreate online redo log files and keep the current sequence is to perform it online. In this example, we will resize all online redo logs from 100MB to 250MB while the [...]