Oracle

  In December 2, I deleted the database by mistake. The boss was so upset that I would recover the database within 30 minutes. In a hurry, I wrote a stored procedure, this method is applicable when the table is deleted on the day of restoration

Install oracle 11G on Fedora 16/Etc/sysctl. conf ------------------------------------------- fs. aio-max-nr = 1048576 fs. file-max = 6815744 kernel. shmall = 2097152 kernel. shmmax = 536870912 kernel. shmmni = 4096 # semaphores: semmsl, semmns,

For LIKE fuzzy search, you can use the wildcard "%" and "_": %: to indicate any character, including zero; _: to indicate any character; SQL code Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott SQL> select *

The resolution operation saves a parent cursor and child cursor to the library cache and saves them to sga to reuse them and avoid hard parsing. Under what circumstances can I reuse the parent cursor and child cursor?The key information of the

Postgres Formatting Function provides a set of effective tools for various data types (date/time, int, float, numeric) convert to formatted string, and convert from formatted string to original data type in turn. Note: The second parameter of all

In Windows, when running SQL * Plus in the doscommand window, you can use the up and down keys to skip the previously executed SQL statements. you can modify them as needed and press Enter to submit them again.However, when running SQL * Plus in

Oracle 11g error ORA-28000 the account is locked I. the cause and related factors of this error are caused by the default setting of "PASSWORD_LIFE_TIME = 180 days" in the default profile in oracle11g, there is a password expiration problem in

Related Links: Exploring the RMAN_01 concept of ORACLE http://www.bkjia.com/database/201205/132243.html RMAN is an implementation tool launched by Oracle8i to better implement database backup and recovery. It can achieve online database backup and

The most important purpose of redo log files is to restore data (you can also use logminer). It records the database buffer cache (high-speed cache area) in the system global area (sga) all change information is recorded in the log buffer. However,

One oracle note table allows Statistics of multiple fields (multiple count: count the total number of tickets in the WAIT_ORDER table, the total number of unprocessed tickets, the total number of completed tickets, and the total number of incomplete

Password File recovery _ EM login failure solution 1. The default location of the password file is/u01/oracle/product/10.2.0/db_1/dbs/orapwSID. If the password file is damaged, you cannot log on remotely. em cannot log on. The error "username or

Install the ORACLE 10g client in windows 7. Because oracle 10g is not compatible with windows 7, we can modify some files in the installation software to achieve the installation goal. A) open the path "\ ORACLE10G_client \ stage \ prereq \ client \"

Explain several usage and significance of Oracle temporary tables can be said to be a good way to improve database processing performance, when there is no need to store, only stored in the Oracle temporary tablespace. I hope this article will help

About solving oracle login: ora-12154: tns: unable to resolve the problem of the specified connection identifier ready May day to start learning oracle, so today I plan to install oracle 10g. After the installation is complete, test whether the job

How can I increase the data loading speed of oracle swap partitions? CASE Environment: OS: linuxdb: oracle10g www.2cto.com where the data loading speed of a database is very slow? The following is a small example. First, calculate the SQL statements

Oracle proof: uncommitted transactions may also be written into data files by DBWn to learn oracle, many people will think that DBWn writing is related to commit. This is incorrect. In fact, there is no relationship between DBWn writing and whether

From the principles of the Balance tree to the oracle B-tree index, let's look at it first. There are two types of oracle indexes that are widely used: 1) B-tree: OLTP (transaction-oriented) 2) bitmap: OLAP (analysis-oriented) Step into the topic,

The simplest way to create a database manually (including oracle rac) is to use dbca to create database scripts and then execute these scripts manually. The specific process is as follows: 1. manually create related directories and environment

Oracle utility: oradebug 1 oradebug introduction oradebug is mainly used by oracle support staff. Although it was very early, it is rarely recorded on the oracle official website. It is an SQL * plus command line tool. You can log on with sysdba

Dynamic SQL syntax Only at run time can Oracle check whether its format is correct. The INTO and USING clauses are optional. If the SQL statement is a query statement, we can use the INTO clause INTO statement to receive the record value selected by