Oracle Database 11g DBA Handbook (Osborne ORACLE Press by Bob Bryla, Kevin Loney

By Bob Bryla, Kevin Loney

I paid for 3-5 days transport and Amazon may possibly please payment the thing was once SHIPPED AFTER five days so little need paying extra.
Rest Amazon is often reliable.

Show description

Read or Download Oracle Database 11g DBA Handbook (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 types, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time details entry and information sharing throughout your dispensed framework utilizing the professional details during this Oracle Press consultant. Oracle Streams 11g info Replication explains how you can organize and administer a unified company information sharing infrastructure.

Oracle Application Express 4 Recipes

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

Extra resources for Oracle Database 11g DBA Handbook (Osborne ORACLE Press Series)

Example text

The longevity of the temporary data is controlled by the on commit clause; on commit delete rows removes all rows from the temporary table when a commit or rollback is issued, and on commit preserve rows keeps the rows in the table beyond the transaction boundary. However, when the user’s session is terminated, all of the user’s rows in the temporary table are removed. There are a few other things to keep in mind when using temporary tables. Although you can create an index on a temporary table, the entries in the index are dropped along with the data rows, as with a regular table.

For an installation of Oracle 11g, a minimum of two tablespaces are created: the SYSTEM tablespace and the SYSAUX tablespace; a default installation of Oracle 11g creates six tablespaces (see the appendix “Installation and Configuration” for sample Oracle 11g installations). Oracle 11g allows you to create a special kind of tablespace called a bigfile tablespace, which can be as large as 128TB (terabytes). Using bigfiles makes tablespace management completely transparent to the DBA; in other words, the DBA can manage the tablespace as a unit without worrying about the size and structure of the underlying datafiles.

Here is an example of creating a reverse key index: create index IE_LINE_ITEM_ORDER_NUMBER on LINE_ITEM(Order_Number) REVERSE; If an order number of 123459 is placed, the reverse key index stores the order number as 954321. Inserts into the table are distributed across all leaf keys in the index, reducing the contention among several writers all doing inserts of new rows. A reverse key index also reduces the potential for these “hot spots” in an OLTP environment if orders are queried or modified soon after they are placed.

Download PDF sample

Rated 4.26 of 5 – based on 9 votes