As usual, ready to start their own test database on the machine Aspect things, net start oracleservicening, normal, sqlplus with sysdba login, strange how this was not reflected in 10 seconds, ah, the machine is not good, do not do first point things ...
Use Oracle-specific query syntax, you can achieve a multiplier effect 1. Tree query create table tree ( id number (10) not null primary key, name varchar2 (100) not null, super number (10) not null / / 0 is root ); - From child to parent select * fro ...
AIX 5L (AIX 4.3.3 and above) 1. Aix parameters v_pinshm = 1, default is 0, that will support pin aix live in memory, set the method # Vmo-p-o v_pinshm = 1 2. Aix memory parameter maxpin% = percentage, default 80%, expressed support for the largest pr ...
Yesterday (2007-12-27 day) to maintain a platform for mobile province of engineers reporting database instance is not available, only to re-start! It had to, and business in any case not stop. Log in to quickly check that the server up. Through log a ...
1. Aggregation function (group functions) What? AVG (x) COUNT (x) / / number of rows MAX (x) MEDIAN (x) / / check value MIN (x) STDDEV (x) / / standard deviation of demand SUM (x) VARIANCE (x) / / request variance Aggregation function can operate on ...
Please massive bad block or open the library with _allow_resetlogs_corruption after (if you're lucky) to use Do the whole library to export EVENT: 10231 "skip corrupted blocks on _table_scans_" [ID 21205.1] Modified 20-APR-2006 Type REF ...
Oracle block corruption recently encountered a case, record the settlement process alert.log Thread 1 advanced to log sequence 5011 (LGWR switch) Current log # 3 seq # 5011 mem # 0: D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ZMD \ REDO03.LOG Tue Jun ...
It is easy to confuse the two concepts. Concept: OPEN_CURSOR, the definition of each Session the largest number to open the cursor. Defined in the init.ora file, you can select * from v $ parameter where name = 'open_cursors' inquiries. V $ O ...
When a user submits (commits) or rollback (rollback), session's redo information needs to write to the redo logfile in. LGWR process will inform the implementation of the user write operation, LGWR will notify the user after the completion of the proc
- Thanks for the question regarding "v $ open_cursor.sql_text showing" table_4_200_5e14_0_0_0 "", version 8.1.7 Submitted on 6-Apr-2002 23:29 Central time zone Tom's latest followup | Bookmark | Bottom Last updated 12-Dec-2006 22:0
How to copy the link line? Bank link good imitation, as follows: create table test (x int primary key, a char (2000), b char (2000), c char (2000), d char (2000), e char (2000) ) Tablespace test2; test2 block size is 8K, 5 δΈͺ char (2000) in the field, ...
create tablespace name datafile '/ home / oracle / app / oracle / oradata / orcl / name.dbf' size 600m auto extend on next 50m maxsize unlimited; alter database datafile '/ home / oracle / app / oracle / oradata / orcl / name.dbf' aut ...
Second, the data block, data expansion, and data segment 1, block Header: block address, segment type Table Directory: If the segment type for the table, the table information stored in Row Directory: The address for each row piece -----------------------
tnsnames.ora is the client's configuration file; The server configuration file: listener.ora, Stored in the file the client and the server needed to connect the monitor address, and when the server starts listening process information. Descriptio ...
select sid, seq #, event, p1, p1raw, p2, p2raw, p3, p3raw, state from v $ session_wait where event like 'library%'; SQL> set linesize 999 SQL> / SID SEQ # EVENT P1 P1RAW P2 P2RAW P3 P3RAW STATE ---------- ---------- -------------------- ...
1, the first excuse undo_retention Set undo_retention, to ensure the data after commit to keep in undo segment long. However, no guarantee of post-commit undo information undo_retention time certainly not be overwritten when the undo segment is not e ...
At present, the regular expression has been widely in many software applications, including * nix (Linux, Unix, etc.), HP and other operating system, PHP, C #, Java and other development environment. Oracle 10g SQL Regular Expression increased flexib ...
Use Pre-Calculated Exposure =========================== This prevents the exposure from being calculated in real time. The Initialize Credit Summaries process must be run on a regular basis to obtain latest account balances from Accounts Receivable. ...
SELECT SE.SID, OPNAME, TRUNC (SOFAR / TOTALWORK * 100, 2) | | '%' AS PCT_WORK, ELAPSED_SECONDS ELAPSED, ROUND (ELAPSED_SECONDS * (TOTALWORK - SOFAR) / SOFAR) REMAIN_TIME, SQL_TEXT FROM V $ SESSION_LONGOPS SL, V $ SQLAREA SA, V $ SESSION SE WH ...
First, back up on the ORACLE database 2, confirmed the Home directory ORACLE database installation path Third, close the database: SQLPLUS / NOLOG CONN / AS SYSDBA SHUTDOWN IMMEDIATE ORACLE stop all running services 4, extract the installation packag ...
1.classes12.jar (on JDK1.2 and JDK1.3 for, but when I use a good application JDK1.4) Classes for use with JDK 1.2 and JDK 1.3. It contains the JDBC driver classes, except classes for NLS support in Oracle Object and Collection types. 2.ojdbc14.jar (o ...
Preface GoldenGate Software is based on the structure of the log data replication software, which the source database by parsing online log or archive log data obtained incremental changes, and then apply these changes to the target database in order ...
alter database: modify the data file alter database datafile 4 offline; alter database datafile '/ opt/oracle/datafile/users01.dbf' offline; alter database datafile '/ opt/oracle/datafile/users01.dbf' resize 100M; alter database dataf ...
File: Disaster_Tolerant.pdf Size: 3054KB Download: Download
Requires two system privileges: grant create table to backuser; grant create session to backuser; Note: If you do not create table permission, you can not create a master table; if not create session privileges, expdp unable to access the database. N ...
Chapter One: Log Management 1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system checkpoint; 3.adding online redo log groups sql> alter database add logfile [group 4] sql> ('/ disk3/log4a.rd ...
http://hi.baidu.com/djx_5211314/blog/item/497298545065391c3b2935e9.html Several well-known set of operating result set order to test a bit more today and found some problems, record pro forma. Suppose we have a table Student, including the following ...
If the view definition includes conditions (such as WHERE clause) and its purpose is to ensure that any references in the INSERT or UPDATE statement, the view WHERE clause is applied, you must use the definition of the view WITH CHECK OPTION. This option
We all know the record in the controlfile archivelog with relevant information for each course are in the OS, delete these files off, after the physical, in our controlfile archivelog still record such information, in the oracle's OEM manager has a vi
1 run SQLPLUS tool sqlplus 2 to OS, the default identity link / As sysdba 3 shows the current user name show user 4 directly into the SQLPLUS command prompt sqlplus / nolog 5 At the command prompt to connect to OS status connect / as sysdba 6 connect ...
$ / Usr/lib/oracle/11.1.0.1/client64/bin/sqlplus tver / tver @ 192.168.20.47:1521 / TMDB / Usr/lib/oracle/11.1.0.1/client64/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory Ap ...
View this user all system permissions: select * from dba_sys_privs where grantee = 'BACKUSER'; GRANTEE PRIVILEGE ADM ------------------------------ -------------------- -------------------- BACKUSER CREATE SESSION NO Recycling: revoke create ...
Oracle Analysis Function FUNCTION_NAME (<argument>, <argument> ...) OVER (<Partition-Clause> <Order-by-Clause> <Windowing Clause>) SELECT t.transaction_date, t.item_id, t.quantity, SUM (decode (t.transaction_type, 'R ...
1.create init.ora log_archive_dest_1 = 'LOCATION = / arch /' log_archive_format =% t_% s_% r.dbf db_block_size = 8192 db_file_multiblock_read_count = 16 open_cursors = 300 db_domain = "" db_name = gc background_dump_dest = / oracle ...
Outer Join Returns Ambiguous Column Error ORA-00918 on 10.2 [ID 337279.1] -------------------------------------------------- ------------------------------ Modified 11-MAR-2009 Type PROBLEM status PUBLISHED In this Document Symptoms Cause Solution Re ...
create or replace procedure webtongji IS BEGIN BEGIN INSERT INTO t_event_webtongji SELECT (SELECT COUNT (ID) FROM T_EVENT T WHERE EVENTSTATEID = 05 AND T. C_CREATETIME BETWEEN (SELECT ((SYSDATE-1 - TO_DATE ('19700101080000 ',' YYYY-MM-DD ...
oerr is in unix on oracle ora error to find a small tool, extremely easy. Command format: oerr ora error number ora-01632 for example, to view a description: [Oracle @ shtdtest oracle] $ oerr ora 01632 01632, 00000, "max # extents (% s) reached ...
By default, the start or in the sqlplus through @ call script will only work in the system path of the current search script, such as the following example, the need to put the script t.sql d: \ directory, otherwise error . D: \> sqlplus ning / ni ...
Platform: Oracle 10.2.0.1 on CentOS 5.1 Primary Host Configuration: 1, the installation of production database instance named orcl 2, hostname for the primary 3, the host has to open archive Standby equipment machine configuration: 1, only install so ...
Diagnosis of the database using SQL_TRACE: eygle | English Version [reproduced the form of a hyperlink, please indicate the source and author information in the article and the statement] Links: http://www.eygle.com/archives/2004/10/use_sql_trace_to_diagn
In Linux, when using SQL * PLUS, history does not provide a callback function, and sometimes inconvenient. In order to use the Up and Down Arrow call history command, you can install rlwrap the software. rlwrap, the program itself is a Shell, you can ...
WARNING 2010-05-06 20:19:34.562 Execution of the command "C: \ j2sdk1.4.2_17-x64 \ bin \ java.exe-classpath migmon.jar-showversion-Xmx1024m com.sap.inst.migmon.imp.ImportMonitor-sapinst" finished with return code 103. Output : java version "
Oracle outer join and (+) of usage For external connectivity, Oracle can use "(+)" to represent, 9i can use the LEFT / RIGHT / FULL OUTER JOIN, the following will be introduced with examples of 11. 1. LEFT OUTER JOIN: left lateral associati ...
Oracle outer join and (+) of usage For external connectivity, Oracle can use "(+)" to represent, 9i can use the LEFT / RIGHT / FULL OUTER JOIN, the following will be introduced with examples of 11. 1. LEFT OUTER JOIN: left lateral associati ...
1. Hot Standby Broadly speaking, hot standby (Fault Tolerant) is an important service for the use of two servers, each backup, the joint implementation of the same service. When a server fails when, can be another server assume responsibility for ser ...
When shutdown abort, kill the process with the same effect as the database is shut down immediately, this time the state may be inconsistent because of the normal document closure of the database will be synchronized check the file so that when the f ...
Platform: Oracle 10.2.0.1 on CentOS 5.1 primary host configuration: 1, the installation of production database instance named orcl 2, hostname for the primary standby equipment machine configuration: 1, only install software 2, hostname for the stand ...
Today, the developer gave me some stored procedures, some of the code is as follows: CREATE TABLE tmp AS SELECT FEE.MSISDN, HW.CITY_ID, HW.ZONENAME, TO_CHAR (FEE.DEAL_DATE, 'yyyymmddhh24miss') AS DEAL_DATE, FEE.PAY_VALUE, FEE.CPSERVICEID, CAS ...
Platform: Oracle 10.2.0.1 on CentOS 5.1 primary host configuration: 1, the installation of production database instance named orcl 2, hostname for the primary standby equipment machine configuration: 1, only install software 2, hostname for the stand ...
