Oracle

"Oracle Database entity generation Tool For Winston". Refer to the original Winston Tool DBToEntity.(Note: This tool was designed and developed by our boss "feather fan towel". Thanks again for providing us with such a good development auxiliary

1. Create a directory for storing iso images or Cd content [Root @ hanxi-workstation hanxi] # mkdir/home/hanxi/yum Copy all files in the CD media or iso image file to the Created directory (/home/hanxi/yum ). For a CD, run the following

When I started my database today, I found that the database can only be mounted and cannot be opened. The following error message is displayed: SQL> select open_mode from v $ database; OPEN_MODE----------MOUNTED SQL> alter database open;Alter

Some beginners often do not use the option when creating indexes in Oracle databases. In fact, sometimes you can use some options in a suitable situation to increase the index creation speed. For example, to import data in large batches, we often

When the CPU usage of the Database Host is too high several times, the alarm is reported, resulting in low performance of the host. After some investigation, the cause of the problem is found out and the fault is solved. The specific process is as

  Overall explanation: DML (data manipulation language ): They are SELECT, UPDATE, INSERT, and DELETE, just like their names. These four commands are used to operate the data in the database. DDL (data definition language ): DDL is more than DML.

How to configure Oracle listener. ora file Oracle listener is an important database server component and plays an important role in the entire Oracle architecture. Listener Lisener FunctionFrom the current Oracle version, Listener is mainly

When Will instance recovery be generated after in-depth analysis of instance recovery? When your database server suffers an abnormal power failure, instance recovery will occur when you restart the database. Instance recovery is automatically

[Oracle] database security-audit Oracle audit is an afterthought task. After a database security problem occurs, you can trace the source of the problem to locate and discover it. Oracle audit mainly includes the following three parts: Trigger-based

Oracle Cursors syntax summary about Oracle Cursors syntax summary, Oracle Cursors is used to query the database, get a record set (result set) pointer, allows developers to access one result set at a time and perform operations on each result set. 1.

The size limit of a single data file in the oracle database. For example, if you see an error, you may think that the size of the data file conflicts with the restriction rules, because you have learned some related knowledge before, I was a little

A note from Data Guard Broker recently used A Broker to configure and manage Data Guard (Oracle version: 10.2.0.1.0). Earlier databases basically did not set db_domain. When database link is used, global_names = true is enabled, and db_domain is

Note: oracle FAQ listening problem: the listening service is the most important service used in an Oracle database, but this service often encounters errors, in the future, this service will also encounter errors, so the following two common error

In the forum, some people often propose the direction of SQL optimization: To avoid hard parsing of SQL, so as to improve the efficiency of SQL Execution. Avoiding hard Parsing is indeed an important strategy for efficient use of shared_pool. In

Encountered ORA-01078, LRM-00109, ORA-27046 SPFILE file File Corruption solved today when starting the database encountered $ Sqlplus/as sysdbaSQL * Plus: Release 10.2.0.4.0-Production on Tue Jul 16 21:28:03 2013 Copyright (c) 1982,200 7, Oracle.

Data Guard wonderful ORA-16191: Primary log shipping client not logged on standby problem engaged in a Data Gurad, switchover, check the Configuration: SQL> select dest_name,status,error from v$archive_dest where rownum  ORA-16191 error reported.

RMAN-00600: internal error, arguments [10019] [krmxcr] [] [] [] solve a very strange problem today. Today, we are doing physical dg, a rac and a standalone dg. Perform recovery on the same machine first, back up the database, pfile, and standby

Test the table space function of oracle transmission (including detailed procedures) 1. Export the table space from the source server to the source server: 10.1.122.55 target server: 10.1.122.540. note: If the character set is not set here, an error

Load: oracle tool: sqlldr consists of four steps: creating a table with a source data file (test.txt) and creating a control file (test. ctl), create a bat file (or shell file) focuses on: If the table has the number type, or the date data type can

The buffer cache memory of the CKPT checkpoint queue contains the chain and bufferLRU to concatenate available blocks (based on the Access Frequency). LRUW concatenates dirty blocks (Access Frequency) and cold-end blocks are first written to the