Oracle

Just passed OCP last exam, from the training to review and complete the exam for a total of one months, the whole process is very compact also very nervous, very lucky or passed the exam, also not in vain this month's hard. First is the training,

The main function of library cache is to store user-submitted SQL statements, SQL statement-related parse tree (parse tree is the representation of all objects involved in SQL statements), execution plan, user-submitted PL/SQL program block

1. Table Space (tablespace) A table space is a basic logical structure in a database, a collection of data files. A table space can contain multiple data files, but a data file can belong to only one table space. Query table space: Sql>select *

JSP connection MySQL Database methodFirst copy the MySQL database connection driver to the Tomcat/common/lib package Download Mysql-connector-java-5.1.6.zip Http://mysql.cs.pu.edu.tw/Downloads/Connector-J/mysql-connector-java-5.1.6.zip Configure

There are three different ways to throw an exception 1. Run-time engine via Pl/sql 2. Using the Raise statement 3. Call Raise_application_error Stored Procedure When a database or Pl/sql error occurs at run time, an exception is thrown

--Connection Recovery Manager C:\Documents and Settings\mengzhaoliang>rman target/ --Archive Log list rman> list Archivelog all; --Delete archive logs that do not exist for physical files rman> Delete expired Archivelog all; --Delete the archive

First, the operating environment to build System: WINDOWS7 flagship 64-bit PHP Environment: wampserver2.2e-php5.4.3-httpd2.2.22-mysql5.5.24 32-bit versionDownload Address: http://www.jb51.net/softs/161568.html thinkphp:3.2.3 Official

Recently make a batch import requirement, insert multiple records into the database in bulk. Solution: Encapsulate a list object in a program, and then insert the entities in the collection into the database because the project uses MyBatis, so you

Objective Whether in the development of B/s or C/s, JavaScript is basically not used to operate the database. And I have a idea that I need to add a lot of news class information to the database, so I want to get the information from each RSS site

(1) Select the most efficient table name order (valid only in the Rule-based optimizer): The Oracle parser processes the table names in the FROM clause in Right-to-left order, the last table (driving table), which is written in the FROM clause, is

I. Classification of audits: Oracle Audit in general can be divided into "standard audit" and "fine-grained audit" the latter also known as "policy-based Audit", after the oracle10g function has been greatly enhanced. Standard audit can be divided

When the data in the table is deleted, it does not actually delete the data, but instead it makes a deletion mark that can be recovered as long as it is not overwritten. The experimental process is as follows: Sys@orcl>create table Bbed_test (x

Called a Oracle local Registry (OLR): Each node in a cluster has a local Registry for node-specific Test one: Simulate OLR abnormal loss: Here first will OLR Renam [Root@vmrac2 cdata]# MV VMRAC2.OLR Vmrac2.olr.bak And then try to start CRS.

Database concurrent access, where two or more users access the same data at the same time, is the biggest problem for the database engine to design and implement a moderate response. A well-designed, performance-capable database engine can easily

On the itpub, I saw someone raise the question. In SQL Server or some other database, DDL statements can be rolled back, so why can't oracle rollback DDL statements? To illustrate this issue, first you need to explain what a DDL statement is. A DDL

OS Certification Server-side OS authentication is enabled by default after Oracle installation. That is, the user and password check on the login database at the operating system level, you have the Oracle installation of the user operating system

Case 3: (Recover tablespace, database open state) --database Recover data files in open state (except system tablespace) (1) Simulation Environment: 06:10:52 sql> INSERT INTO scott.t01 values (4); 1 row created. 06:13:12 sql> INSERT INTO

Problem one: such as Paugaca JDBC driver: Normally we have three ways to load drivers: 1) class.forname (string) this would like to be a class specified by a String that initializes the static content of the driver at load time, ClassLoader In

Oracleenterprisemanager (Oracle Enterprise Manager, abbreviation OEM) provides management services for managing distributed environments through a set of Oracle programs. OEMs include a set of DBA tools, a repository, and a graphical display of the

Case study (1) Let's say I modified a piece of data: Update people set name= ' Fusnow ' where name= ' old Fusnow '; The things I need to do include: Generate redo information in redo log buffer (including Redo,undo redo of the table, index or