2009/07

Logical backup case: windows platform guide data oracle logical backup scripts, backup automatically compressed rar

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

How to solve session lock?

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

Timesten 11g with Oracle released In-Memory Database Cache 11g

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

Table undotbs1 damage on the solution space

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

10Grac the ORA-600 [kclfusion_1] lead to node restart

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

oracle agent, IBM software, redhat good price

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

oracle background processes

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

perl export data

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

oracle archive is full, delete some can not be re-filed after the dissemination of data stream

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

oracle10g fine-grained auditing

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

Summed up the issue of Oracle Character Set

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

ORACLE9I day-to-day operation

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

Common SQL statements

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

Export Oracle database data into the basic methods and regular backup script unix

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

About Oracle data types

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

Oracle error backup solution

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

(Transfer from LU) how the client connected to ORACLE database

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

Archive oracle10g example (reprint)

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

ORACLE day-to-day maintenance manual (Download)

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

the database name (db_name). instance name (instance_name). ORACLE_SID

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

How to add material oveahead (MOV) to item costs?

Please refer to the attachement! http://blogimg.chinaunix.net/blog/upfile2/090729093945.pdf

archiving mode oracle10g reprint

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

dead connection bug

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

How to add material oveahead (MOH) to item costs?

Please refer to the attachement! http://blogimg.chinaunix.net/blog/upfile2/090729093945.pdf password: a1b2c3d4

configuration audit oracle10g

SQL> conn / as sysdba; SQL> show parameter audit; NAME TYPE VALUE

oracle patch link

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

Skills: oracle stored procedure to return an array of methods

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

Finishing the latch free event

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

TNS-12542

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

Summary of Oracle stored procedure (a. Basic applications)

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

On the pre-roll (roll forward) and roll back (roll back)

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

HASH JOIN, MERGE JOIN, NESTED LOOP

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

oracle memory structure

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

How to accelerate the speed of indexing

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

(To) shell circumstances call sqlplus example

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

oracle sga statement adjustments

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;

. NET to call Oracle stored procedure, use an array of types of parameters (such as ArrayList)

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

Oracle to delete duplicate records

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

explore the nested loop join

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

maintenance oracle10g Undo tablespaces

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

oracle10g Undo tablespaces

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

Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077 Solution

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

MYSQL database instance on the query optimization technology

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

Learning Oracle - Statspack Analysis

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

How to start Linux. Shut down Oracle, as well as the closure of open monitoring

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 query tree

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 of the current session to amend the language of environmental parameters

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

Essays】 【Welcome to the MySQL-China discussion

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

gc buffer busy and read by other session

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

the relationship between father and son oracle recursive tree sort

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