Donald K. Burleson Boeken

Oracle has emerged as the world's most flexible and robust database, but this power brings complexity that requires DBAs to possess expert knowledge of Oracle internals. This book offers a thorough, step-by-step approach to holistic Oracle tuning, drawing from extensive experience in tuning thousands of databases. As Oracle evolves, the task of tuning has become increasingly complex, necessitating new techniques for optimal performance in today's high-tech production environments. The introduction of Oracle STATSPACK and AWR has revolutionized database tuning, enabling the development of time-series tuning models to predict outages and dynamically adjust resources. Tuning efforts must match the sophistication of the databases themselves. This book aims to help you leverage Oracle's wealth of performance information to create a robust database engine that maximizes resources while minimizing overhead. It is not intended for beginners; instead, it encapsulates over a century of hands-on DBA tuning experience, offering a pragmatic approach for senior Oracle DBAs. Comprehensive in scope, it equips you with the knowledge needed to tackle even the most complex tuning challenges. Additionally, the code download includes ready-to-run scripts designed to monitor and identify challenging performance issues.

Provides advice for administrators and developers who use the SAP business system and the Oracle database system (Oracle8 or Oracle7) in combination. It covers SAP's SAPDBA and SAPGUI utilities and describes effective data file placement, intitialization parameters, and monitoring techniques.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

It's impossible to tune an Oracle database without understanding SQL tuning. Oracle is a SQL processing engine and the execution speed of any SQL query is influenced by many factors, both internal and external. As a declarative data access method, SQL relies on the Oracle cost-based optimizer to always choose the "best" execution plan for every SQL query. However, Oracle's SQL is among the most flexible and robust in the world, and along with this great power comes complexity. Tuning Oracle SQL is the single most important skill of any Oracle professional, and Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time. "Advanced Oracle SQL Tuning" is a pragmatic treatment of Oracle SQL tuning, short on theory and big on real-world techniques and tips. This book is the culmination of the author's 25 years of full-time DBA experience and he shares expert tips and secrets for hyper charging SQL execution speed. This book covers advanced topics and it is not appropriate for beginners, dilettantes or neophytes.

The Unix for Oracle DBAs Pocket Reference puts within easy reach the commands that Oracle database administrators need most when operating in a Unix environment. If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that these commands are far different from those covered in most beginning Unix books. To jump start your learning process, Don Burleson has gathered together in this succinct book the Unix commands he most often uses when managing Oracle databases. You'll be able to reach into your pocket for the answer when you need to know how to: Display all Unix components related to Oracle, identify the top CPU consumers on your server, and even kill processes when necessary Stack Unix commands into powerful scripts that can perform vital DBA functions Monitor Unix filesystems, and automatically manage your trace files, dump files, and archived redo log files Use essential server monitoring commands such as top, sar, and vmstat And there's much more between these covers. If you need to get up to speed with Oracle on Unix, and quickly, this book is for you.

With the expert techniques discussed in this book, Oracle database administrators can automate routine tasks to save time and money and better monitor the flow of work. Using shell scripts—an indispensable tool on UIX and Linux—any number of commands can be combined and executed either simultaneously or sequentially. More than 50 working shell scripts for both beginners and experts give Oracle professionals a fantastic head-start on automating their administration duties and are easily modifiable for any environment. Topics include the history of shells and shell scripting, detailed step-by-step instructions on building shell scripts, how to tell when things are working right, and how to effectively monitor the system for failures.