- Create named sulfur in the profile, if there is no need to re-establish create profile sulfur limit sessions_per_user unlimited cpu_per_session unlimited cpu_per_call unlimited connect_time unlimited idle_time 60 logical_reads_per_session unlimited ...
create table t (id number primary key, name varchar2 (20)); With data 1 'zhang' 2 'wang' 3 'chen' Open two sqlplus: The first one: update table t set Every two: update table t set name = 'liang' where Then in the first ...
BEA recommends using Weblogic JDBC multi-pool, but using the WebLogic JDBC multi-pool can not support global transactions, no more pool will need to rely on Oracle Thin driver to achieve failover. XA-driven requirements: Global transaction must be in ...
nest loop: cost = outer access cost + (inner access cost * outer cardinality) Sort merge join: The cost of a merge join = access cost of A + access cost of B + (sort cost of A + sort cost of B) Hash join: cost = (outer access cost * # of hash partiti ...
oracle asmlib in the trap of using multiple paths Describes the use of the oracle asmlib more than a place to note the path. In view of the RAC data warehouse database, found that the database is not used to provide multi-path powerpath disk. This da ...
This script is characterized by only one connecting to the database, and will not always want to perform a SQL database when they connect, so this can be done second level of the cycle, while abnormal interrupt if the connection will automatically re ...
Pure natural connection (NATUAL JOIN): Pure natural connection: When the source and destination table column share the same name, you can implement the natural connection between them, without having to specify the connection out. Syntax: (SQL: 1999) ...
Table Mode Insert Mode ArchiveLog mode result ----------- ------------- ----------------- --------- - LOGGING APPEND ARCHIVE LOG redo generated NOLOGGING APPEND ARCHIVE LOG no redo LOGGING no append "" redo generated NOLOGGING no append &qu ...
+ Hand-built database + oracle 9i ================================================== ================================= + + Set the environment variable + + View. Profile of the configuration is correct: export ORACLE_BASE = / opt / oracle export ORAC ...
This script uses perl, this script is extracted through sqlplus to connect to oracle database performance, so do not need to install DBI.
In the case of relatively large pressure, create / rebuild index online, cancel or kill if off, you may encounter this error ORA-08104: ORA-08104 this index object string is being online built or rebuilt The root cause is ind $ system table does not ...
Today in a local database connection problems: tnsping test (the local TNS) TNS-12545: because target host or object does not exist, the connection fails Search for a long time, configure how to see no problem in the new configuration of the TNS can ...
oracle10g + Need to install the package + Rhel5.3 need to install: No matter what oracel versions need to install libXp, it is necessary package xwindow Check installed libXp # Rpm-qa | grep libXp libXp-1.0.0-8.1.el5 libXpm-3.5.5-3 libXpm-3.5.5-3 lib ...
Way of using the LGWR process SYNC alter system set log_archive_dest_2 = 'SERVICE = ST LGWR SYNC NET_TIMEOUT = 30' scope = both; alter system set log_archive_dest_2 = 'SERVICE = ST LGWR SYNC AFFIRM NET_TIMEOUT = 30' scope = both; Way ...
tnsnames.ora configured incorrectly can cause serious problems If tnsname.ora configured properly, for example: mytest.db.my.com = (DESCRIPTION = (ADDRESS_LIST = ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.0.1.2) (PORT = 1521)) ) (CONNECT_D ...
cat / proc / driver / ics_sdp / stats cat / proc / driver / ics_sdp / config cat / proc / driver / rds / info cat / proc / driver / rds / stats cat / proc/drivers/ipoib/interfaces/ib1 View infiniband rds traffic information of the script:
The steps switch the database: 1. This state of the main library select switchover_status from v $ database; The main library collection on the situation of temporary table space, because temporary files prepared library may be missing after activati ...
Statistical information on database tables to do the steps in package form a more flexible form than the statement 1.1, the statement means: analyze table compute statistics for table | | for all columns | | for all indexed columns; - View the table ...
First, create a table in PLSQL: Second, create a PLSQL stored procedure: Third, the SQL command window to start the task: In SQL> after the execution: After submission tips: 4, tracking task conditions (see task queue): Stated that there existed a ...
aix platform came from the oracle rac environment software, tar, unpack directly to the new machine, the target environment is the single, you need to close the rac option. RAC OFF 1. Login as the Oracle software owner and shutdown all database insta ...
The database was put into use and can not restart, so clearly those parameters can be activated in the database, and those parameters can dynamically modify the configuration of the comparative performance of the database behind the parameters is rel ...
Comparison operators Equal and not equal Including <,>,<=,>=,<>,!= Oracle database server settings based on some implicit conversion to character data value When comparing character literal, oracle will convert it to a continuous ch ...
Can use the and symbols (&) to replace the elements of SQL statements, including all text, clause, sub-clause. Through and symbols to designate variable. Basic SQL statements, the most common form is a single element and replace the ampersand (&a ...
After installing the software, built by dbca database instance name is abc, related as follows: File: abc.rar Size: 6KB Download: Download Building a database script by default remain in the C: \ app \ Administrator \ admin \ abc \ scripts \ director ...
Partition table, partition index and the overall index: The data in a table had 20 million more than 2G or occupied space, proposed the establishment of the partition table. create table ta (c1 int, c2 varchar2 (16), c3 varchar2 (64), c4 int constrai ...
ORACLE 007 - 5 group by the use and enhancement, advanced sub queries In introducing the GROUP BY and HAVING clauses, we must first talk about the sql language, a special function: aggregate functions, such as SUM, COUNT, MAX, AVG, etc.. These functi ...
I believe we saw this article on the Oracle how to work an image understanding! Taken from ----" Oracle Backup and Recovery " -------------------------------------------------- -------------------------------------------------- ------------ ...
Loaded oracle Chinese technical forums. Whole describes a dba of responsibilities and tasks and so on. ORACLE database administrator should be as follows on the ORACLE database system for regular monitoring: (1). Day running of the ORACLE database, l ...
CREATE OR REPLACE TRIGGER dsmpsms_sort_tri BEFORE INSERT ON tibco3.swi_in FOR EACH ROW DECLARE isExist NUMBER; tempMsg varchar2 (128); BEGIN - Deal new's dsmp data isExist: = 0; SELECT count (1) INTO isExist FROM cboss.DSM_SWI_MT_WAIT t where t.M ...
t in the table nearly 11 million data, very often, we want to string matching, in the SQL statement, like we normally use to achieve our goal of search. But after tests found that real, like the efficiency and instr functions quite different. Here ar ...
1, create a stored procedure create or replace procedure test (var_name_1 in type, var_name_2 out type) as - Declare variable (variable name the variable type) begin - Body of stored procedure execution end test; Print out the input of time informati ...
http://space.itpub.net/?uid-7607759-action-viewspace-itemid-345693 http://www.91linux.com/html/article/guanli/20090103/15265.html
Commonly used database objects are: tables, views, sequences, indexes, synonyms. Table can also be known as the exemplar of the heap organization can have up to 1000 Classification table can be divided into two main categories: user table, user table ...
The concept and principles of the binding constraint role: to prevent invalid data entry into the table in some common constraints: not null the specified column can not contain null values unique value of the specified column or combination of colum ...
Database Manipulation Language (DML) include: insert, delete, update a DML will start a transaction, then the DML statement is the same transaction until commit or rollback. DML can also be used in subquery insert into statement syntax in the insert, ...
Set of functions is also known as multi-line function and single function of different groups function multi-line value will be processed as a whole Use the group function rule: makes the function consider only distinct values of non-repetition; all ...
Sub-query: a query is nested in another query, that is, subquery subquery is equivalent to the implementation of two consecutive queries and used the results of the first query as the value of the second search query You can put a lot of SQL sub quer ...
Database Manipulation Language (DML) include: insert, delete, update a DML will start a transaction, then the DML statement is the same transaction until commit or rollback. DML can also be used in subquery insert into statement syntax in the insert, ...
netca and / etc / hosts with 3 comments When I first re-installed my laptop with Fedora 8, I naturally set about installing Oracle 10g. However at the end of the dbca process, the launching of netca failed. Trying to run netca manually yielded this f ...
Today it was asked, in SQL * PLUS script executed, which is the INSERT statement, if you encounter duplicate primary key error, followed by the SQL statement is still continue. Subsequent SQL statements would be implemented, is available through SQLP ...
Source: Redhat communities of: Oracle editor Directory I. Introduction Second, build the hardware platform 3, RedHat As4 update2 Installation and Configuration 4, Oracle 10g Installation and Configuration 5, Red Hat Cluster Suite Installation and Con ...
In 11gr2, the use exp to export data, the discovery of new table if there is data to guide them, there is no data on the guide does not come out, so there are ways to achieve the following expdp system /******** dumpfile = dd.dmp schemas = USR reuse_ ...
A shutdown. 1, first stop the AP1 & AP2 of the IIS services do not allow other operators to connect to the database of the situation there. 2, first turn off DB1 host. # Sync; sync; sync; halt-p Observation of DB2 is "seize power" and w ...
First, connect the host string, that there is no listener SVRMGR> connect internal / oracle @ orcl; ORA-12541: TNS: no listener SVRMGR> Second, run the listener, that address specific components of the specified protocol is not correct C: \> ...
Source: Internet Case 1: Maintenance of databases and operating systems, servers, need to close the DB (all instances), OS and Server. a. First stop Oracle10g environment $ Lsnrctl stop (each node to stop listening, you can use srvctl to operate) $ E ...
from: http://diveintolinux.appspot.com/2010/06/18/oracle-conn-auth.html Connection Permissions To connect to oracle database user must have create session system privilege or the CONNECT role. Connection 1. Local connection $ Sqlplus user / password ...
Originally posted: http://space.itpub.net/12361284/viewspace-163548 not easy to find the source, huh, huh Automatic Workload Repository (AWR) Learn to use the new features that collect data and measure the database performance statistics for analysis ...
Linux, to automatically start and stop Oracle services (2009-01-04 16:30:28) By default, if you install Oracle, then Windows will register the appropriate service, and start with the operating system automatically starts. However, in Linux (the envir ...
Weekend room UPS fault, a Win2003 server, Oracle does not start after power failure, error as follows: SQL> startup ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Bu ...
If you do a custom form or do database management software, you must be able to automatically obtain a user of some information under the database. More useful are: Table name, field English name, Chinese name field, field type, field length. Among t ...
