Oracle 10G Database - DBA by Kevin Loney

By Kevin Loney

Every thing a DBA must understand in a single volume--this is the must-have reference for someone operating with the Oracle database, and it’s been totally revised and up-to-date for Oracle Database 10g. Co-author Kevin Loney is the all time, best-selling Oracle Press writer.

Show description

Read or Download Oracle 10G Database - DBA PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

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

Oracle Streams 11g Data Replication

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

Oracle Application Express 4 Recipes

Oracle software show four Recipes offers an example-based method of studying software show - the ground-breaking, quick program improvement platform integrated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply desires a superb instance or to kick begin their pondering and get pointed within the correct path.

Extra info for Oracle 10G Database - DBA

Example text

In addition to the standard messaging features, it provides transactional support to the messages. Applications can manage data as well as the messages in a single transaction. Oracle Streams is like a Swiss army knife; you can use it to solve a number of business problems. The list of possible applications of Oracle Streams discussed in this chapter is not exhaustive, so you might even find yet another application for it in your particular business.

The data pump and export/import utilities can set the instantiation SCN for the table at the destination database when importing data. You can also use a supplied procedure to set the instantiation SCN for the tables in the destination database. The instantiation SCN controls which LCRs containing database changes are applied to the destination database by the apply process and which LCRs are ignored. If the commit SCN in the LCR for the source table is greater than the instantiation SCN for the table in the destination database, then the apply process will apply the change to the table.

In situations where the application maintains data integrity outside the Oracle database, and the tables do not have primary key or unique constraints, it becomes necessary to configure adequate supplemental logging. Sometimes it requires supplemental logging of all columns in the table. Note Supplemental logging is always configured at the source database irrespective of the capture process location—local or downstream. Supplemental logging can be configured at the database level or at the table level.

Download PDF sample

Rated 4.70 of 5 – based on 12 votes