Results for DAY


1 to 20 of 863 results. Prev  Next
Results per page:   20  | 40 | 60


2 Day DBA, 10g Release 1 (10.1)

Contents

ContentsTitle and Copyright Information Send Us Your Comments Preface Audience Documentation Accessibility Structure Related Documentation Conventions 1 Introduction About this Book What this Book is Not How to Use this Book with Related Material The Oracle Database Common Oracle DBA Tasks Tools for Administering the Database 2 Installing Oracle and Building the Database Overview of Installation Checking

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

day (IN)Day value.

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

day (OUT)Day value returned.

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

day (IN)First day of week named by this is returned.

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

day (IN)Day value to be set.

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Managing Standalone SubprogramsProcedures and functions do not have to belong to a package. Program units that are created outside of a package are called standalone subprograms. You can use Enterprise Manager to create, modify, compile, and delete standalone subprograms just like packaged subprograms except that they do not have a parent package (and, consequently, no navigation path in Enterprise Manager from or to the package

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Overview of Oracle Backup and RecoveryThe focus in Oracle backup and recovery is generally on the physical backup of database files, which permit the full reconstruction of your database. The files protected by the backup and recovery facilities built into Enterprise Manager include datafiles, control files, server parameter files (SPFILEs), and archived redo log files. With these your database can be reconstructed. The backup mechanisms

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Setting Preferred CredentialsYou can have Enterprise Manager automatically fill in host and database login credentials for you, such as when you schedule jobs and tasks to perform administrative operations like backup and recovery. For security, Oracle stores preferred credentials in encrypted mode. To set preferred credentials for the database, do the following: From the home page, click Preferences at the top of the page. The

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Installation ChoicesThe Oracle Universal Installer guides you through an interview phase that asks you to specify your choices for installation and database creation. The exact sequence of steps depends on your operating system. The installation choices you can make are divided into basic and advanced. During a Windows basic installation, you need only make basic choices. For all other cases, including Windows advanced

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Loading Data Into TablesYou can use Enterprise Manager to load data into tables in batch. Batch loading is useful when you have a lot of data. You can load data from operating system files or from other databases. You can also export data into files. For loading data with Enterprise Manager, one method is to use control (.ctl) and data (.dat) files. These files are formatted as standard S QL*Loader files. The following example

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Upgrading the Database Using the Database Upgrade Assistantby Example (OBE) has a series on the Oracle 2 Day DBA book. This OBE steps you through the tasks in

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Navigational FeaturesNavigational features of Oracle Enterprise Manager include the following: Property pages on each home page help you organize management tasks into distinct categories; for example, click Maintenance to perform tasks associated with backing up and maintaining your data. Figure 3-1 Database Home Page Navigational Property Pages Description of the illustration hp-propertypages.gif Drill down links that

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

6 Managing Database Storage StructuresThis chapter discusses using Enterprise Manager to explore and manage the storage structures of your database. This chapter contains the following topics: Exploring the Storage Structure of Your Database Common DBA Tasks for Managing Database Storage Managing Undo for Your Database Making Changes to the Database Storage Structure Storage: Oracle by Example Series

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

Control FileA control file tracks the physical components of the database and other control information. It is essential to the functioning of the database. Because of this, Oracle recommends that the control file be multiplexed. In other words, it should have multiple identical copies. For databases created using DBCA, three copies of the control file are automatically created. If any control file fails, then

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Managing TablesTables are the basic unit of data storage in an Oracle database. They hold all user-accessible data. Each table has columns and rows. In an employee table, for example, there can be (vertical) columns called employee and employee number. Each (horizontal) row in the table would contain a value for employee and employee number.

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Starting DBCADuring installation, you can create and configure a new database. If you have already done so, you do not need to read this section and can skip to the next chapter. However, if you choose to install software only and later create a database, or if you want to create additional databases using the release software that you just installed, you can do so by using the Database Configuration Assistant

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting i SQL*Plusi SQL*Plus is the Web version of SQL*Plus. Before you can connect to it with a URL, you must start the i SQL*Plus application server. To do so, enter the following at the command line: isqlplusctl start After the server is started, you can connect to i SQL*Plus with a URL such as http://machine_name:5560/isqlplus Alternatively, you can connect to i SQL*Plus using Enterprise Manger. To do so from the

2 Day DBA, 10g Release 1 (10.1)

4 Configuring the Network Environment

Starting and Shutting Down the ListenerThe Oracle listener is set up to start automatically whenever your server machine is restarted. However, when your system encounters unforeseen circumstances, or when you have manually stopped the listener, you can restart it at the command line. To do so, use the following: lsnrctl start You can use Enterprise Manager to stop the listener. To do so, navigate to the Listener: listener_name page by

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Viewing TablesTo view a table, click Tables on the Administration page of Enterprise Manager. The Tables property page appears as in Figure 8-3. Figure 8-3 Tables Property Page Description of the illustration tables.gif Initially, you see the tables for the schema that you are logged into. To see tables in other schemas, click the flashlight adjacent to the Schema box to select another schema, then click Go to

2 Day DBA, 10g Release 1 (10.1)

10 Monitoring and Tuning the Database

10 Monitoring and Tuning the DatabaseMonitoring the health of a database and ensuring that it performs optimally is an important task for a database administrator. This chapter discusses the features and functionality included in Oracle Database that make it easy to proactively monitor database health, identify performance problems, and implement any corrective actions. The following topics are covered: Proactive Database Monitoring


Was this page helpful?