Think of why you run the DB2 for z/OS REORG utility, and a number of reasons are likely to come quickly to mind: to restore row order per a table's clustering key; to reestablish free space (for inser...
A friend asked: “I know we can use Oracle Enterprise Manager without the packs. However, is there any document that shows in detail what database monitoring and alerting functionality is provided by E...
This blog post is about some questions and answers plus feedback about suggestions. This is to do with a technical article that I had written and which was published on the Oracle Technical Network (...
In a previous article we learned how to create an account in Amazon Web Services (AWS). Besides knowing what Amazon RDS is, we learned how to configure an Oracle Database Instance in Amazon RDS. Here ...
Introduction In a traditional environment development and testing are separated into two phases: developers who build features and quality assurance engineers responsible for testing them. Quality eng...
We’re happy to announce a new Toad World section supporting PostgreSQL and sponsored by EDBPostgres. Over the past couple of years, we’ve seen a surge in the adoption of open source relational databas...
Before Oracle 12c, pluggable databases didn’t exist; whenever we wanted to clone a database we had use either RMAN Backup and Restoreor RMAN Duplicate (Active or from backup location). There are sever...
A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. T...
My feet hurt. I’m tired of wandering the floor. Who’s got the best giveaways and Oracle expertise at Collaborate 2017? We don’t want to toot our own horn, but…toot, toot! We’re talking Apple watch gi...
Oracle Database 12c offers several enhancements to improve security in your PL/SQL program units. These features include: Code-based access control: fine-tune access to database objects inside prog...
This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the ini...
In this article we are going to give an overview of this application called PhpMyAdmin, which is one of the most popular applications for the management of MySQL databases. Throughout my professional ...
