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 index OK, let’s talk about the Index Range Scan. The word range reflects that Oracle will scan through (a […]
Main Post The Index Unique Scan is used when one unique piece of information (row) is needed. A primary key […]
In a number of posts about indexes I use a demo table with some indexes. Here is how it is […]
Let’s talk a little about the usage of indexes. Following access paths are considered: Index Unique Scan Index Range Scan […]
Today someone deleted everything: datafiles gone, controlfile gone, spfile gone. What to do?…..not to worry….if you have backups (and the […]
That’s a little more complicated. The controlfile (nocatalog) is the place where oracle stores all information regarding the backups. So […]
A sysadmin wasn’t paying attention and deleted a few datafile from the (running) database. What can we do? Actually we […]
At (let’s say) around 08:30 this morning something (probably someone) messed up the database. I would like to go get […]
A few recipes I like to go through: Restore and recover a database as far as we can go Restore […]