Có 18+ tài liệu thuộc chủ đề "oca 10g"
tailieu.vn Xem trực tuyến Tải xuống
Oracle Database 10g: “g” Stands for Grid 1-6 Oracle Database Architecture 1-8. 2 Installing the Oracle Database Software Objectives 2-2. Tasks of an Oracle Database Administrator 2-3 Tools Used to Administer an Oracle Database 2-4 Installation: System Requirements 2-6. Practice Overview: Installing the Oracle Software 2-21. 3 Creating an Oracle Database Objectives 3-2. Database Configuration Assistant (DBCA) 3-5 Using the...
tailieu.vn Xem trực tuyến Tải xuống
The resources to learn more about administering Oracle Database 10g include:. Oracle by Example – Oracle Magazine. Oracle University. www.oracle.com/education. Oracle Database 10g: Administration Workshop II – Oracle Database 10g: SQL Fundamentals I &. II – Oracle Database 10g: PL/SQL Fundamentals. Oracle Enterprise Manager 10g Grid Control – Oracle Database 10g: Real Application Clusters – Oracle Database 10g: Implement Streams....
tailieu.vn Xem trực tuyến Tải xuống
Installing the Oracle Database Software. Install the Oracle software by using Oracle Universal Installer (OUI). Installing the Oracle software. Between 1.5 GB and 3.5 GB for the Oracle software – 1.2 GB for the preconfigured database (optional. ORACLE_BASE : The base of the Oracle directory structure for OFA. ORACLE_HOME : The directory containing the Oracle software. Installing the Oracle Software....
tailieu.vn Xem trực tuyến Tải xuống
Copyright © 2005, Oracle. Create a database design template with the DBCA. Generate database creation scripts with the DBCA. 3-3 Copyright © 2005, Oracle. 3-5 Copyright © 2005, Oracle. Using the DBCA to Create a Database. 3-7 Copyright © 2005, Oracle. 3-9 Copyright © 2005, Oracle. 3-11 Copyright © 2005, Oracle. 3-13 Copyright © 2005, Oracle. Using the DBCA to...
tailieu.vn Xem trực tuyến Tải xuống
Use Enterprise Manager (EM). Access a database with SQL*Plus and iSQL*Plus. View the alert log. Components SQL*Plus Init Params DB Startup DB Shutdown Alert Log Perf Views. http://edrsr9p1.us.oracle.com:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database. /u01/app/oracle/product/10.2.0/db_1/edrsr9p1.us.oracle.com_orcl/sy sman/log. http://edrsr9p1.us.oracle.com:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 10g Database Control. Oracle Enterprise Manager. Accessing Oracle Enterprise Manager. Using SQL*Plus and iSQL*Plus to Access Your Database. SQL*Plus...
tailieu.vn Xem trực tuyến Tải xuống
Tablespaces and Data Files. Data files:. Data files
tailieu.vn Xem trực tuyến Tải xuống
After completing this lesson, you should be able to do the following:. Create and manage database user accounts. Create and manage roles. Create and manage profiles. Implement standard password security features – Control resource usage by users. Database User Accounts. Each database user account has:. Role Profile. PW Security Quota. Database User Accounts Full Notes Page. The SYS account:. Is...
tailieu.vn Xem trực tuyến Tải xuống
Full Notes Page. Naming Database Objects Full Notes Page. Specifying Data Types in Tables Full Notes Page. Creating and Modifying Tables Full Notes Page. Understanding Data Integrity Full Notes Page. Constraint States Full Notes Page. B-Tree Index Full Notes Page. Bitmap Indexes Full Notes Page. Index Options Full Notes Page. WHERE l.country_id = c.country_id AND c.country_id in ('AU','BR');. Creating a...
tailieu.vn Xem trực tuyến Tải xuống
Copyright © 2005, Oracle. 8-2 Copyright © 2005, Oracle. Identify and administer PL/SQL objects. 8-3 Copyright © 2005, Oracle. UPDATE employees SET SALARY=6000 2 WHERE EMPLOYEE_ID = 9999;. 2 WHERE EMPLOYEE_ID = 9999;. SQL PL/SQL Locks. 8-4 Copyright © 2005, Oracle. 8-5 Copyright © 2005, Oracle. 8-6 Copyright © 2005, Oracle. 8-7 Copyright © 2005, Oracle. 8-8 Copyright © 2005,...
tailieu.vn Xem trực tuyến Tải xuống
Managing Undo Data. Explain DML and undo data generation. Monitor and administer undo data. Describe the difference between undo data and redo data. Configure undo retention. Guarantee undo retention. Undo Data. Undo data is:. Transactions and Undo Data. Undo information is stored in undo segments, which are, in turn, stored in an undo tablespace. writable undo tablespace for a given...
tailieu.vn Xem trực tuyến Tải xuống
Apply the principle of least privilege. Maintain the audit trail. Requirements Least Privilege Auditing. Principle of Least Privilege. Least Privilege Auditing. Applying the Principle of Least Privilege. Apply the Principle of Least Privilege Full Notes Page. Standard database auditing. Value-based auditing. Requirements Least Privilege. Audit trail Parameter. Generate audit trail.. Standard Database Auditing. Maintain audit trail.. ALTER SYSTEM SET audit_trail=“XML”...
tailieu.vn Xem trực tuyến Tải xuống
Create Oracle Net Service aliases – Configure connect-time failover – Control the Oracle Net Listener. Use tnsping to test Oracle Net connectivity. Oracle Net Services. Application Oracle Net. RDBMS Oracle Net Client or. Oracle Net configuration files Oracle Net. Oracle Net Listener. Oracle Net configuration files Enterprise. To make a client or middle-tier connection, Oracle Net requires the client to...
tailieu.vn Xem trực tuyến Tải xuống
Manage the Automatic Workload Repository (AWR). Automatic Workload Repository (AWR):. Optimizer Statistics. Automatic Workload Repository . Manage the Automatic Workload Repository
tailieu.vn Xem trực tuyến Tải xuống
13-2 Copyright © 2005, Oracle. Tune SQL by using the SQL Tuning Advisor. Use Automatic Shared Memory Management (ASSM). 13-4 Copyright © 2005, Oracle. 13-6 Copyright © 2005, Oracle. 13-8 Copyright © 2005, Oracle. SQL Tuning Advisor: Overview. Comprehensive SQL tuning. SQL Tuning Advisor. 13-10 Copyright © 2005, Oracle. SQL Tuning Advisor Options and Recommendations. Using the SQL Tuning Advisor....
tailieu.vn Xem trực tuyến Tải xuống
Data file #2 Data file #3 Data file #4 Data file #5 Data file #1. Data file #6 Image copies. Data file #1 Data file #2 Data file #3 Data file #4 Data file #5 Data file #6
tailieu.vn Xem trực tuyến Tải xuống
16-2 Copyright © 2005, Oracle. After completing this lesson, you should be able to recover from the loss of a:. Control file. Data file. 16-4 Copyright © 2005, Oracle. Use Database Control to alter the instance’s status.. 16-6 Copyright © 2005, Oracle. After the instance is open, it fails in the case of the loss of:. A data file belonging...
tailieu.vn Xem trực tuyến Tải xuống
Describe Flashback Database. Restore the table content to a specific point in the past with Flashback Table. Overview Database Table Drop Query Versions Transaction. Table Drop table Drop Recycle bin True. Flashback Database brings the database to an earlier point in time by undoing all changes made since that time.. Flashback Table recovers a table to a point in time...
tailieu.vn Xem trực tuyến Tải xuống
Use SQL*Loader to load data from a non-Oracle database (or user files). Explain the general architecture of Data Pump. Use Data Pump Export and Import to move data between Oracle databases. SQL*Loader Data Pump - Export - Import. Data Pump DBMS_DATAPUMP. Data/Metadata Movement Engine SQL*Loader. SQL*Loader: Overview Directory Obj.. Input data files Control file SQL*Loader. SQL*Loader Overview Full Notes Page....