Oracle

Oracle Online tuning redo number of log groups and group membershipsFirst, adjust the redo log group sizeOperation Reason:Redo log general settings allow the log conversion time to 10-20 minutes, and the conversion too often affects performance.

Reference URL: http://jingyan.baidu.com/article/0320e2c1d4dd0b1b87507b38.html Now that you're linking to the Oracle database, the first step is to open our Oracle database (log in with Scoot users after logging in to Oracle) 2The second step

Later, the statement is added to the build table.Existing two tables, WESTEMP staff table, with (wtdempid,wtdempname,wtddeptid) column, westdept Department table, there (wtddeptid,wtddeptname,wtddeptaddress) Column. Where westemp.wtddeptid can be

Member Store TypeIn addition to outline calculations, another important attribute of dimension members is the storage type, which determines how the dimension member-related cells are physically stored. The "Data Storage" property of the member is

With Oracle 11g for a long time, really feel is a very heavy client, installation will take one hours, recently started to contact this lite version of the database client, tinkering with the half-day, finally success.1. Download the client2.

--Time: January 27, 2016--author:zhenxing Yu--Query Recycle BinSELECT * from RecycleBin;SELECT * from User_recyclebin; --user_recyclebing and RecycleBin are synonyms, the fields are exactly the same--Turn the Recycle Bin on or off--A: Session level

Restart the Oracle database command and ALTER LOG today:[Email protected]:~> sqlplus '/as sysdba 'Sql*plus:release 11.2.0.3.0 Production on Wed Jan 27 18:49:13 2016Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database 11g

/** * string Split function. * @param p_str The string to be split * @param delimiter * @return Custom table type Ty_str_split. * Use the method select Column_value from table (Fn_split (', ', ')) * @Author: Xder */create OR REPLACE FUNCTION

??Kettle Version 4.1.0 Open the Spoon software and double-click Spoon.bat under Windows. Creates a transform. Create two data sources, one for Oracle and one for MySQL. CREATE TABLE input.

This article transferred from: http://www.cnblogs.com/wuhuacong/archive/2012/03/09/2387680.htmlThe management of data objects and data in Oracle is undoubtedly managed using PL/SQL developer, which also provides us with a lot of convenient and fast

http://blog.csdn.net/phacker2010/article/details/71901261. InstallationOracle version:Oracle DatabaseG Release 2 (10.2.0.1)：Http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.htmlInstallation settings:1) The

Oracle installation processThe first time to install Oracle yourself, before the Oracle installation configuration is not understanding, and finally finished. Summarized below.1, install Oracle10gserver end2, install Oracle10gclient.Server side and

Using the SYS or System/manager as SYSDBA; Connect to the database. Create a regular user konglin:create users konglin identified by Pwd_oracle; Delete users, drop user Konglin; Grant user permission to log on to the database:

1. Create DATABASE personCREATE TABLE number, name Nvarchar2 ( number , sex nvarchar2 ( $ ), Password nvarchar2 ($))2. Create a type in the database that corresponds to the object structure to be passed to the Java side: CREATE OR REPLACE TYPE

Oracle creates a create user and authorizes grant to view logged-in users:Here's what you can do:Show user;Select Sys_context (' Userenv ', ' Session_user ') from dual;Select User from Dual;To view all logged-on users, you must be a DBA User:Select

Haven't written a blog for a long time. I don't know what to write.Today, let me clear a table of data, the result is clear, the system is not moving, as if the server hangs dead.Later found a half-day to find that the original is I delete data

Solution to ORA-12154: TNS: couldnotresolvetheconnectidentifierspecified when PL/SQLdeveloper connects to oracle Use the PL/SQL developer tool to connect to oracle. An error is reported during logon: ORA-12154:TNS:could not resolve the connect

Variable Length array in oracle varray, nested table, set usage, oraclevarray Create a variable-length Array CREATE TYPE varray_type AS VARRAY(2) OF VARCHAR2(50); This variable-length array can accommodate up to two data types: varchar2 (50) Change

Common Oracle and SDE maintenance commands-view tablespaces and so on, oraclesde Previously, I reported a data update problem on the site. I thought it was caused by the full table space (the error was written in the previous blog article).

[Translated from mos] protocol used by the private network and OracleRAC It is too classic to translate. Source: Network Protocols and Real Application Clusters (Document ID 278132.1) PURPOSE------- Purpose of this document is to give DBAs and