|
|
 |
= 7 days or newer |
|
 |
= 14 - 7 days old |
Documentation
|
|
Your first priority when tuning archiving is to ensure that LGWR never gets stuck on a log switch waiting for ARCn to finish archiving a log file. Your second priority is to minimize the impact that ARCn has on foreground processes when it is active. Of course, these two priorities are opposed to one another. Our preference is to tune ARCn to run quickly, and only slow it down if there is evidence that it is impacting foreground performance.
|
|
|
|
In Oracle 8i and below, Rollback Segments provide read consistency and the ability to rollback transactions. In Oracle 9i, Undo segments can be used to provide this functionality. The advantage of using Automatic Undo Management is that it relieves the DBA of manually creating, sizing and monitoring the rollback segments in the database.
To start using Automatic Undo Management one must create an UNDO-type tablespace and set some initialisation parameters.
|
|
|
|
This article provides tutorial notes on Sun's Reference Implementation of JdbcRowSet working with Oracle database. Topics include installing JdbcRowSet reference implementation; connecting JdbcRowSet objects to database server with connection URL, DataSource name, ResultSet objects or Connection objects; query parameters; inserting rows.
|
|
|
|
This chapter contains detailed descriptions of the database initialization parameters, and includes the following topics: Initialization Parameter File, Specifying Values in the Parameter File, Reading the Parameter Descriptions, Parameter Descriptions
|
|
|
|
Oracle Database 2 Day DBA 10g Release 1 (10.1) NOTE: Requires OTN Account (free)
|
|
|
|
A collection of 27 FAQs on Oracle loading data and exporting data. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema and tables, creating external tables.
|
|
|
|
A collection of 27 FAQs on Oracle loading data and exporting data. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema and tables, creating external tables:
What Is the Quickest Way to Export a Table to a Flat File?
How To Export Data with a Field Delimiter?
How To Load Data with SQL*Loader?
How To Load Data through External Tables?
How To Load Data from External Tables to Regular Tables?
How To Invoke the Data Pump Export/Import Utility?
How To Do a Full Database Export?
How To Import One Table Back from a Dump File?
How To Invoke the Original Export Import Utilities?
...
|
|
|
|
A collection of 18 FAQs on database tables for DBA and developers. Clear answers are provided together with tutorial exercises to help beginners on creating, altering and removing tables, adding, altering and removing columns, and working with recycle bin.
|
|
|
|
A collection of 23 FAQs on Oracle user account, schema and privileges. Clear answers are provided with tutorial exercises on creating user accounts, granting privileges for session connections, granting privileges for creating tables and inserting rows:
What Is the Relation of a User Account and a Schema?
What Are the System Predefined User Roles?
How To Connect to the Server with User Account: SYS?
How To Use Windows User to Connect to the Server?
How To Create a New User Account?
How To Change User Password?
How To Delete a User Account?
What Privilege Is Needed for a User to Connect to Oracle Server?
How To Lock and Unlock a User Account?
What Privilege Is Needed for a User to Creat Tables?
How To Assign a Tablespace to a Users?
What Privilege Is Needed for a User to Query Tables in Another Schema?
How To Find Out What Privileges a User Currently Has?
...
|
|
|
|
This is a collection of FAQ for Oracle DBA on fundamental concepts. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides. Topics included in this FAQ are:
|
|
|
|
|
|
|
|
|
|
Page Views
|
|
711 today
|
|
2,100 yesterday
|
|
118,787 last month
|
|
13,155,974 total
|
|
|
|
