2009/07
This is the server from time to time in the backup scripts used by a total of two documents auto_bakcup_oracle.bat, parfile.txt the contents of the paper is as follows: auto_backup_oracle.bat Content: rn rn rn rn rn rn rn Export Parameter File parfil ...
1> to find out it; SELECT sid, serial #, action FROM V $ SESSION WHERE STATUS = 'ACTIVE' AND LOCKWAIT IS NOT NULL 2> to kill session; alter system kill session 'sid, serial #';
Oracle released timesten 11g with In-Memory Database Cache 11g new version of the original version the following elements: Oracle Announces Oracle ® TimesTen In-Memory Database 11g and Oracle In-Memory Database Cache 11g Latest Release Enhances Perfo ...
Applications encountered in the production of the following questions. rn Environment: OS redflag Server 5 rn DB Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 RAC rn rn In two tips for the database log rn Errors in file / opt/app/oracle/a ...
Oracle 10.2.0.3 RAC the ORA-600 [kclfusion_1] bug Morning, suddenly received a monitoring report to the police, was found in the environment rac dang a node, and HP Itanium platform, database oracle 10.2.0.3 rac Check the alert log and found that err ...
Larry Beijing Jingcheng Technology Development Co., Ltd. (hereinafter referred to Larry technology) is that the community and businesses to provide comprehensive information technology solutions for the core business of high-tech enterprises. At pres ...
The function of the background process for a brief introduction: DBWR process: the process of implementation of the data files will be written into the buffer zone, buffer storage area is responsible for the management of an ORACLE background process ...
Wrote a user to export the data in the following table tool rn rn Use the following rn . / expdp.pl rn hbjxzl.cublog.cn auxiliary Data Utility Version 1.0.0 rn This script will auxiliary data and struct. -h - Give help screen -E - for export dict -D ...
Last night the Treasury found that the target stream archive full, 100%, the archive log oracle error is reported directly on the deletion of part of the documents in the archives, With pl / sql login, the error did not, and never seriously. This mor ...
Test the success of their own examples: sqlplus / nolog conn / as sysdba begin dbms_fga.add_policy ( object_schema => 'system', # # # # program name object_name => 'nbstutb', # # # # Table name policy_name => 'nbstu', ...
$ echo $ NLS_LANG rn AMERICAN_AMERICA.ZHS16GBK rn If the inspection found that the server side and client-side character set inconsistent, please amend the unified server-side with the same character set. rn Third, modify the character set oracle rn ...
rn A, ORACLE startup and shut down rn 1, in the stand-alone environment rn To start or shut down ORACLE system must first switch to the ORACLE user, as rn su - oracle rn a, start the ORACLE system rn oracle> svrmgrl rn SVRMGR> connect internal rn SV
rn rn rn 1, see table space name and the size of rn select t.tablespace_name, round (sum (bytes / (1024 * 1024)), 0) ts_size rn from dba_tablespaces t, dba_data_files d rn where t.tablespace_name = d.tablespace_name rn group by t.tablespace_name; rn ...
Oracle database import and export of basic methods of data collection using the most recent import and export data oracle encountered a lot of trouble! Oracle database was carried out on a serious study, summed up the import and export order of sever ...
rn rn I. Overview rn Defined in ORACLE8: scalar (SCALAR), composite (COMPOSITE), reference (REFERENCE) and four LOB data types, the following details of their characteristics. rn Second, scalar (SCALAR) rn Legitimate scalar column types and database ...
rn rn rn ORACLE backup solution error rn rn First, backup overview rn 1, the use of thermal backup, need to run in archive mode, the database can be fully restored, that is, from a backup to the database after the collapse of the data will not be los ...
rn rn How to configure the client can connect to the database: rn For a client machine can connect oracle database on the client machines need to install the oracle client software, the only exception is when the java database connectivity, you can u ...
Oracle10g Automatic archiving settings Oracle10i Central Plains log_archive_start in some parameters have been abandoned, the archive log mode is set up we need to log_archive_format and log_archive_dest_N parameters, and then mount the database unde ...
rn rn rn rn rn rn rn rn rn rn Document: rn oracle manual routine maintenance. rar rn rn Size: rn 243KB rn rn Download: rn Download rn
rn Database name (DB_NAME), instance name (Instance_name), as well as the operating system environment variable (ORACLE_SID) In ORACLE7, 8 database, only the database name (db_name) and database instance name (instance_name). In ORACLE8i, 9i in the e ...
Please refer to the attachement! http://blogimg.chinaunix.net/blog/upfile2/090729093945.pdf
1. See oracle database to archive mode: 1.select name, log_mode from v $ database; NAME LOG_MODE ------------------ ------------------------ QUERY NOARCHIVELOG 2. Use ARCHIVE LOG LIST command Database log mode No Archive Mode Automatic archival Disab ...
SQLNET.ORA increase in the following two lines or not solve the problem, turned out to be a Bug. ++++++++++++++++++++++++++++++ SQLNET.EXPIRE_TIME = 0 SQLNET.INBOUND_CONNECT_TIMEOUT = 0 ++++++++++++++++++++++++++++++ Subject: Bug 4185270 - PMON " ...
Please refer to the attachement! http://blogimg.chinaunix.net/blog/upfile2/090729093945.pdf password: a1b2c3d4
SQL> conn / as sysdba; SQL> show parameter audit; NAME TYPE VALUE
ORACLE 9i Oracle9i Database Release 2 Enterprise / Standard / Personal Edition for Windows NT/2000/XP http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip http://download. ...
oracle stored procedure to return an array of methods: 1. to establish package create or replace package test isTYPE filename_array IS TABLE OF varchar2 (1); filename filename_array; end test; oracle stored procedure to return an array of methods: 1. ...
Latches are like short duration locks that protect critical bits of code. LatchFree event that the process of waiting for a process held by other latch. This event a total of three parameters, the meaning is as follows: p1 said address latch, the gen ...
Emerging client TNS-12542 and TNS-12560, but sometimes also the normal connection. SQLNET.ORA set up the client trace +++++++++++++++++++++++++++++ TRACE_LEVEL_CLIENT = 16 TRACE_FILE_CLIENT = CLIENT TRACE_DIRECTORY_CLIENT = c: \ arc TRACE_TIMESTAMP_C ...
1, create a stored procedure create or replace procedure test (var_name_1 in type, var_name_2 out type) as - A statement variable (variable type variable name) begin - The implementation of stored procedure body end test; Print out the input of time ...
1: roll forward: will has been written into the redo log file in the datafile but did not write the submitted data and did not submit data files to write. Are examples of recovery, the general in Database open time. 2: rollback: after opening the dat ...
NESTED LOOP Connected to a subset of the data is relatively small, nested loop is a better connection choice. nested loop is scanning a table, each read a record, on the basis of the index to find a table inside, there is no general will not be index ...
Block, district, paragraph Stored in multi-line block Areas included in the block to connect Paragraph contains a number of areas, not straight Block: PCTUSED PCTFREE is updated to retain sufficient space to avoid the "row chaining" freelis ...
Summarize: 1. The use of parallel parameters, 8 CPU, can be used parallel 6, occupied by a maximum of 6 CPU, no problem under normal circumstances (provided that no other applications accounted for more than two CPU resources) 2. nologging, definitel ...
First, in the simplest shell call sqlplus. $ Vi test1.sh #! / bin / bash sqlplus-S / nolog> result.log <set heading off feedback off pagesize 0 verify off echo off conn u_test / iamwangnc select * from tab; exit EOF $ Chmod + x test1.sh $ ./tes ...
Adjustment of objectives: Sphere of influence: the entry into force after the next restart. SCOPE = SPFILE option list: SPFILE, MEMORY, BOTH Operating statement: example: ALTER SYSTEM SET DB_FILES = 100 SCOPE = SPFILE;
Today, a project group of friends have asked me: how to. NET to call Oracle stored procedure, and the array as a parameter input. Oracle's PL / SQL very strong support for an array of fixed-length and variable length arrays, support for any custo ...
1, by creating a temporary table Data can be imported into a temporary table, then delete the original data table, and then guided back to the original data table, SQL statement is as follows: Demand can be achieved this way, but it is clear that 10 ...
Overview: The Test the creation of the two test forms, t1 are 100,000 records, t2 recorded 10. To create different conditions, respectively, the nested loop join, and compare the different conditions resulting from the number of logical time. Testing ...
Parameters: UNDO_MANAGEMENT The default value is correct after installation to verify the need. You determine the mode at instance startup using the UNDO_MANAGEMENT initialization parameter. The default value for this parameter is MANUAL. You set it to AU
undo tablespace use: Undo tablespaces are special tablespaces used solely for storing undo information Bound: You cannot create any other segment types (for example, tables or indexes) in undo tablespaces Quantity: Each database contains zero or more undo
SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ RAC_DISK / RACDB / spfileRACDB.ora' ORA-17503: ksfdopn: 2 Failed to open file + RAC_DISK / RACDB / spfileRACDB.ora ORA-15077: could not ...
Database system is the core of management information systems, database-based online transaction processing (OLTP) and online analytical processing (OLAP) is a banking, business, government and other departments of the most important one of computer appli
~~~~~~~~~~ Per Second Per Transaction Redo size: 22,007.09 2,921.10 - A very important parameter that you change the frequency of data Logical reads: 22,890.62 3,038.38 Block changes: 95.88 12.73 Physical reads: 5,413.37 718.54 Physical writes: 5.67 ...
1. Linux start oracle su - oracle sqlplus / nolog conn / as sysdba startup exit lsnrctl start exit 2. Linux close oracle su - oracle sqlplus / nolog conn / as sysdba shutdown immediate exit lsnrctl stop exit 3, start the listener oracle @ suse92: ~&g ...
ORACLE is a relational database management system, it uses the form of data organization, and in some of the data table tree structure showing a link. For example, we are talking about an employee table EMP, which contains the employee number (EMPNO) ...
ORACLE database and sometimes the operation, suggesting that a string???, Can not play the role of prompt, which is set up the environment because of language problems, the following operation is the actual use of. View the current session of the lan ...
I now also serve as the mysql-china plate MySQL Moderators, please leave footprints! URL: http://www.mysql-china.com/bbs I have some of the content of the recent well-maintained, as we presented the most interesting article, hope and progress togethe ...
In a two-node RAC system found to have a period of time response data blocks down, so were done AWR TOP 5 event are as follows Node 1: Top 5 Timed Events Avg% Total ~~~~~~~~~~~~~~~~~~ Wait Call Event Waits Time (s) (ms) Time Wait Class -------------- ...
Databases often have to deal with a record of the relationship between father and son, in the oracle query can be used in a subset of all records of all check out. For example, as follows: t1 t11 t111 t1111 t12 t121 t1211 db data fields are as follow ...
