Ask TEM Dba

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

col "SID/SERIAL" format a10 col username format a15 col osuser format a15 col program format a40 select s.sid || ',' || s.serial# "SID/SERIAL" , s.username , s.osuser , p.spid "OS PID" , s.program from v$session s , v$pr[...]