Oracle

--User sql>--Create a user named Grace password is password, the new user does not have any permissions sql> create user grace identified by password; Authentication User: Password authentication method (user name /password) external authentication

Oracle optimization of database memory parametersØ Oracle -related system kernel parameters Ø SGA,PGA parameter setting Oracle lower disk storage performance OptimizationØ File System selection (ext2/ext3,xfs,ocfs2) Ø Oracle ASM storage 1. What

Background:A table suddenly appears query very slow situation, cost 100+ seconds or more, seriously affect production.Original sql:Explain plan for SELECT * FROM (select ID id,ret_no retno, From_sys fromsy, To_sys Tosys, Command_code Commandcode,

The concept of partitioning tables and tablespaces is distinguished between the design of Oracle partition tables: tablespace: A table space is a collection of one or more data files, all of which are stored in the specified table space, but are

Oracle server-side operations are generally as follows:　1) Installing Oracle Server Software2) Create database (automatically created at installation)3) Configure monitoring (automatic configuration at installation)4) Start Oracle Instance5) Create

The computer is Win8 64-bit, installed Oracle 11g R2 64-bit, who knows everything is finished, open the project but not even the Oracle data ...The first is the PL/SQL connection, installed Oracle server, should not be installed client, PL/SQL

Original: http://www.cnblogs.com/wujin/archive/2012/02/02/2336055.htmlThere are many application projects, just start with MySQL database can basically achieve a variety of functional requirements, with the increase in application users, data volume

Specify user name password to start the Management ServerYou can start and stop Oracle WebLogic Server administration Servers using the WLST command line or a script. When you start or stop the administration Server, you also start or stop the

SELECTItm. SEGMENT1 Material CodingItm. DESCRIPTION Material Description, Bom2. Creation_date Date Created, BOM2. Alternate_bom_designator Alternative BOM, fu.description operatorFrom INV. Mtl_system_items_b ITM,Apps. Bom_bill_of_materials

Rediscover Oracle's Beauty orainstroot.shWhen we install the database software, we will execute orainstroot.sh, and today we will take a closer look at what this script is for.Platform is redhat 6.4 x64 bit, database version is 11.2.0.4.2Here is the

Both date and timestamp can be added and reduced.There are three ways to manipulate different time types for the current date Gagnin, month, day, hour, minute, and second:1 add hours, minutes and seconds using built-in functions Numtodsinterval2

One: Oracle tablespace1,oracle table Space vs. SQL Server file GroupSQL Server filegroups (filegroups include several MDF,NDF data files) are not unfamiliar to us, some time ago in my blog "How to play Tens other data" mentioned the concept of table

with Oracle vitual Box cloning a virtual machineWhen we need to use more than one virtual machine, if a single installation, it is too troublesome. Therefore, the general virtual machine software provides us with the ability to clone the existing

Two ways: 1. Ip+sid Mode 2. Configure link mode1..ip+sid WayDbhelperoracle.connectionstring =string. Format (@"Data source= (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL =

Chapter II ASM INSTANCEASM Instance Type:After 10g, the Oracle instance type adds an ASM type, and the parameter instance_type=asm is set.ASM Instance startup command: Startup NomountLaunching instances and background processes, but not mounting

The first time with PL/SQL developer This unofficial software, encountered a variety of difficulties, fortunately through the almighty Google has been all resolved, recorded down to be observed. The premise is to ensure that your remote Oracle

Oracle Ebs R12 SLA and GL relationship changes SLAConcept: SLA (Subledger Accounting)A subaccount is short for subledger accounting. Its literal meaning is the subledger accounting entries. SLA & GLLink: R12The MOAC feature is enabled in the

I. Note: Some tables in the OLTP database have a large amount of data and a large amount of data is continuously increased every month. Because historical data is not accessed in this database, it is analyzed in another OLAP database, therefore,

Oracle Database Installation diagram and basic command line usage 1. Oracle Database Installation 1. Download the oracle database software Http://download.oracle.com/otn/nt/oracle11g/win32_11gR1_database.zip 2. decompress the

Oracle elastic cloud and data warehouse provide obvious advantages. First, a single vendor provides all the basic components: Oracle's one-stop approach helps simplify licensing, support, upgrade, and integration, all these transactions are handled