databasejournal.com databasejournal.com

Oracle Concepts: Splitting Hairs

How many times have you heard the phrase, “Same thing, but different?” In Oracle, there are many concepts where this applies. Physical files, for example, can be the same, but how they are used is different. RMAN operations can delete, but the type of backup item deleted can be different. Replaying database operations can be the same, but different as to how that is performed. The point of this article is to not really split...

databasejournal.com databasejournal.com

Oracle Security: The Big Picture - Page 2

Password Management Oracle has included its own authentication and password management system since the very beginning. At first, the system was barebones. Each user got a password; the password was assigned and set by the DBA. Users had no means to change their own password, and Oracle had no automated controls for password management. Passwords never expired, never needed to be changed, and could be as simple or as complex as the...

databasejournal.com databasejournal.com

Oracle Security: The Big Picture

Practical Oracle Security By Josh Shaul, Aaron Ingram Published by Elsevier ISBN10: 1-59749-198-5 Published: Nov. 12, 2007 Dimensions 7 1/2 X 9 1/4 in Pages: 288 Buy this book Your Unauthorized Guide to Relational Database Security This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the...

databasejournal.com databasejournal.com

Oracle Tuning Using Tracing, STATSPACK, AWR and Toad

Depending upon what you’re investigating when it comes to performance, one tool may be all you need to answer the question at hand. For more complex questions, chances are several tools may be needed. Tools, in this scenario, can consist of using an explain plan, monitoring sessions and diagnostic information as can be observed using Toad, tracing a session (yours or someone else’s), and running a PERFSTAT report. The tools...

databasejournal.com databasejournal.com

Oracle Database 11g: SQL Performance Analyzer, Part 2

Synopsis. Oracle Database 11g Release 1 (11gR1) features the new SQL Performance Analyzer that promises to ease significantly the workload of busy Oracle DBAs because it provides a way to accurately evaluate complete database workloads for “before versus after” performance changes. This article – the next in a series on new Oracle Database 11g SQL performance improvement features – discusses how to use the SQL...

databasejournal.com databasejournal.com

Product Review: Oracle PL/SQL Tuning

I like to recommend good products or finds from time to time, and the subject of this recommendation is Tim Hall’s Oracle PL/SQL Tuning Expert Secrets for High Performance Programming (published by Rampant TechPress). Books on PL/SQL, like books on other topics related to Oracle, range from the just so-so to what can be called bible status. A few books rise to the top and become the de facto definitive reference, but in some...

databasejournal.com databasejournal.com

Learning Oracle by the Numbers

You may think the title of this article refers to “Learning Oracle is as easy as one, two, three.” Actually, the numbers I have in mind are eight, nine and ten (and soon to be eleven). Although Oracle obviously increments the version number from release to release, the versions you work with from job to job may not, that is, you may be working with 10g in your current job, but in the new one (where you’ve just accepted a...

databasejournal.com databasejournal.com

MS SQL Series

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title. MS SQL Oracle DB2 MS Access MySQL Michael Aubert Learn SQL Server 2000 Administration in 15 Minutes a Week Series SQL Server 2000 Administration in 15 Minutes a Week: Table Basics (Part 1)SQL Server 2000 Administration in 15 Minutes a Week: Restoring...