Buffer Cache is an area of the SGA area that is specifically used to store copies of blocks of data that are read from the data file. If the Oracle process finds that a block of data that needs to be accessed is already in the buffer cache, it reads
To use an Oracle database, the user first has to establish a connection to the database. For database connections, Oracle offers two solutions: private and shared connections.
In most cases, we use a private connection. For a private connection,
Oracle provides us with very rich aggregate functions, such as Sum\avg\max. In addition, we can write our own aggregate functions, of course, custom aggregate functions can also be used as analytic functions.
Custom aggregate functions are not much
Absrtact: By discussing and studying the characteristics and principles of Oracle Server and Client/server, this paper expounds some principles and methods of improving and adjusting the performance of Oracle Application system.
Keywords: Oracle;
Oracle Log Analyzer Tool Logminer use
1. Set Date format
Alter system set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss ' scope=spfile;
Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual;
2. Add Supplemental Log
If the database needs to
Prior to using EXP, IMP Lead Library command successfully implemented the Oracle database export, import, on this, yesterday again to the server's newly installed Oracle database with EXP, IMP Guide library, has been reported as "EXP-0006: Internal
oracle| Design | Optimization Preface
The vast majority of Oracle database performance problems are caused by unreasonable database design, only a small number of problems rooted in db Buffer, Share Pool, Redo Log buffer and other memory module
oracle| Data | database
Integrity constraints are used to enhance data integrity, Oracle provides 5 kinds of integrity constraints:
Check
Not NULL
Unique
Primary
Foreign Key
Integrity constraints are a rule that does not occupy any database space.
Client|oracle
Install Oracle Client on Solaris
To install Oracle client on Solaris 5.8, please follow this steps:
1. Create a user account on Solaris, just like:oracle9i.
2. Log on Solaris with the account.
3. Download The Oracle 9i (bit)
oracle| Conversion | string
How to implement the ASC string and 16-string conversion in Oracle
Welcome everyone to communicate with me: Enhydraboy enhydra_boy@tom.com
Welcome to reprint, please keep this statement, thank you!
The following is the
There are generally 2 ways to connect to Oracle in a JSP:
1, Oracle jdbc Oci8 Way
2, Oracle jdbc Thin way
I prefer the 2nd, because the Web publisher and the database server are generally not on the same computer, and when using thin connection,
The decode () function is one of the most powerful functions of Oracle PL/SQL and is currently available only to Oracle Corporation, where SQL implementations of other database vendors do not yet have this function. The Decode function is one of
One: Multitenant Architecture (12.1.0.1)Multi-tenant architecture is the new heavyweight feature of Oracle 12c (12.1), built-in multi-tenancy (multi-tenancy), a container database (container) that can hold multiple pluggable Databases, Each
Case has two formats. Simple case function and case search function.--Simple Case function Case Sex When ' 1 ' Then ' men ' When ' 2 ' then ' women ' Else ' other ' END --case search function case If sex = ' 1 ' Then ' man ' When sex = ' 2 '
Download the process slightly, after downloading the two compressed package decompression, merging:Right-click the administrator to execute the Setup program:This step can skipChoose to install only the database softwareSelect single-Instance
http://blog.csdn.net/gyflyx/article/details/6889028Reference one, explicit cursorExplicit is relative to the implicit cursor, which is the cursor with a clear declaration. The declaration of an explicit cursor is similar to the following (the
I am learning Oracle is to do notes and experimental code records, the content is very full, but also quite detailed, send a blog post to the needs of friends, a total of 1w learning notes. is done before, has been at the bottom of the pressure,
Oracle SQL Language Foundation and Environment readiness-beyond OCP proficient Oracle Video Tutorial Training 26This course introduces:Oracle Video tutorial, wind Brother this set of Oracle Tutorial training is the > 1th 5 sets: basic introduction
--1.left Join left table is the primary table, left table returns all data, and the right table only returns data that matches the left table.Select T1.fpdm,t1.fphm, T1.ZJR,T1.ZJSJ,T1.ZJJX,T1.ZJJE,T1.ZFLX,T1.ZFID,T2.FPDM,T2.FPHM,T2.ZFLX from
In the 11g cluster, we usually use the initialization file (pfile) under dbs to specify the actual spfile in asm.[Oracle @ ol6-112-rac1 dbs] $ cd/u01/app/oracle/product/11.2.0.4/db_1/dbs[Oracle @ ol6-112-rac1 dbs] $ lsHc_acfsdb.dat hc_cdbrac_1.dat
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service