Ask TEM Dba

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[...]

Here are some scripts related to Hit/Miss Ratios . Buffer Hit Ratio BUFFER HIT RATIO NOTES: Consistent Gets – The number of accesses made to the block buffer to retrieve data in a consistent mode. DB Blk Gets &#[...]

One of the many new features that Oracle 10g introduced is the recyclebin. When enabled, this feature works a little bit like the familiar Windows recycle bin or Mac Trash. Dropped tables go “into” the recycl[...]

Upgrade was done from 10.2.0.3 to 10.2.0.4. Dataguard has physical standby configuration. Steps and commands may vary depending on your environment. …… primary database commands …… standby databa[...]

Introduction En version 9i, oracle a introduit la notion de FlashBack query. En français, la possibilité d’interroger une table à un e époque révolue. Mécanisme bien sympathique pour prévenir les erreurs utilisa[...]

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 [...]

col owner format a15 col segment_name format a30 col segment_type format a15 col mb format 999,999,999 select owner , segment_name , segment_type , mb from ( select owner , segment_name , segment_type , bytes / 1024[...]

col "Database Size" format a20 col "Free space" format a20 col "Used space" format a20 select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' GB' "Database Size" , round(sum(used.bytes) / 1024 / 1024 / 1024 ) - round([...]