Articles for Oracle 10g New Feature for Oracle 8i Ocp 1Z0-045
How to start a LogMiner?
LogMiner can be started using the overloaded START_LOGMNR procedure.
BEGIN
-- Start using all logs
DBMS_LOGMNR.start_logmnr (
dictfilename => 'C:\Oracle\Oradata\TSH1\Archive\TSH1dict.ora');
END;
/
The analysis range can be narrowed using time or SCN.
BEGIN
-- Specify......
continue reading "How to start a LogMiner?" »
OCP 1z0-045 Short Notes: Exam passing tips
General high availability technologies in 10g
The ORDER BY clause sorts the records in ascending order and it comes last in the SELECT statement.
The Online redo log files and the operating system flat file are used to store a copy of a data dictionary.
RMAN can be used to take an......
continue reading "OCP 1z0-045 Short Notes: Exam passing tips" »
Recovery Manager (RMAN)
Database recovery plays a very critical, crucial role in the management of a database. The recovery manager (RMAN) is an Oracle utility that provides an easy way to recover the database. The RMAN was originally introduced in Oracle 8i. Gradually, it has been improved with the increase in demand......
continue reading "Recovery Manager (RMAN)" »
The advisory framework
Advisors are a collection of services provided by Oracle that help in the maximum utilization of available resources. They are the server side components that provide feedback on the resource utilization and performance of a database. Within a database, the advisors work on particular subsystems......
continue reading "The advisory framework" »
The The Automated Database Diagnostic Monitoring (ADDM) Alerts
There are two methods of database maintenance and performance maintenancemonitoring, which are as followsthe following:
Reactive method.
Proactive method.
Oracle 10g has provided the new feature of proactive method of database maintenance and performance monitoring. With the......
continue reading "The The Automated Database Diagnostic Monitoring (ADDM) Alerts" »
THE CONTROL FILE
Introduction:
A control file is the most critical component of a database, as it stores important information that is not available in any other file. It is a small binary file that records the physical structure of a database and defines its current state. A database is mounted using a......
continue reading "THE CONTROL FILE" »
Tip on iSQL*Plus.
Each iSQL*Plus statement can be terminated by either a semicolon (;) or a forward slash (/). However, iSQL*Plus also permit SQL statements to execute without the semicolon (;) or the forward slash (/)....
continue reading "Tip on iSQL*Plus." »
Tip on using the SORT_AREA_SIZE parameter.
Oracle does not recommend using the SORT_AREA_SIZE parameter to enable automatic sizing of SQL working areas, unless the instance is configured with the shared server option. However, the PGA_AGGREGATE_TARGET parameter is recommended. The SORT_AREA_SIZE parameter is retained for backward......
continue reading "Tip on using the SORT_AREA_SIZE parameter." »
Upgrade previous releases of Oracle 10g
A database can be upgraded from a previous version to use the new features that it offers by following the upgrade process. It is recommended that first use a test database for planning and testing the database and thoroughly check the various application features. Oracle 10g has the following......
continue reading "Upgrade previous releases of Oracle 10g" »
What is an ASM instance?
An ASM instance is a special type of storage management interface software. It is used by Oracle to manage ASM by managing disk groups....
continue reading "What is an ASM instance?" »
In Stock (
US$ 79.99 63.98
)
Download and try this PrepKit for free. As soon you place the order, we will send you the registration code. Use it to unlock the PrepKit and start learning. Its that easy!
1Z0-045 PrepKit at a Glance
| Includes | Free | Buy |
|---|---|---|
| Version | 8.01.05 | |
| Practice Tests | 1 | 5 |
| 30 | 313 | |
| Quiz | 15 | 125 |
| Final Test | No | Yes |
| Articles, How Tos.., Tips | Yes | Yes |
| Study Notes | 15 | 255 |
Tips and How Tos for 1Z0-045 exam
