Vi ste ovdje
Overview/Description
Oracle Database 11g Release 2 offers a unique scale-out technology with a single database instance, lower server and storage costs, and increased availability and scalability. It also provides customers with improved user service levels, reduced down-time, and more efficient use of IT resources as well as an increased level of performance and security. In addition it provides business intelligence and data warehousing. This course demonstrates how to install the Oracle Grid Infrastructure, use ASMCA to create disk groups, and create and manage ASM volumes and the Cluster...
Overview/Description
Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource Manager the DBA has the ability to optimize resource allocation among many...
Overview/Description
Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented automatically, which can sometimes cause lock conflicts. Lock conflicts can be detected and managed through Enterprise Manager or SQL statements. Managing undo data and implementing Oracle Database security are also important DBA roles. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction...
Overview/Description
General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database 11g Release 2, including elements such as Automatic Workload Repository (AWR) and database health checkers. DBAs must make sure that databases are open and available to users when they need it and that it is working without bottlenecks by gathering performance metrics. This course explores how to specify, review, and maintain audit information. It also discusses how to use...
Overview/Description
Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which includes the hardware and software infrastructure needed to meet your requirements. This course explores the database's memory structures, focusing on how to configure SGA parameters and how to implement Automatic Memory Management and Automatic Shared...
Overview/Description
By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control over various aspects of scheduling, such as job windows and prioritizing jobs. This course explains how to configure the Database Resource Manager to access and create resource plans, create, configure, and administer consumer groups, as well as activate a...
Overview/Description
To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace space usage, and reclaim wasted space from tables and indexes by using the segment shrink functionality. Using the segment advisor, resumable space allocation, and moving tablespaces are also covered. This course will also explore how to duplicate a...
Overview/Description
From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also required to ensure that the database is up-to-date with the latest patches and that critical errors are resolved, which includes contacting Oracle for support. This course explores how to move data using Data Pump Wizards or the command line. Working with the Enterprise Manager Support Workbench, My Oracle Support, service requests, and patch management are...
Overview/Description
Oracle Database 11g Release 2 offers more advanced data warehouse, partitioning, security and network feature enhancements to allow the DBA to provide a more efficient way for users to access data in a secure environment. This course covers the enhanced data warehouse and partition enhancements, which includes support for loading data stored in compressed files, new parameters for simplified parallelism implementation, and new partitioning methods. It also covers the security and networking enhancements, including how to use SecureFiles, the password file, default...
Overview/Description
Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing it from a central location, and running PL/SQL on a remote database as a job. Oracle Database 11g Release 2 also offers backup to Amazon S3 through the Oracle Secure Backup module, this offers a low-cost database backup Web services storage option...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
