Blog Aggregator - Amardeep Sidhu

Hallowe’en is a time of fright and mystery, and some of the most common, mysterious Oracle questions I collect involve passwords. Here are some tricks and treats:

How do you change an Oracle password? … If you/the user forgot it?
How are Oracle passwords stored?
Does it look the same for two different users using the same password?
Do the SQL Trace files reveal your secret password?
How do

Those that excel at tuning understand that the tuning process starts with an understanding of the problem and continues with the DBA collecting statistical information. Information collection begins at a global level and then narrows in scope until the problem is pinpointed. Part 1 of this series provides hints and tips that can be used to determine what architectural component is causing the problem. In subsequent blogs, we’ll learn how to use the toolsets provided in Oracle9I and Oracle10G to continue the investigation.

If you follow the various blogs on the right, you’ll see that practically everybody (except me) is currently attending Oracle OpenWorld 2006. It’s an annual convention held in San Francisco late in the year. Lasts about 4 days, and costs around 2000 USD$.

I’d love to attend Oracle OpenWorld some day. Or practically any conference. I would especially like to visit the annual conference hosted

I thought I would spend one of the last few blogs in this series by discussing the importance of soft skills. If you want to remain competitive in this profession, you must be able to communicate effectively. I’ll provide you with a few helpful hints and tips to improve your verbal and written communication skills.

Want to know what has been calling the PL/SQL Procedure you’ve written?
Want to know how to tell how far along your long-running PL/SQL Procedure is?
What to know how to write fast mass insert/deletes like a pro?

I have found you the answer for all three, courtesy of my fine colleagues featured among my links. Allow me to guide you through these three great articles.

Who Is Calling Your

Having worked in technical support for software vendors for 4 years, I know a few strategies that can help customers get the best response.

1. Get training
Rely on the assistance of the software vendor for as little as possible. Invest in training your own people by signing them up for courses and, more importantly, giving them the time to learn the product and how your company uses it. Once

This blog will provide you with some hints and tips that will help you obtain the most benefit when you attend “Old OU” (Oracle University). I’ll also provide some recommendations to help you pass the Oracle Certification Exams.

Database administrators are much more than just “table jockeys.” Because of our well-rounded expertise, we are often asked to help evaluate third-party business applications, application development tools and database administration and monitoring products. Over the years, I have developed a Product Evaluation Methodology that you may find helpful.