Oracle

First, using sqlplus to manage databases is the highest level ~ It is also helpful for us to understand oracle. We should not rely too much on third-party development tools, such as plsqldeveloper. These tools are used for Development kits, stored

Log on as an administrator:1. First, create (new) Users:Create user username identified by password;Username: username of The New User NamePassword: password of the new userYou can also use the previous user instead of creating a new user. For

Oracle Connect By usage The select statement in oracle can use the start with... connect by prior clause to implement recursive queries. The connect by clause is used in structured queries. Its basic syntax is as follows: Select... from Where Start

  My friend built an index on a million table and it didn't end in half an hour. So we will discuss how to speed up.   I. First, let's take a look at the operations to create an index: 1. Read the data of the index key to the memory. ==> If data is

Question 1: Which process is responsible for hard parsing? In addition to low hit rate, what are the other causes of unreasonable shared pool settings?   When it comes to soft parsing (soft prase) and hard parsing (hard prase), it is not worth

  DATE data type 　　 We are very familiar with this data type. We will always think of the date type when we need to represent the date and time. It can store months, years, days, centuries, hours, minutes, and seconds. It is typically used to

Oracle has three main memory structures:The System Global Area (SGA) is a large shared memory segment. Almost all Oracle processes need to access a certain point in this zone.The Process Global Area (PGA) is the memory dedicated to a Process or

  The installation of ORACLE10G in red hat 5.4 is finally successful. ORACLE in WINDOWS is a little different from ORACLE in LINUX. It can be seen from a simple installation. When installing ORACLE in LINUX, you must first install the auxiliary

  Today, a user's database suddenly finds that all clients cannot connect. However, sysdba users can log on normally;   First, it is suspected that someone has set the database to the silent mode.   Log on to the database on the server, check

  There is an overhead space (overhead) at the beginning of the database block, which stores a transaction table for the block. For each "actual" transaction that locks some data in the block, there is a corresponding entry in this transaction table.

  Oracle 10g installation in win7, select advanced options, prompt program abnormal termination, an unknown error occurs     Modify Oracle 10G \ database \ stage \ prereq \ db \ refhost. xml   In the             Go to the install directory and

  Oracle 10 Gb provides a new performance collection and analysis tool awr (automaticworkload repository ). Awr exists in the sysaux tablespace and is one of the main users of sysaux. Snapshot, a set of performance statistics captured at a specific

Oracle query statement from last Monday to weekend [SQL] -- Oracle obtains the SQL statement from the last Monday to the weekend -- in this way, select to_char (to_date ('123 ', 'yyyymmdd'), 'D') from dual; -- result: 6 Note: 2013.09.06 is Friday,

Oracle to_number () function learning 1, Converts a string to the NUMBER data type (convert a string to a numeric data type) TO_NUMBER ( [, , ]) RETURN NUMBERselect to_number ('123') from dual; to_number ('123') 00001228 select trunc (to_number ('12

Linux hugepage configuration-optimizing oracle memory linux is not as powerful as aix and hp unix, but linux is also very good. To improve linux performance, it uses a lot of io, memory scheduling mechanism. linux uses the memory mode by vm, that is,

Oracle flashback drop knowledge sorting 1) No downtime or backup is required. 2) You do not need to configure it. you can disable it through permissions. 3) Only data in non-SYSTEM tablespace managed locally (non-dictionary management) will enter

How to delete. the trc file bdump contains the alert file, and trace fileudump of some background processes. Generally, the trace file cdump of session after SQL trace is placed. Generally, some core trace files are placed. adump is generally audit

Oracle 11g 11.2.0.1 setting HuagePage causes TRC to become larger and more recently found diag /.... the size of the sid_ora_xxxx.trc file in the/trac/directory is 11 mb and the number of similar files is large. as a result, 8 GB of hard disk space

A ORA-00471 Processing Method of a new service to the machine room, hardware is IBM X3850 X5, hardware configuration is good, memory has 128 GB. SA has installed the system (sule 32bit) and notifies me to install the database. Busy for half a day.

Restart Oracle 11g RAC record the process of restarting Oracle ========================== Node 1 (oracle user) 1. lsnrctl stop // close listener 2. sqlplus/nolog // close database connect/as sysdba shutdown immedidate Node 2 (oracle user) 1. lsnrctl