I decided to share my SQL Developer reports. Some co-workers asked me if they could use them, and why not? Big fan of sharing information, I will be sharing my reports here. Feel free to use them, change them, and if you don’t like them : remove them. I should point you to my general […]
Currently i am working with a customer that has security on a high level. They really think about what we are doing, and we are trying to work as secure as possible. I like the attitude, security is important. One of the “rules” we have for all DBA’s : try not to work with “/ […]
When doing maintenance on a database, on users, on objects, I often want to exclude schemas that are part of the database. Schemas for apex, monitoring, java, Warehousebuilder, etc. So I have a where clause which looks like this :
where owner not in ('SYS', 'SYSTEM','SYSDG','DBSNMP',.........
That works fine, but on large systems with many installed features the list can […]
After installing some updates on my macbook, I noticed that the launchpad icon kept showing a little progress bar under the icon. Payed little attention to it, perhaps a restart (whenever that may be), or when i would install a new app it would fix itself. However after weeks, some reboots, many apps installation later […]
Want to know the rate of I/O per tablespace? Do you have hotspots, or unused tablespaces ? Which filesystem receives the most writes, reads ?
I am playing around in SQL Developer, and wanted to look at the reports, and the graphs it seemed to be able to create. All kind of graphs can be generated, and I decided to create a simple line graph that would show the amount of MB generated in archivelog files per day. Would be […]
One screen I liked a lot in TOAD is the “redo log switch frequency screen” (or whats it’s name?). So I started searching, read some others blogs, experimented with some setups, couldn’t really find what i was looking for. Then i found this and really wanted to share. Credits to the original blogger : read […]
I used toad with the DBA module for years. A powerful tool and I really liked it. Not just for browsing, but also schema comparison, script generating, and a lot of tools. The downside of toad+DBA module : price, it’s expensive and therefore I never had a personal license. My current project ( I am […]
We have all been there : running a script, rman restore, upgrade and wham, the vpn connection fails, your home network connection gone, and even silly things as : while running the script, my laptop decided it was update time and auto-rebooted 🙁 Connection gone, session dead, script terminated somewhere halfway. Surely we all have […]
Our BI departement recently did some big maintenance to their set of tables, indexes, etc. After their efforts, the datafiles contained a lot of air. Since storage is expensive, we decided to try to shrink the datafiles. We know about the high watermark, we cannot shrink files lower then that point, but any space after this […]