Oracle

When checking the backup output script in the database today, an error occurred in the Rman backup. This article traces the error message and looks for directions to locate the problem. According to the previous problem description, the problem is

Database fragmentation is a major factor in database performance and should be discovered and defragmented in a timely manner. First, how the debris is produced When a database instance is created, it is divided into multiple logical segments

Oracle 10g introduced the concept of the temporary tablespace Group (temporary tablespace Group), which allows users to take advantage of multiple temporary tablespace spaces simultaneously in different sessions. 1. Main features of the temporary

You can define one or several autonomous transactions in a transaction (outer transaction). Autonomous transactions can be commit independently and do not have an impact on external affairs, and the rollback of the same outer transaction has no

The Oracle tutorial being looked at is: analysis and resolution of Oracle Common error codes (iii). Ora-00600:internal error code,arguments:[num],[?],[?],[?],[?] Reason: This error is usually an internal error of Oracle and is only useful for OSS

Many DBAs are still at Oracle 9i or 10g, possibly because of the Oracle 11g price issue. This article will explain the installation of Oracle 11g under Windows 7, and I hope you can see some of the new features of 11g. Recently unloaded their own

Oracle database user name and password (Linux for example), the need for friends can refer to the next. Preparatory work before modification: Use the SSH tool to connect to the server as rootThen switch to Oracle User: Su-oracle (carriage

The index quality has a direct impact on the overall performance of the database. A good quality index allows database performance to be upgraded at a quantitative level, while inefficient, redundant indexes make database performance slow, even with

Method One: Use the Pl/sql Developer tool to export:Menu bar---->tools---->export Tables, the following figure, set the relevant parameters can be: Method Two: Use CMD's Operation command to export, the details are as follows:The

The federated Array was formerly called the Pl/sql table. Federated arrays cannot be used in tables and can only be used as a structural body for programming. Federated arrays can only be accessed in Pl/sql. It is important to note that some of the

oracle| function (author: Star Prodigal zhongcfido@126.com) Ocidefinebyname Allow the SELECT command to use PHP variables. Syntax: boolean ocidefinebyname (int stmt, string ColumnName, mixed &variable, int [type]); Return Value: Boolean

oracle| Data | database Java interface with Oracle: Running Java in a database can be said to be the most exciting new feature of Oracle8i. In the application you created to use the Oracle8i database, you can use new Java-related features to easily

Oracleenterprisemanager (Oracle Enterprise Manager, abbreviation OEM) provides management services for managing distributed environments through a set of Oracle programs. OEMs include a set of DBA tools, a repository, and a graphical display of the

One, the shared server mode work mechanism: Shared server mode (also known as the MTS Multi-threaded server): After the database is started, there are two more processes than the dedicated server mode, one is the dispatch process (dispatcher)

1. Basic Database Information Version information: Sql> select * from V$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-prod Pl/sql Release

Look at a simple example: Sql> CREATE TABLE T as 2 SELECT * from Dba_objects; Table has been created. Sql> SET Autot on Sql> SELECT COUNT (*) from T; COUNT (*) ---------- 49611 Execution plan ------------------------------------------------

First, the preparation of logical standby 1, confirm the operation of the object and statement can be logically standby support Because the logical standby is to maintain synchronization with the primary database through SQL applications. SQL

Through the previous introduction we know that the main line link is due to the db_block_size of the database is not large enough for some large fields can not be stored in a block, resulting in a row link. For row links We have nothing to avoid

Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison. First, compare the difference between exp general mode, exp direct path mode, and EXPDP three ways

http://www.ohsdba.cn/index.php?g=Home&m=Article&a=show&id=171 time: 2016-10-09-00:40:04 | Author: ohsdba | 中文版If not noted, this site is the original article. Welcome reprint, please indicate the source and author information when reproduced. DTrace