2009/06

Disk Management Part asm

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 ...

Change apps, the statements appear to run error, pl / sql to the normal landing

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

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 ...

Database training a sense of

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

Oracle10g - The regular expression

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 ...

How do I enable AutoTrace features of sqlplus

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 ...

SQL interview a subject of transnational corporations

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 - & ...

Son of discrete pieces of work resulted in a single stock is negative

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 ...

Profiles Used in Form Personalization

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 ...

Oracle memory structure of-PGA

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, ...

How to design a good database

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 ...

oracle notes

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 ...

Oracle memory structure-SGA

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 ...

Oracle 10g using FORALL to deal with non-consecutive array

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 ...

How to Correct the Error Codes in Journal Import?

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 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 ...

oracle create tasks (to)

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

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

Adjustment oracle database connection pool connections

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& ...

oracle11g installation environment variable is set to adjust the kernel parameters

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 ...

oracle sum up the reasons for the slow query

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 ...

The role of parameters local_listener

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 & ...

Oracle Database initialization parameter changes to note

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 ...

oci simple case of

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; / / ...

RMAN backup and recovery - RAC database backup and recovery environment

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 rollback and Services

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'; ...

Are there waiting for log buffer space

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 ...

Invoice has been fully paid and still be able to choose the payment amount of zero

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 ...

oracl change user password

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)

See disk file disk I / O number of

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 ...

oracle log files

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 ...

Help: How do I change the partition table for nologging mode, use the data to insert append???

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. . . ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

Oracle For Update row lock

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 ...

ORACLE_HOSTNAME undefined

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 ========== ...

db_cache hit rate

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 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 transaction isolation level

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 ...

linux create user tablespace oracle

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 ...

Under the Linux host configuration automatically start Oracle 10G

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 ...

How to validate a AR is correct?

- 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 ...

Oracle access to the current user's default tablespace

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

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 helpful for their orders

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 ...

start oracle DB control configuration

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 ...

Database users to create and modify user information

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 [ ...

ORACLE SPOOL Usage Summary

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 ||& ...

Concurrent Manager appears FS-NCROINT FAILED error, can not start

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

ORACLE10G modify the host name can not start EM Enterprise Manager

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 ...

Oracle database. Net connectivity problems

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 ...

RHEL4 install 32-bit ORACLE10G

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 ------ ...
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments