Blog Aggregator - Amardeep Sidhu

Just had a call from a recruitment consultancy offering me an interview with Barclay’s bank for a DBA role looking after their share trading systems. Unfortunately it was a production support only role (aka DataBase Baby Sitting), which would bore me silly, so I had to turn it down.

The consultant said he’d got my CV off monster.co.uk. I only put my CV up there last Thursday and this is the

10G provides so many automatic features that it should have been called 10A for Automatic. Over the course of this blog, I have covered many of the automated features that were introduced in Oracle’s latest and greatest release. There are a couple of automatic features that I haven’t covered yet that warrant further investigation. We’ll discuss automatic undo retention tuning, automatic checkpoint tuning and automatically tuned multi-block reads.

Temporary tablespaces are used to store transient data, which Oracle defines as data that is only available for the duration of the session. The two main types of transient data is data stored in temporary tables and data that is generated by sort operations. Oracle provides temporary tablespaces that are optimized for storage of transient data.

Oracle10G allows administrators to group multiple temporary tablespaces together and assign them to users as a single unit. We’ll begin our discussion on temporary tablespace groups by reviewing sort operations and temporary tablespaces, then continue with a discussion on 10G temporary tablespace groups.

We all know that the desired result of any tuning exercise is to reduce the amount of time that users spend performing database activities. Good tuners understand that the tuning process starts with an understanding of the problem then continues with the DBA collecting statistical information. Information collection begins at a global level and then narrows in scope until the problem is pinpointed.

Experienced DBAs often start their tuning efforts by selecting data from the V$ dynamic performance tables to view system-wide performance indicators. Thanks to Oracle 10G, we have two new views to add to our tuning arsenal. We’ll take a look at these two time model views in this blog and learn how we can use them to determine where the user processes are spending their time.

Readers of this blog know how important I think 10G Grid Control is to the future of Oracle database administration. DBAs must learn to leverage the intelligence built into the Grid Control product set to reduce the amount of time they spend administering, monitoring and troubleshooting Oracle databases.

That being said, there are times when you don’t have access to a full blown, enterprise-wide Grid Control environment. Not to worry, Oracle also provides the 10G Database Control administration toolset. 10G Database Control can be used to effectively administer a single Oracle database. Although 10G Database Control might not have the enterprise-wide scope that Grid Control does, it does provide a very robust set of features and functions that are guaranteed to make database administrators more productive. This blog will provide you with a brief overview of the 10G Database Control product set. We’ll also compare and contrast Database Control to its big brother, Grid Control.

Anyone else use Linked-In?

It’s kinda a social networking type of site but business/job seeking oriented. The idea being that you might not know anyone who has the skills you need for a job you have on offer or who can offer a job that would suit your skills but someone that you know might know someone or someone you know might know someone who knows someone &c. Of course it does rely on you