Oracle

  Introduction to the three configuration files of ORACLE Overview In the oracle installation directory $ HOME/network/admin, sqlnet is often seen. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files

  Brief Introduction Two days ago, a servlet-based file upload page was developed for the project. Oracle Jserv was used on the front-end to process the servlet page on the Apache server. The file upload function was implemented based on

  The content of this lecture includes: 1: Diagnose database performance 2: configure the automatic workload file library 3: Use a database Consultant 4: use SQL access advisor to improve database performance 5. asynchronous submission About

Oracle lock table and unlockSELECT/* + rule */s. username,Decode (l. type, 'TT', 'table lock ','Tx ', 'row lock ',NULL) LOCK_LEVEL,O. owner, o. object_name, o. object_type,S. sid, s. serial #, s. terminal, s. machine, s. program, s. osuserFROM v $

Step 1:Replace all the font. properties files in these three paths$ ORACLE_HOME/jdk/jre/lib$ ORACLE_HOME/jre/1.4.2/lib$ ORACLE_HOME/javavm/lib/ojvmfontsReplace the default files in the three directories# Cp font. properties. zh_CN.Redhat font.

1. When you assign values to NAME pinyin codes in batches, the names containing single quotation marks will be shelled.Update the NAME and copy it again.UPDATE BFBHDD8.SPSB set name = concat (SBID, 'duoge invincible ') where name like' %'2. The BFv8.

Recently, When configuring the stream replication environment for Oracle 11g, I encountered a problem. After shutting down the database (shutdown immediate), I connected the database through SQL Plus: conn sys/his @ orc0 as sysdba, the following

Methods for deleting duplicate records (experiment description ):1. The table stu contains 16 data records, including select rowid, xh, xm, sex, birthday, classid, and degree from stu. Order by xh; 2. copy the data in the stu table into two copies

Both SQL server and mysql can set the primary key auto-increment, while the oracle primary key does not have the auto-increment attribute, which can be achieved through the following two methods:1. Create a sequence through a triggerCreate

To_date () and 24-hour notation and display of mm minutes: 1. When Oracle's to_date function is used for date conversion, many Java programmers may directly use the format "yyyy-MM-dd HH: mm: ss" for conversion, however, an error occurs in Oracle:

Oracle Database lock and unlock view lock items: Table lock, row lock, etc., the following code SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK',NULL)

Oracle Database-level drop redolog is not dangerous. Some DBAs are afraid to delete the redo log in the production database, because they are worried that deleting the redolog group in the ACTIVE and ACITVE status will cause a database accident. In

Forced log archiving archive_lag_target forced archiving forced switch in the Data Guard environment, if the oracle database archiving frequency is too low, resulting in Data loss in the event of a fault, we can use the archive_lag_target parameter

Oracle SCN in-depth study I. SCN description here is a small summary. You can use the following SQL statement to view the SCN of Oracle: SQL> select CURRENT_SCN from v$database;CURRENT_SCN----------- 3713849  The preceding result returns a string

Oracle indexes refer to the data structure of ORACLE indexes in B tree structure and bitmap structure. The common indexes, reverse key indexes, and function indexes we usually use are tree structures and tree structures;The bitmap structure only has

Optimized exp/imp Import and Export speed Daquan 1. exp we know that using direct path can increase the export speed. Therefore, you can use the direct path mode when using exp. This mode has two related parameters: DIRECT and RECORDLENGTH. The

According to the test instance of Mr Jonathan Lewis, The TPCC test of Oracle found that the sort function of the cluster exists completely for the tpcc test. Non-equivalent query statements all follow the wrong plan, get the wrong result. This

Oracle backup and recovery BasicsI. oracle flash back technology the oracle flash back technology began to provide flashback queue operations in 9i, which was greatly improved in 10 Gb, added the flashback table, flashbackdrop, flashback version

Perform the following operations on the oracle analysis table: 1) Verify the storage status of the table 2) view the statistical information of the table 3) Search for the link record and migration record in the table 1) verify the storage status of

ORA-00845 Oracle cannot modify MEMORY_TARGET 1. Memory reduction causes Oracle to fail to start Last login: Sun Nov 4 15:09:06 2012 from 192.168.5.222 [oracle @ h1 ~] $ Sqlplus "/as SYSDBA" SQL * Plus: Release 11.2.0.1.0 Production on Sun Nov 4 15:26