Oracle

first, what is Oracle before learning the DRP System, I have mentioned Oracle many times , and Iknow it, so what is Oracle? Today, I finally unveiled its mystery. Oracle : is a company and of course what I'm talking about here is Oracle database,

 Method One:[Email protected] ~]# Su-grid[Email protected] ~]$ Sqlplus/as sysasmSql*plus:release 11.2.0.3.0 Production on Thu Jul 3 09:36:27 2014Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition

Practice the Oracle Mission plan in your spare time today, as detailed below1. Create a table Tbl_timeCREATE TABLE Tbl_time (ID number not NULL,/*id */vsecond VARCHAR2 (2),/* Seconds */vtime VARCHAR2 (10)/* Current time */)2. Create a sequence

Oracle Split character QuerySELECT * from view_psbaseinfo where DECODE (' 410782001125,411100000043 ', ', NULL, ' 410782001125,411100000043 ') is a NULL or Pscode in (SELECT regexp_substr (' 4107820011

Today received a friend database a case, in the DBCA to build the library, the automatic collection of statistical information options are removed, the database runs for half a year did not collect statistical information, now to enable the method

1. Use the top command to see the SPID numbers with the most productive resources first2. Query the current time-consuming session ID, user name, Sqlid, etc.: Select sid,serial#,machine,username,program,sql_hash_value,sql_id, To_char (Logon_time, '

1.USEREVN ()Returns information about the current user environment, opt can be: entryid,sessionid,terminal,isdba,lable,language,client_info,lang,vsize1.ISDBA See if the current user is a DBA if yes returns true sql> select Userenv (' Isdba ') from

1. Simple Query Structured Query Language (SQL) is a database Query and programming Language used to access data and Query, update, and manage relational database systems. ANSI (American National Standards Institute) claims that SQL is the standard

When a deadlock occurs in the Oracle database, follow these steps: Step 1:Try to delete in sqlplus using SQL commandsIf the deletion is successful, everything is fine! However, if you want to delete a session with a deadlock through a command line

Although Oracle's dynamic SQL statements are very convenient to use, the assembly process is too troublesome. Especially when a date field is involved in the Assembly Statement, to_char must be added during the Assembly to convert it into a

This blog introduces the installation process and simple configuration of Oracle data to help you simply run Oracle. It is just a basic tutorial.   Preparations: If you have installed an Oracle database before and want to change the installation

Original blog link address: Database open error ORA-01555: snapshot too old During his honeymoon in Dongguan today, a student said that the test library he managed had a problem and could not be opened. Let's first look at the problem:

Master/Slave database switchover Switchover Generally, SWITCHOVER is a planned SWITCHOVER, which features that no DATA will be lost after the SWITCHOVER, and this process is reversible, so the entire data guard environment will not be damaged, all

Recently, a project was created to access the oracle database through VC odbc. It can run normally on my computer and cannot run on other computers because the oracle odbc driver is not available and the oracle Data source cannot be configured. Most

Oracle RAC cache fusion is the core working mechanism of RAC. It virtualizes the SGA of all instances into a large SGA zone. Each time different instances request the same data block, this data block needs to be transmitted between instances. So

Today, I received a case from my friend database. When I created a database in DBCA, I removed the option of automatic statistics collection. The database has not collected statistics for six months. The method to enable this feature is as follows:

A transaction is a logical unit of work used to separate database activities. A transaction has a starting point and an ending point;When one of the following events occurs, the transaction starts:Connect to the database and execute the DML

11gR2Build a replicuard environment: Self-built experiments will be released in the future, such as the creation of rman models, master-slave switchover, and mode adjustment.   Primary: OS: oel 6.4 Database: 11.2.0.4.0 192.168.100.131 Hostname =

1. USEREVN ()   Return the information of the current user environment. The opt can be: ENTRYID, SESSIONID, TERMINAL, ISDBA, LABLE, LANGUAGE, CLIENT_INFO, LANG, VSIZE.   1. Check whether the current user is a DBA. If yes, return true SQL> select

Oracle 10g rac start/stop archiving ModeIf the Oracle database runs in archive mode, you may need to suspend the archiving of the database during database maintenance. After the maintenance is complete, restart archive mode.To switch from archive to