GPG stuff
GPG (Gnu Privacy Guard) is the gnu implemantaion of PGP (Pretty Good Privacy). PGP was written decades ago by Phil […]
Index, Oracle
INDEX FULL SCAN (MIN/MAX)
Index index Another way an index can be used to access a piece of data: Index Full Scan (Min/Max) If […]
Index, Oracle
Index Range Scan
Index index OK, let’s talk about the Index Range Scan. The word range reflects that Oracle will scan through (a […]
Index, Oracle
Index Unique Scan
Main Post The Index Unique Scan is used when one unique piece of information (row) is needed. A primary key […]
Index, Oracle
Index_demo data setup
In a number of posts about indexes I use a demo table with some indexes. Here is how it is […]
Index, Oracle
Index usage
Let’s talk a little about the usage of indexes. Following access paths are considered: Index Unique Scan Index Range Scan […]
Oracle, rman
Restore and recover a database when everything is gone
Today someone deleted everything: datafiles gone, controlfile gone, spfile gone. What to do?…..not to worry….if you have backups (and the […]
Oracle, rman
Restore and recover a database when the controlfiles are missing
That’s a little more complicated. The controlfile (nocatalog) is the place where oracle stores all information regarding the backups. So […]
Oracle, rman
Restore and recover a database when datafiles are awol
A sysadmin wasn’t paying attention and deleted a few datafile from the (running) database. What can we do? Actually we […]