Oracle DBA on UNIX and Linux (Kaleidoscope) by Michael Wessler

By Michael Wessler

Oracle DBA on Unix and Linux offers the entire details had to set up, help, track, and improve Oracle databases at the UNIX and Linux systems. keep a strong, mission-critical Oracle8i database. This booklet presents administrative options for the day by day DBA. you will the best way to set up the database for optimum potency, enhancements, patches, migrations, track, and preserve its defense. The publication additionally explains intimately the way to construct and aid a totally functioning Oracle database. This authoritative textual content comprises updated info on hand on Oracle's newest unencumber and exhibits you ways to: configure database structure; set up and manage with UNIX specifications; create the particular database with scripts; GUI administration items; use Backup and restoration; song, visual display unit, and troubleshoot servers; net DB and the Oracle Portal, 8i, iFS, Java, and 9I insurance; and iAS--Internet software Server.

Show description

Read or Download Oracle DBA on UNIX and Linux (Kaleidoscope) PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time info entry and information sharing throughout your dispensed framework utilizing the specialist details during this Oracle Press consultant. Oracle Streams 11g facts Replication explains easy methods to arrange and administer a unified company info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program show four Recipes presents an example-based method of studying software show - the ground-breaking, speedy program improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes an exceptional instance or to kick begin their considering and get pointed within the correct path.

Extra resources for Oracle DBA on UNIX and Linux (Kaleidoscope)

Sample text

Temp Temp (temporary) data files are simply locations on disk for sorting operations. Some SQL queries require data to be selected and then sorted before it is returned to the user. For example, if a user wanted all employees’ names, identification numbers, and salary, starting with the most highly paid employee and ending with the lowest-paid employee, a sorting operation would be necessary. Oracle would find all the employees and their corresponding data, but it would be necessary to sort them based on salary because the rows would most likely not be stored in that order.

It is the database that the DBA is well paid to protect and manage, so the DBA needs to treat it as such. The skills necessary to perform this task are what this book will explain. Application Knowledge The DBA is responsible for understanding and supporting the program code affecting the database. The DBA does not necessarily write code, but he needs to know what it does. If it is stored inside the database, such as PL/SQL packages or Java procedures, the DBA needs to support this. If it runs outside the database, such as Pro*C, the DBA needs to know where it is and how it connects to the database.

Understanding Organization’s Processes The DBA needs to have a clear understanding of what the database is supporting. It is not enough merely to create tables to implement an ERD without understanding the process as a 1 ROLE OF THE DBA The most obvious area in which the DBA needs skills is the technical arena. This is where most DBAs are at their strongest. Technical skills for the DBA break down into three main categories: database, application, and system. 19 20 Oracle DBA on Unix and Linux whole.

Download PDF sample

Rated 4.69 of 5 – based on 19 votes