Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


481: Enterprise-class OLAP Products
Enterprise-class OLAP can be cross-sectoral data closer together, so that all users of the information in a common basis. It helps the user to use all of the data warehouse data. In addition, enterprise-class OLAP data warehouse can also go beyond t...

482: Summary of data warehouse products
A recent survey revealed that over 90% of large and medium-sized warehouse will be established this year. According to IDC's report, about 80% have invested in data warehousing company that was a great success. Why? Data warehouse and OLTP syste...

483: Application Server additional features
ODBC plug-ins Accepted standards of instruction ANSISQL return results formatted HTML forms can be linked to any ODBC database specifications of any plug-ins can be called through ICX Transaction support CORBA OTS transaction support in support o...

484: Application Server detailed list
In line with the ORB of the CORBA 2.0 standard Services in line with the WRB as the standard CORBA object services in support of CORBAIIOP Support distributed Listener (listener) and distributed application architecture Java environment By CORBA...

485: The main features of Application Server
Plug-in (Cartridge)-based application environment Support the application of fully distributed Can be combined with any HTTP server Any language can be used to develop applications Automatic redirection server (redirection) Process (Process) co...

486: Application Server Product Introduction
Web application platform strategy When enterprise applications into the network computing, standardization of the application server will become a necessary component of the support software, to run shared applications, from the Client / Server env...

487: Oracle 8i New Features
Internet computing Java ● WebDB, used to create, deploy and monitor Web application ● iMedia ● ● OracleInternet file system database JavaVM ● Java stored procedures, functions and triggers ● In Java, SQL and PL / SQL ● seamless inte...

488: Characteristics of Oracle 8i
Simplicity of operation Oracle 8i fundamentally improved Oracle application installation, configuration and manageability. Oracle Universal installer (Universal Installer) and Database Configuration Assistant (Database Configuration Assistant) are ...

489: An overview of Oracle 8i
Internet computing environments Web Information Management Oracle8i contains the Oracle WebDB. Oracle WebDB is a for the establishment, deployment, and flexible monitoring Web database applications and content-driven Web site solution. HTML throug...

490: Examples of table space for performance optimization
Combined form of the free space area Table space in the use of the course there will be a free zone, which will affect the performance of the system. Table space is free zones will merge small adjacent area into a complete free large free area, the...

491: Examples of performance optimization index
After the establishment of a good index of the implementation of a certain period of time, the index block and thus prone to debris impact on system performance. Administrators can block on the index compression, index index reorganization to optimi...

492: Examples of performance data sheet
Data Sheet No matter what kind of use of storage technology, after a certain period of time after the operation and conduct of business in the storage space will have some "debris", resulting in performance degradation. In addition, due to...

493: Performance analysis tools
The use of performance planner Performance Planner (Capacity Planner) is an integrated package in the Oracle Enterprise Manager (Oracle Enterprise Management Packs) used to reflect the parameters of system performance tools to collect, you can spec...

494: Hot-line backup and restore combat
The characteristics of online backup Online backup, also known as hot backup, the backup, the database user can operate, therefore, corresponds to the physical database file is constantly changing, the content of these physical file is the update h...

495: Logical backup and recovery of actual combat
The logic of the premise of backup and recovery 1. The state of the database work in the archive 2. To the database administrator privileges granted to roles (1) as shown in Figure 12.2, editor of the user's role】 【tab. (2) can be used i...

496: Offline backup and restoration of combat
Offline backup (1)】 【Enterprise Manager routines in the closure of the database. (2) the use of computer】 【Explorer to find the relevant documents and databases. As shown in Figure 12.1. (3) to initialize the database file is located in c...

497: Oracle 9i backup and recovery mechanism
The contents of backup and recovery 1. Initialization parameter files 2. Control file 3. Data files 4. Online redo log files 5. Archive log files Backup and recovery methods and tools 1. Logical backup and recovery A tool for the realization...

498: Database failure and the restoration of the principle of common
Principle of system failure and recovery System failure was mainly due to the server is running, suddenly the operating system error, power failure caused the disruption of non-normal, the user database is a matter to be suddenly interrupted, the d...

499: Storage Management - Oracle 9i Core depth
─ ─ brain control file Document the role of control Control document (1) as shown in Figure 11.1. (2) appears as shown in Figure 11.2 of the editorial control of documents】 【General Information tab. (3) Figure 11.3 shows the control fil...

500: Examples of how to implement procedures
Operation on the server (1) to system users, SYSDBA logged】 【SQLPlus Worksheet, the implementation of document creategraduateuser.sql create a user graduateuser. (2) create a data table createtablegraduateinfo.sql document graduateuser.graduat...


Page 25 of 37
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]