Oracle Database 10g High Availability with RAC, Flashback, by Matthew Hart

By Matthew Hart

Unlocks the key to retaining your Database on hand and operating smooth.
Great paying for event

Show description

Read Online or Download Oracle Database 10g High Availability with RAC, Flashback, and Data Guard (Osborne ORACLE Press Series) PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

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

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication let real-time details entry and information sharing throughout your allotted framework utilizing the specialist details during this Oracle Press advisor. Oracle Streams 11g information Replication explains find out how to organize and administer a unified firm information sharing infrastructure.

Oracle Application Express 4 Recipes

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

Extra info for Oracle Database 10g High Availability with RAC, Flashback, and Data Guard (Osborne ORACLE Press Series)

Example text

Insert the rows from the temporary table into the original table. Since this technique has multiple steps, we recommend that you test this first in a non-production environment before you attempt this in a production database. Here’s a short example to demonstrate the prior steps. First create a temporary table that contains the rows in the EMP table that have corresponding records in the CHAINED_ROWS table: create table temp_emp as select * from emp where rowid in (select head_rowid from chained_rows where table_name = 'EMP'); Now delete the records from EMP that have corresponding records in CHAINED_ROWS: delete from emp where rowid in (select head_rowid from chained_rows where table_name = 'EMP'); Now insert records in the temporary table into the EMP table: insert into emp select * from temp_emp; The prior process of moving the migrated/chained rows should clear up any row migration.

For example, assume the table was initially built with a PCTFREE value of 40%. This next move operation rebuilds the table with a PCTFREE value of 5%: SQL> alter table emp move pctfree 5; However, keep in in mind if you do this, you could make the problem worse, as there will be less room in the block for future updates (which will result in more migrated/chained rows). ■■Note When you move a table, Oracle requires an exclusive lock on the table; therefore you should perform this operation when there are no active transactions associated with the table being moved.

Topics that are selective and frequently accessed should be included in the book index. If an index in the back of the book is never looked up by a reader, then it unnecessarily wastes space. Much like the process of creating an index in the back of the book, there are many factors that must be considered when creating an Oracle index. Oracle provides a wide assortment of indexing features and options. These objects are manually created by the DBA or a developer. Therefore, you need to be aware of the various features and how to utilize them.

Download PDF sample

Rated 4.18 of 5 – based on 21 votes