(Craig Shallahamer) Oracle performance analysis has come a long way in the last 20 years. First there was the “just add more resources” approach, then came ratio analysis, and finally, wait event analysis emerged. But those approaches were not complete or broad enough, so in 2001 I published a paper
Tag: Oracle
Oracle OpenWorld X-Treme the Pre-Conference Weekend
This exclusive two-day program will consist of highly technical, deep-dive content not typically available in the regular OpenWorld agenda. Oracle experts from applications and technology will be on hand to guide you through a series of intense breakout sessions, and X-Treme hands-on workshops.
Where Did Oracle Come From?
(Steve Callan) As an Oracle DBA, you know that Oracle is a relational database management system and that it performs many complex functions well. In the pressure to learn how to be a DBA or what it is you should be doing, it is hard to take the time to sit back and appreciate the origins of the RDB
Mining for Clues
(Arup Nanda) Paul is on the other end of the line and is irate. He had been the account manager for a customer named Ellen Smith for the past 20 years. But today, when Ellen walked into the bank, the system said Paul was no longer the account manager! Embarrassed and justifiably upset, he is screami
Oracle Bends (A Bit) On Multi-Core Licensing
(Barbara Darrow) Oracle is bending — kind of — on its licensing policies for the new multi-core CPUs coming on the market, sources tell CRN.
Oracle Plugs into Visual Studio .Net
(Michael Myser) Oracle released a free plug-in for Microsoft Visual Studio .Net that allows developers to create and deploy the company’s database applications on Microsoft Windows. Oracle Developer Tools for Visual Studio .Net 2003 integrates Oracle Database 10g and Microsoft’s Visual Studio develo
Use profiles in Oracle to create a password management policy
(Scott Stephens) Most Oracle database users create user accounts with the default profile. Since Oracle 8, it’s possible to lock an account by creating a profile and assigning it to a user.
Critical Patch Update – July 2005
A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those security patches. The Oracle Database Server, Enterprise Manager, and the Oracle Application Server patches in the U
Database Interaction with PL/SQL: Nested Blocks in Depth
(Jagadish Chatarji) This is part eight of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I gave an introduction to user defined exceptions and nested blocks in PL/SQL. In this article, we will look into handling more than one exception and differen
Tuning Undo Tablespace
(Kimberly Floss) A company’s quarter-end processing includes several long-running transactions. At the same time, several customer service representatives are updating information contained in the same underlying tables.
