2009/06
asm add linux on the disk into the disk method [root @ localhost init.d] # fdisk / dev / sdd rn Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-261, default 1): 130 Last cylind ...
Today at the Forum to help users to solve a problem of a complicated, more or less as follows: To change the apps, the statements appear to run error, pl / sql to the normal landing erp version 11.5.10.2 1, to change the apps password, pl / sql can u ...
Oracle Certification skillfully taking outside designated records associated with the alternative in / not in query Table 1 to obtain the first 6 to Article 10 of the value of records 1.1 The first method, the use of minus statement Ddl statement ass ...
rn Recently had the honor of the Ministry of Information Industry took part in a training organized by oracle, the teacher lectures, Yuan Baohua, to 30 years old, more than ten years in database industry, although much older, but the teaching can be a viv
On the basis of regular expressions that can refer to "layman's language of regular expressions", Oracle10g achieved with the regular expression is basically the same, the details can refer to "10g in regular expressions." Ora ...
Through the following methods can Autotrace granted permission to Everyone, Autotrace If you need to restrict the authority of the public can be re-authorized user on a specific authorization. D: / oracle/ora92> sqlplus / nolog SQL * Plus: Release ...
inner join left outer join right outer join full outer join A difference between the four is a cross join is a Cartesian product of the number of rows in table another table multiplied by the number of rows a left join b: to return to a full line - & ...
Reasons: BOM in the definition of recent users, we had pieces of the parent / child ratio of 1:1 parts consumption may be due to user error, the results of the parent items / sub-items for the consumption of more than 1:1000, single work in the compl ...
The profile controlling this follows 1 Utilities: Diagnostics = Yes / No This profile option controls whether users can use the examine utility. 2 Hide Diagnostics Menu entry = Yes / No This profile option controls the availability of Diagnostics uti ...
I. Overview SGA, PGA, UGA is Oracle's memory management. SGA (System Global Area), that is, the overall situation of the district system, Oracle the most important area of memory. PGA (Process Global Area), that is, the overall district program, ...
Database design (Database Design) means that for a given application environment, the optimal structure of the database schema, the establishment of databases and applications, to enable them to effectively store data to meet various application need ...
EM services start and stop (10g) emctl start dbconsole emctl stop dbconsole emctl status dbconsole Oracle10g EM garbled the quick fixes Show only English. To the IE select "Tools "==>" "==>" internet options to add &quo ...
First, an overview of the "Oracle memory structure of-PGA Chapter" mentioned in the article, PGA is a dedicated server process private memory area, while the SGA is the shared memory area. SGA by a number of parts: 1, the fixed SGA (Fixed S ...
In PL / SQL implementation of cycle data manipulation language (DML) is a time-consuming, because each cycle should be from PL / SQL engine SQL engine turning. FORALL is a better application of the method, which a one-time to a group of SQL statement ...
Period Error Codes ------------------ EP01 This date is not in any open or future enterable period. EP02 This set of books does not have any open or future enterable periods. EP03 This date is not within any period in an open encumbrance year. EP04 This d
Oracle 10g under Redhat linux installation instructions Oracle 10g under Redhat linux installation instructions 1. Hardware requirements 1.1 memory of at least 512M, use the following command to check grep MemTotal / proc / meminfo Exchange of at lea ...
rn rn http://www.cnblogs.com/tohen/archive/2008/11/17/1335186.html rn First, create a PLSQL table: rn create table HWQY.TEST (CARNO VARCHAR2 (30), CARINFOID NUMBER) rn rn rn Second, create a PLSQL stored procedure: rn create or replace procedure pro_ ...
Truncate Table is used when no matter drop storage or reuse storage will be re-instated to the first HWM From: http://space.itpub.net/13165828/viewspace-607258 A, B for the two Table. 6g3n ~ Hrn ^ J9o0A, B, respectively, the data on the space under the ta
First backup $ ORACLE_HOME \ dbs \ spfileSID.ora document c:> set ORACLE_SID = xxx c:> sqlplus / nolog sql> connect / as sysdba - View the current value of the parameter sql> show parameter processes; sql> show parameter sessions; sql& ...
1, to talk about the contents of environment variable wrote ~ oracle / .bash_profile or wrote. Bashrc, wrote this article ~ oracle / .bash_profile #. Bash_profile # Get the aliases and functions if [-f ~ /. bashrc]; then . ~ /. Bashrc fi # User speci ...
Inquiries are many reasons for slow, frequently asked the following: 1, there is no index or index is not used (this is the most common query slow problem is programming defects) 2, I / O throughput in a small, forming a bottleneck effect. 3, did not ...
Listener log file e: oracleproduct10.2.0db_1networkloglistener.log Summary of monitoring endpoint ... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = xys) (PORT = 1522))) Service Summary .. Service "orcl" contains two routines. Routine & ...
Generally only in large-scale application or performance data, according to the Treasury decreased only need to change the initialization parameters. So from this perspective, the adjustment of parameters to initialize Oracle database is a high-level ...
if ((time ((time_t *) 0)-begin_time)> 60) ( break; ) ) / / Printf ( "The sum is% d \ n", sum); / / Disconnect error_proc (errhp, OCILogoff (svchp, errhp)); / / Sucess + +; / / If ((time ((time_t *) 0)-begin_time)> 60) ( / / Break; / / ...
rn Very good, RAC backup and recovery environment entry article rn RMAN backup and recovery - RAC database backup and recovery environment (a): http://yangtingkun.itpub.net/post/468/285260 RMAN backup and recovery - RAC database backup and recovery e ...
X $ KTUXE: kernel transaction, undo transaction entry Is the oracle of an internal view, showing the progress of the restoration of the death of affairs. SQL> select * from x $ ktuxe where ktuxecfl = 'DEAD' and ktuxesta = 'ACTIVE'; ...
SELECT sid, event, seconds_in_wait, state FROM v $ session_wait WHERE event = 'log buffer space'; Example 1: SQL> SELECT sid, event, seconds_in_wait, state 2 FROM v $ session_wait 3 WHERE event = 'log buffer space'; no rows selecte ...
Background: Recent users, some of the invoices have been fully paid and still be able to choose zero-sum payment, currently we do not have this feature turned on (enable the Allow Zero Payments option in the Payables Options region of the Bank Accoun ...
sqlplus / nolog > Connect / as sysdba; > Alter user sys identified by abck; Modify authentication % ORACLE_HOME% \ network \ admin \ sqlnet.ora in SQLNET.AUTHENTICATION_SERVICES = (NONE) -> SQLNET.AUTHENTICATION_SERVICES = (NTS)
Can query V $ FILESTAT find disk files for each disk I / O quantity, each summary data files for each disk of all the I / O to identify the most likely bottlenecks caused by disk data files V $ FILESTAT contains the following column Help FILE # file ...
The following documents from the Oracle. Routine surveillance of the use of diagnostic files: • There are the following: - AlertSID.log document - the background trace file - the user trace file Monitor the use of diagnostic files document routine di ...
How do I change the partition table for nologging model The use of INSERT / * + APPEND * / INTO, to produce less redo? ? ? ? ? ? ? ? alter table G809t nologging; this not so. . . ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
To: http://hi.baidu.com/mcj0127/blog/item/111a900777db06c87b89473c.html SELECT FOR UPDATE-related knowledge of the application of an e-mail every piece had a certain amount of time to check the database is not issued by mail and send the message, aft ...
The issue can be reproduced at will with the following steps: 1. Change the hostname. 2. Check DBConsole status ISSUE VERIFICATION ================== Verified the issue referencing data collected records as noted below. CAUSE DETERMINATION ========== ...
Data Buffer in various regions of the query hit rate SELECT name, 1 - (physical_reads / (db_block_gets + consistent_gets)) "HIT_RATIO" FROM sys.v $ buffer_pool_statistics WHERE db_block_gets + consistent_gets> 0; Example 1: SQL> SELEC ...
Oracle EM to solve garbage problem Oracle 10g provides a Web-based management tool EM (Enterprise Manager), more convenient to use. However, if you are using a Chinese Linux environment, and when installing Oracle, together with the Simplified Chines ...
oracle 11g provides three types of transaction isolation level 1. Reading to submit: The default transaction isolation level. Services to see the implementation of each query in the query data before the start. oracle never read dirty data. set trans ...
In the existing database instance to create a new account, visit some of the new table rn Steps are as follows: rn 1, log on linux, in order to oracle user login (if the root user is logged on, log in using su - oracle command to switch into oracle u ...
Open terminal run: $ su - root # chown oracle.oinstall / etc / rc.d / init.d / oradbstart # chmod 775 / etc / rc.d / init.d / oradbstart Then run: chkconfig - add oradbstart chkconfig - list oradbstart chkconfig - list oradbstart results: oradbstart ...
- Purpose: To validate whether a transaction's REC is equal to its REV plus TAX or not - Author: Richard.liu SELECT c.trx_number, c.complete_flag, c.customer_trx_id, a.customer_trx_line_id, (SELECT payment_schedule_id FROM ar.ar_payment_schedules ...
Many people use the Internet select default_tablespace from dba_users where usename = 'User name'; this SQL statement, but in fact is not easy to use, because when the current user does not have read permissions dba_users when an error, an er ...
linux as4 is installed under the oracle9 ORACLE patch installed RHAS4 Set http://www.cublog.cn/opera/showart.php?blogid=8463&id=68996 Environment: Lenovo Wanquan R630 (I think there is no good products) customers are using this server, Lenovo ser ...
RMAN command simple solution 1 provides a counterpart RMAN> list incarnation; 2 shows an overview of available Backup 2.1 backup RMAN> list backup summary; B said backup F expressed FULL A said that archive log 0 1 that the incremental backup S ...
Today, you intend to enable Oracle Database 11g's Database Control, found that the initial is not installed: [Oracle @ test126 ~] $ emctl start EM Configuration issue. / Opt/Oracle/product/11.1.0/test126.hurray.com.cn_dodd not found. Problems of ...
1. create user username identified by password or identified exeternally or identified globally as' cn = user ' [default tablespace tablespace] [temporary tablespace temptablespace] [quota [integer k [m]] [unlimited]] on tablespace [, quota [ ...
On SPOOL (SPOOL is SQLPLUS command, not the things inside the SQL syntax.) SPOOL data for SQL, the best definition to its own format, to facilitate the direct import procedures, SQL statements such as: select taskindex ||'|'|| commonindex ||& ...
The day before yesterday in the pub around the time when users encounter a problem as follows: Concurrent Manager appears FS-NCROINT FAILED error, can not start Concurrent Manager can not start, may I ask how to deal with? Starting ZJPROD_0619 @ ZJPROD In
Modify the host name from the info to the info-0073 after, ORACLE EM (Enterprise Manager) can not start, try to solve by hand. C: \ Documents and Settings \ Administrator> emctl start dbconsole Environment variable ORACLE_SID not defined. Please d ...
Also encountered "Oracle.DataAccess.Client.OracleConnection" set initial value of the type of an exception "error, annoying, Google-related information is as follows: Oracle database. Net connectivity problems summary Environment: mach ...
rn First, system requirements rn 1, at least 1G of physical memory; check command: # grep MemTotal / proc / meminfo rn 2, the set up swap space; check command: # grep SwapTotal / proc / meminfo rn Proposed exchange of the actual memory size rn ------ ...
