| Home : Certification : Oracle |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
Oracle Listings
|
|
Total:
13 | Displaying: 1 - 10 | Pages: 1 2 >> |
|
|
|
In order to start using the AUTOTRACE utility, some initial setup operations must be performed. These operations are stated below:
Every user willing to use this utility must be granted the PLUSTRACE role.A PLAN_TABLE must be created in the user schema.In order to create and grant the PLUSTRACE role to the Database Administrator, the following commands must be issued from the SQL*Plus session.
Updated: 01/09/2007
|
|
|
The Database Resource Manager (DRM) is a tool, which handles the resource allocation issues in a more efficient way than can probably be done by the operating system itself. Such issues include equal distribution of resources by the operating system to every active process, inability of the operating system to prioritize the tasks, and inability of the operating system to manage database-specific resources. This tool has been provided with all versions after Oracle7i. Before the introduction of this feature, resource management was only possible through the use of profiles.
Updated: 01/09/2007
|
|
|
Materialized views can be created either through the CREATE MATERIALIZED VIEW statement or the Oracle Enterprise Manager (OEM). The CREATE MATERIALIZED VIEW statement can also be used for populating the materialized views. A materialized view can be derived from an existing user-defined materialized view. In this case, the ON PREBUILT TABLE clause of the CREATE MATERIALIZED VIEW is used
Updated: 01/09/2007
|
|
|
This test requires a thorough knowledge of administrative tasks for managing the database for optimal performance. The candidate appearing in this test should have a sound knowledge of various tools available in Oracle9i for managing different issues in the database. This includes identifying contentions and resolving them through the tools. For this purpose, one should practice the following to a good extent.
Updated: 01/09/2007
|
|
|
A naming method is a names resolution method that a client application uses to resolve a connect identifier to a connect descriptor when attempting to connect to a database service.
Users initiate a connection request to a database service by providing a connect string with the CONNECT command on the command line. A connect string includes a username and password, along with a connect identifier. A connect identifier can be the connect descriptor itself or a name that resolves to a connect descriptor.
Updated: 01/09/2007
|
|
|
An RMAN channel represents one stream of data to a device type and corresponds to one server session. It establishes a connection from the RMAN executable to a target database instance by starting a new server session on the instance. The server session then performs the backup, restore, and recovery operations. Only one RMAN session communicates with all the allocated server sessions. RMAN channels are of two types, DISK and sbt. If the channel is of DISK type, the server process reads backups from or writes backups to the disk. If the channel is of sbt type, the server process reads backups from or writes backups to a third-party media (e.g., tape). Channels are always able to read and write backups to and from a disk regardless of their type.
Updated: 01/09/2007
|
|
|
The Recovery Manager (RMAN) provides the CONFIGURE RETENTION POLICY command to create a persistent and automatic backup retention policy for controlling how long backups and copies should be retained. When a backup retention policy is in effect, RMAN considers the backups and copies of data files and control files as obsolete (i.e., the backups and copies are no longer needed for media recovery), according to the criteria specified in the CONFIGURE RETENTION POLICY command. The REPORT OBSOLETE and DELETE OBSOLETE commands can be executed periodically or regularly to view obsolete files and to delete them, respectively.
Updated: 01/09/2007
|
|
|
The Oracle Net software is comprised of certain communication layers (programs), collectively known as a stack, which enable clients and database servers to share, modify, and manipulate data. The stack architecture is based on the Open Systems Interconnection (OSI) model.On the client side, from top to bottom, the stack is constructed with the following communication layers.
Updated: 01/09/2007
|
|
|
This article is a quick summary of basic SQL commands with a little touch of Oracle to prepare for application development.In the previous article, you were given you a rough idea of the design and development issues that are involved in creating a database in Oracle 9i.
Updated: 07/18/2006
|
|
|
I was impressed when Doctor Janusz Getta agreed to conduct an interview with me in relation to Oracle. I know how hard the life of a lecture is and to take the time to answer my questions was great to see. I have sat down to many of his lectures and found them extremely useful in the work I do today.
Updated: 07/18/2006
|
|
|
Oracle Listings
|
|
Total:
13 | Displaying: 1 - 10 | Pages: 1 2 >> |
|
|
