Oracle

1 : Using initialization parametersUse the initialization parameter db_block_checksum\db_block_checking to set the physical and logical consistency checks for a database block. Db_block_checksum: Physical consistency check, enabled by default. The

This paper is implemented by EXP/IMP, the database table space needs to be in read-only mode, and for the production database of real-time application, it can be used to transfer table space using Rman method.The following restrictions apply to the

http://blog.csdn.net/xiaoyao6650/article/details/4027041View Processes#当前的连接数Select COUNT (*) from v$process;#数据库允许的连接数Select value from v$parameter where name = ' processes ';#查看连接配置信息Show parameter processes;#修改Connection number alter system set

1. static sqlsql and dynamic SQLThe Oracle compiled PL/SQL program block is divided into two types: one for the pre-assembly (early binding), that is, the SQL statement is determined during program compilation, most of the compilation is of this

The database connection string for Oracle. Private Const String connstring = The 192.168.1.210 is the IP address of the Oracle database server1521 is the default port numberSERVICE_NAME=ORCL means that the Oracle

Checking Operating System requirements ...Expected Result:one of Redhat-3,redhat-4,suse-9,asianux-1,asianux-2Actual result:redhat-4Check complete. The overall result of this check is:passed=============================================================

In my development of the BS structure program, because of the frequent need to process some large-capacity text data in Oracle, so after repeated testing and finally with ASP successfully solved the large text data under Oracle access problem. 　　 　

The Redo log (redo log) is controlled by the LGWR. Oracle does not immediately modify the data block for DML operation data, but produces redo records and logs it to the online redo log, when redo log is full, or the global checkpoint is started, or

One, in the configuration file, the Oracle connection string is stored1. Connection string:"Data source=127.0.0.1/test;user id=xxx;password=xxx;provider= ' oraoledb.oracle '"2.provider[providers], there are two kinds: ' oraoledb.oracle ' for Oracle,

How to bypass the password settings for Oracle snooping:1. Locate the listening process PID and kill itPs-ef|grep TNS[Email protected] admin]$ Ps-ef|grep TNSRoot 9 2 0 Jul11? 00:00:00 [Netns]Oracle 29668 1 0 10:12? 00:00:00/oracle/bin/tnslsnr

The previous article http://www.cnblogs.com/valiant1882331/p/4056403.html wrote too long, so I changed an article, link the previous section to continue Concatenation of strings MySQL can use" + "to splice two

The difference between Oracle dynamic registration and static registration: Dynamic monitoring does not require any information about the data to be recorded in the Listener.ora file, only the configuration information of the listener is written to

Oracle archive logs are typically generated by DML statements, so increasing too quickly should be DML too frequentlyStart by querying the following daily archives:Select TRUNC (first_time) "Time",SUM (Block_size * BLOCKS)/1024/1024/1024 "SIZE

I. OverviewIn the company, we often face a situation. After we have worked out the operation of the database, we can not execute it on the real database, we need to test it in the standby database, the data on the backup data and the real database

In Oracle, an empty string is treated as NULL, and any value with a null comparison result is null. As a result, an exception occurs when you compare two strings. Take a look at the following example:declare     I VARCHAR2: = null;    v VARCHAR2

Http://www.linuxidc.com/Linux/2014-02/97335.htmThe first two days of leadership gave a live, database migration, the original system is used by the Oracle database, now to change to MySQL, then did not think about the next, the original system with

Oracle _ constraints constraintZookeeper Oracle _ constraints constraint ① What are constraints?1 constraint is mandatory at the table levelThere are five constraints:NOT NULLUNIQUEPRIMARY KEYFOREIGN KEYCHECKNotesIf no constraint name is specified,

How to Restore Archive logs from a backup set in oracle How Does oracle capture archived logs from the backup set? In Dalian Hospital, the database is archived. However, after archiving, rman uses crontab to automatically archive the logs and

Tutorial on manually deleting a database in Oracle 1. manually delete a file system database 1. Stop listening and OEM The Code is as follows: $ Lsnrctl stop listener_name $ Emctl stop dbconsole 2. Obtain information about data files, log files, and

An error ora-28056 is reported when an oracle instance is started in windows In oracle in windows, when an instance is started, it will write startup information to the event viewer of the windows operating system-Application Part, in addition,