sitepoint.com sitepoint.com

September Wrapup

Some interesting things I have found this month on Fedora, SELinux, Google competition perhaps and more… 1) A way to get an insider look at Fedora aside from the RedHat sponsored site is through the Fedora People blog. 2) SELinux is now in the 2.6 kernel and has some interesting updated capabilities with securing the filesystem through extended attributes and security labels. To insure comprehensive coverage, there is a method to...

databasejournal.com databasejournal.com

Virtual Indexes in Oracle

Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for a very specific purpose. A virtual index is created in a slightly different manner than the normal indexes. A virtual index has no segment pegged to it, i.e., the DBA_SEGMENTS view will not show an entry for this. Oracle handles such...

databasejournal.com databasejournal.com

Gathering Space Usage Statistics

As a DBA, you will need to perform a number of different tasks to keep your databases and servers up and running. One of those DBA tasks you will need to perform is disk space capacity planning. You need to make sure there is enough disk space, so when one of your databases needs to grow it can find the disk space it needs. Depending on the growth patterns of your databases, you will more than likely need to purchase additional disk...