Oracle

Oracle databases are widely used in different geographies, so it is important for professional Oracle personnel to understand how network connectivity affects database performance. TNS provided by Oracle allows for allocation of traffic in each

The biggest difference between a SQL Server database and an Oracle database is the design of the table space. Oracle database pioneered the design concept of table space, which has made an indelible contribution to the high performance of Oracle

The DBA maintains a portion of the database that is often a concern when Oracle alert logs are in use. However, the alarm log is stored in the form of a text file, accumulating in chronological order of time, and Long, it is bound to cause the

Starting with Oracle 10g, Oracle provides a new feature for automatic SGA management (ASMM, or automatic Shared Memory Management). The so-called asmm, means that we no longer need to manually set the shared pool, buffer pool and other memory pool

Oracle Data Import Export IMP/EXP Features: Oracle data Import Export IMP/EXP is equivalent to Oracle data restore and backup. In most cases, you can use an Oracle data import export to complete the backup and restore of your data (without causing

Sql*loader principle Sql*loader is a tool provided by Oracle for data loading, it is more suitable for business analysis type database (Data Warehouse), can handle multiple format flat files, bulk data loading is more efficient than traditional

Pga The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA

1, Application development (application Development) Sql*plus E:\Oracle\Ora81\BIN\SQLPLUSW. Exe 2. Database management (DB administration) DB Configuration Assistant Database Configuration Assistant: Creating, configuring, and deleting Databases

There is a need to transfer a record of a business table before a point in time to its history table. If the current business table is not based on the partition table settings for this business point in time, it can only insert and delete

1. Variable 2. Constant 3. Basic program Structure and statement Pl/sql can reside in both Oracle database servers and Oracle development tools environments. In both environments, the Pl/sql engine accepts any pl/sql block and subroutine as input,

(1) The basic syntax for creating a table is as follows: CREATE TABLE TableName (columnName dataType [default Expression][column columnstraint],... N) [tablespace Tablespacename] (2) The basic syntax for modifying a table is as follows: ALTER

Oracle Profiling Functions Overview Profiling functions in Oracle are similar to aggregate functions, but for each set of records, no matter how many rows, the aggregate function returns only one row of values, and the parse function returns a

The problem extended from a customer's real optimization case. A customer's database needs to be optimized, but because the program developer is not involved, this optimization cannot be modified for SQL. Database-level adjustments generally have

From the database to guide a data when there is a very strange problem, Chinese garbled. First of all, it can be confirmed that the data in the database is in Chinese, there is the use of toad to connect the query is also Chinese. But after the

Tspitr (tablespace point-in-time recovery) is used to restore one or more tablespaces to the state of a point in the past, while other tablespaces remain in place. Tspitr Related concepts and terminology: (1) tspitr (tablespace point-in-time

Experiment Description: (1) Create 2 table spaces first. Create Tablespace User01 DataFile '/opt/oracle/oradata/ocp/user01.dbf ' size 1M; Create Tablespace User02 DataFile '/opt/oracle/oradata/ocp/user02.dbf ' size 1M; (2) Create a table on

Several project groups have already started using Oracle's Full-text indexing. Oracle's lexical analyzer is not smart enough for the lexical analysis of the ZHS16GBK character set, and can only be mechanically matched to the word unit. There is a

1. Install Linux (RedHat Linux6.2). Note Select "Expert mode (expert)" To manually increase the network card. (for the specific settings of the network parameters, depending on the situation). About partitions: /boot:16 M (should be at the front of

In the installation directory, such as: E:\Oracle\Ora81\network\ADMIN under the use of WordPad or Notepad to open the Tnsname.ora file, the contents of the file may be as follows: TEST. softone.com = (DESCRIPTION = (Address_list = (address =

Absrtact: The development of dynamic SQL program is summarized, and some development techniques are given according to the author's actual development experience. Key words: Dynamic Sql,pl/sql, high performance 1. static sqlsql and dynamic SQL