Database Systems is a blog about Databases and Data of any size and shape
Pages
(Move to ...)
My Blog
My apps
▼
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