List all indexes in an Oracle tablespace
Sometimes Oracle DBAs need to do some tablespace cleaning and moving indexes from one tablespace to another. If you have hundreds of indexes this may…
Showing posts from November, 2011Show all
Choose the Database Index: Selectivity and Cardinality
It is a known fact that most of the database performance tuning is achieved by building a suitable index. In most database engines, such as Oracle an…
Happy Birthday - 6 years old!
This blog, one of the first ones in the Maltese islands, computes its 6th year today. One can browse through old blogposts in the archives menu on th…
Create Oracle Backups in Enterprise Manager
If your Oracle database is connected to the Oracle Grid you can easily manage your backups through Enterprise Manager. This allows you to schedule a …
Windows Batch Script to Delete Old Files
Few of us know that Windows has some not-so-known tools which mimick Unix's powerful commands. Often we require to delete old files on a Windows …
Automating Windows SCP scripts with WinSCP
Legacy FTP usage is being phased out and most of you will have to face newer company security policies to start using SCP to transfer your daily back…
Copy and Skip Existing Files in Windows
If you are hardcore old school Batch coders like me, you most probably have stumbled across the requirement to copy your backups from one place to an…
Best FREE Firewalls for Windows
Most of the Windows users prefer having a different firewall solution other than the builtin Windows Firewall. This has its advantages and luckily fo…
Granting privileges on ALL tables in Postgresql
If you have a database and you would like to grant select on all tables to a particular user or role, in Postgresql one must follow an unorthodox pro…
Integrating Postgresql with LDAP + PAM
Integrating Postgresql with LDAP and PAM is very easy as this article will show. The only requirements are that you have already setup LDAP and PAM o…
Restore Oracle RMAN backup on a new Windows machine
Sometimes disaster strucks (ex. virus, disk failures, etc..) and the only option to get up and running is to restore our Oracle backup onto a new Win…
