Overview/Description Monitoring or auditing should be an integral part of your security procedures. Oracle Database 11g includes auditing tools for database, user, and fine-grained auditing. This course explores how to implement basic database auditing, privileged user auditing, DML and DDL auditing, and how to send audit records to the operating system files. Implementing fine-grained auditing (FGA), maintaining FGA policies, implementing an FGA audit event handler, and reading FGA audit events from the FGA audit trail are also covered. Target Audience Database administrators, security...

Overview/Description To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I Expected Duration (hours) 2.7 Lesson ObjectivesOracle Database 11g: Database Performance and Space Management...

Overview/Description Oracle Database server is highly secure, but to fully maximize the security features offered, the database must be well protected as well. This course explores how to configure Oracle Database 11g in a secure manner by adhering to industry standard best security practices for operational database deployments. It covers applying the principle of least privilege to the database, locking and expiring default user accounts, changing default user passwords, creating strong passwords, enforcing password management, and protecting the data dictionary. Target Audience Database...

Overview/Description To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I Expected Duration (hours) 2.2 Lesson...