Database Systems

Database Systems is a blog about Databases and Data of any size and shape

Pages

▼
Saturday, 20 January 2007

Shared_pool latching

›
Trying to get answer for this from Gurus like Thomas Kyte and Jonathan Lewis. SHARED POOL LATCHING in LIBRARY CACHE. Why is it bad? Shared p...
1 comment:
Monday, 15 January 2007

Recovering after SHUTDOWN ABORT, or CRASH during OS hot-backup

›
What to do if the hotbackup database crashes during the hotbackup? When this happens the tablespaces are going to be in an inconsistent stat...
Friday, 12 January 2007

DBMS_STATS package

›
Use DBMS_STATS to gather Oracle dictionary statistics. DBMS_STATS is the preferred and recommended method as it is more complete that the AN...
Monday, 8 January 2007

Add Oracle range partitions quickly

›
Find the partition with the maximum HIGH_VALUE and see if you need to add new RANGE partitions which use date partitioning. I hear Oracle 1...
Saturday, 6 January 2007

Change timestamp

›
Changing he timestamp of a file in linux $ touch -t 200605101200 myfile.txt
‹
›
Home
View web version
Powered by Blogger.