Oracle database administration

Cài Oracle cần như sau: 1. Tạo 2 Groups: đặc tên là oinstall và dba 2. Tạo 1 User account tên là: oracle (note: Đúng ra đặt là Tí Tèo gì củng được, nhưng conventional, thấy thiên hạ cài Oracle hay đặt là vậy.) Login as root, run: � # groupadd oinstall # groupadd dba # useradd -m -g oinstall -G dba oracle Tạo password cho user: oracle # passwd oracle Changing password for user oracle. New UNIX password: Retype new UNIX password: passwd: all authentication tokens updated successfully.

7p gcsvpn 28-02-2013 63 7   Download

Redundant Arrays of Inexpensive Disks Technology (RAID)

12p trinh02 28-01-2013 56 5   Download

Small shared pool Small database buffer cache Small redo log buffer cache Missing indexes Rollback segments and undo tablespace Sort area size incorrectly set Assorted

16p trinh02 28-01-2013 54 6   Download

After completing this lesson, you should be able to do the following: Use the Oracle tuning methodology to diagnose and resolve performance problems Use Oracle tools to diagnose performance problems Understand the goals of the workshop

14p trinh02 28-01-2013 69 5   Download

After completing this lesson, you should be able to do the following: Describe different system architectures Describe the primary steps of OS tuning Identify similarities between OS and DB tuning Understand virtual memory and paging Explain the difference between a process and a thread

14p trinh02 28-01-2013 47 5   Download

After completing this lesson, you should be able to do the following: Interpret the concept of a hierarchical query Create a tree-structured report Format hierarchical data Exclude branches from the tree structure

18p trinh02 28-01-2013 45 3   Download

Auditing If an unauthorized user is deleting data, then the DBA might decide to audit all connections to the database and all successful and unsuccessful deletions from all tables in the database. The DBA can gather statistics about which tables are being updated, how many logical inputs/outputs (I/Os) are performed, and how many concurrent users connect at peak times.

16p trinh02 28-01-2013 52 9   Download

After completing this lesson, you should be able use the following datetime functions: TZ_OFFSET CURRENT_DATE CURRENT_TIMESTAMP LOCALTIMESTAMP DBTIMEZONE SESSIONTIMEZONE EXTRACT FROM_TZ TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL

20p trinh02 28-01-2013 48 2   Download

Users and Security Security domain The database administrator defines the names of the users who are allowed to access a database. A security domain defines the settings that apply to the user. Authentication mechanism A user who requires access to the database can be authenticated by one of the following: Data dictionary Operating system Network The means of authentication is specified at the time the user is defined in the database and can be altered later. This lesson covers authentication by database and by operating system only.

20p trinh02 28-01-2013 82 3   Download

This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report

14p trinh02 28-01-2013 74 4   Download

After completing this lesson, you should be able to do the following: Identify issues associated with managing users in an Oracle Shared Server environment Configure the Oracle Shared Server environment to optimize performance Diagnose and resolve performance issues with Oracle Shared Server processes

14p trinh02 28-01-2013 61 5   Download

After completing this lesson, you should be able to do the following: Monitor and size the redo log buffer Monitor and size the Java pool Control the amount of Java session memory used by a session

16p trinh02 28-01-2013 49 5   Download

Control File The control file is a small binary file necessary for the database to start and operate successfully. Each control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine whether the database is in a valid state to use. A control file is updated continuously by the Oracle server during database use, so it must be available for writing whenever the database is open. The information in the control file can be modified only by the Oracle server; no database administrator or end user can edit the control file....

16p trinh02 28-01-2013 56 2   Download

Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the catproc.sql script is run after the CREATE DATABASE command. PL/SQL packages will not be discussed within the scope of this course.

20p trinh02 28-01-2013 63 4   Download

After completing this lesson, you should be able to do the following: Implement dynamic SGA allocation Dynamically adjust the buffer caches Dynamically adjust the shared pool

12p trinh02 28-01-2013 34 4   Download

After completing this lesson, you should be able to do the following: Define the roles associated with the database tuning process Describe the dependencies between tuning in different development phases Describe service level agreements Identify tuning goals Identify common tuning problems Employ tuning activities during developmentand production Balance performance and safety trade-offs

16p trinh02 28-01-2013 49 5   Download

Before a database is created, the UNIX environment must be configured and the Oracle9i server must have already been installed. Four environment variables must be set: ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH. ORACLE_HOME is the full path to the top directory in which the Oracle9i Server is installed. The directory for ORACLE_HOME should be supplied by the person who installed the server, usually the UNIX administrator or the DBA. ORACLE_SID is a user-definable name assigned to an instance of a database.

10p trinh02 28-01-2013 62 6   Download

Course Objectives This course is the first in a series of courses that cover the core database administrator tasks. The tasks covered in this course are: Outlining the Oracle architecture Planning and creating databases Managing the memory, process, physical, and logical structures Managing database users by controlling and monitoring their actions Using the Globalization Support features

4p trinh02 28-01-2013 60 4   Download

Nơi lưu trữ tất cả thông tin được dùng để quản lý các đối tượng trong CSDL. ex: tables, views, Oracle users, functions… Được cấu trúc giống như 1 CSDL bình thường, gồm có tables và views.Read-Only.

14p trinh02 28-01-2013 65 3   Download

Workshop Methodology Group-Oriented and Interactive Structure The workshop is structured to allow individuals to work in groups to perform database backup, restore, and recovery operations. Each group is encouraged to share its approach to resolving database failures with other groups in the class. Intensive Hands-On Diagnosis and Problem Resolution The intent is to provide you with as much hands-on experience as possible to diagnose and work through backup and recovery scenarios.

18p trinh02 28-01-2013 71 3   Download