databasejournal.com databasejournal.com

Finding performance problems using statistics

Statistics are at the core of determining whether your performance tuning efforts are working or not. James Koopmann dives into performance methodologies, specifically Oracle's performance method, to give us a better understanding of how to tune a database with statistics. In my last article, I started to look at methods of performance tuning but it quickly turned into a discussion on throughput, response time, and some statistics...

databasejournal.com databasejournal.com

Database Performance Tuning: Statistical Gathering

Some good to great database products exist to help you tune your database, while others are not so good; but regardless of the tool, it is imperative that you understand some form of tuning methodology first. There are many database products out there to help you tune your database. Some are good to great and others are not so good. However, regardless of the tool you use, or are looking to purchase, an understanding of some form...

databasejournal.com databasejournal.com

14 Useful DBA Tasks for Solving Database Performance Problems

A DBA's role often revolves around tuning the database. This in itself can be a very daunting task. A checklist of DBA tasks can be quite handy. James Koopmann shares some performance tuning activities that a DBA needs to know and that will often be part of a solution to remedy a database performance problem. Ok, so you landed yourself a DBA job, maybe you've been promoted, or you just had the role pushed into your lap because...

databasejournal.com databasejournal.com

Top 5 Query Tactics Questions for the PL/SQL Developer Job Interview

James Koopmann shares five common issues that could get you into trouble when writing PL/SQL (and SQL), and how you might answer those questions within the confines of a PL/SQL job interview. An interviewer should see your attention to detail and desire to improve the environment, even if they, themselves, have tendencies to crank out code without regard to standards. It is amazing to me that many writers of PL/SQL never give much...

databasejournal.com databasejournal.com

Top 6 Security Questions for a PL/SQL Developer Job Interview

Security, in general, is big business these days and to ace that interview you need to at least know the basics. This article discusses encryption and how Transparent Data Encryption (TDE) & Transparent Tablespace Encryption (TTE) work. Security, in general, is big business these days. You need only look at the big database players to see an increase in effort and money being dedicated to acquiring various security vendors to...

databasejournal.com databasejournal.com

Oracle Developer Job Interview: Top 10 PL/SQL Performance Questions

All too often, database developers are under such extreme pressure to write code that they forget about the performance aspects. This set of interview questions addresses the concerns that a hiring manager might have concerning the performance of the code you write. Next to functionality, everyone wants their applications to perform well. However, all too often we are under such extreme pressures to write code that we forget about...

databasejournal.com databasejournal.com

Procedures, Functions, and Packages: Acing that PL/SQL Developer Job Interview

Understanding data structures, data types, and code fragments all play a very important piece in understanding PL/SQL code. James Koopman helps you put these code pieces together to better demonstrate your skill and foresight on that job interview. Understanding data structures, data types, and code fragments (cursors, loops, exception blocks, etc.), as well as others, all play a very important piece in understanding PL/SQL code....

databasejournal.com databasejournal.com

Top 5 Oracle Database PL/SQL Job Interview Questions

Interviewing for a PL/SQL developer position may turn into a quiz, specifically about writing SQL and extracting information from a set of tables. The following questions are actual questions the author has been asked when interviewing for both a DBA position and a PL/SQL developer position. Interviewing for a PL/SQL developer position may turn into a quiz, specifically about writing SQL and extracting information from a set of...

databasejournal.com databasejournal.com

Regain Control of Your Oracle Database with DBMS_METADATA_DIFF

Oracle Database change control is always difficult even under the best scenarios. Using Oracle's DBMS_METADATA_DIFF becomes a great weapon for a database administrator to regain control. Sometimes, ok many times, one of the most difficult jobs as a database administrator is having to sync database objects between databases, schemas, production, development, QA, etc. etc. etc. Way back in the days, before Oracle started producing...

databasejournal.com databasejournal.com

Little Known Uses for Oracle Database's Error Tool

Oracle Database's Oracle Error messaging system is often forgotten but can become a staple for many Database Administrators. One need only look at the Oracle documentation to realize that the extent and number of errors that could be generated are enormous within the oracle product set. Most DBAs and database developers will tend to thumb the error message book more often than we would all like to admit. What many DBAs know, but not...

databasejournal.com databasejournal.com

Oracle Database's ADRCI: the Extended Commands

Oracle's ADRCI extended commands provide valuable scripting and file viewing options, with about two dozen commands that you can use to look at and manage diagnostic information.. ADR is the future of Oracle diagnostics and it's essential that database administrators understand it. If you read Oracle database documentation for the ADRCI utility, and looked at the command reference, you'd see about two dozen commands that you can...

databasejournal.com databasejournal.com

Purging Oracle Database's Alert Log with ADRCI - Usage and Warning

Oracle Database's ADR purge command is superior for purging alert log entries. Just be forewarned on how to actually use it since the desired or perceived outcome is not always apparent. Alert Log Scraping with Oracle’s ADRCI Utility looks at extracting Oracle alert errors from the alert log and Rotating Oracle’s Alert Log with ADRCI discussed taking those extracted errors and making backup copies of them by day in...

databasejournal.com databasejournal.com

Rotating Oracle Database's Alert Log with ADRCI

Many Oracle database administrators would not only like to report on (ORA-) errors but also manage the alert log itself--saving and/or trimming the alert log, aka alert log rotation. Oracle’s new ADR with command interface can easily be used to help rotate Oracle’s alert log. In Alert Log Scraping with Oracle’s ADRCI Utility, I looked at extracting Oracle alert errors from the alert log; specifically the alert log...

databasejournal.com databasejournal.com

Eight Reasons Why Oracle's Acquisition of Sun isn't All Bad

Much has been said about why Oracle acquired Sun, how it will be the demise of the free world and produce a one-world database monopoly. While there is probably a little truth in the statement, we should keep in mind that much of what is happening can be beneficial for the end customer. There has been much said about why Oracle acquired Sun, how it will be the demise of the free world and produce a one-world database monopoly....