Oracle

First, the database administratorEach Oracle database should have at least one database administrator (DBA), and one DBA is sufficient for a small database, but for a large database it may require multiple DBAs to share different management

I. Overview Oracleebs is the ERP product of Oracle company, this product is very large, can carry on the powerful management function to each aspect of the enterprise, the general enterprise will use some of its module, according to the nature of

Original address: View and modification of the Oracle character set Piaoliuxiongfirst, what is Oracle Character Set The Oracle character set is a collection of

Today is 2014-05-27, today encountered a Lib problem, record again. This is a case, but also a way to solve the problem of the process.When we use Sqlplus to log in to a UNIX database, there is a possibility of a similar problem: xxxxxx bad ELF

Dynamic Performance View The structure of the memory used to access the instance is constantly changingstatus information. In Oracle DB, you also maintain a dynamic dataset of database instance operations and performance. These dynamic

To connect to an Oracle server, the client must have an Oracle client installed, however, the normal Oracle Client installation package is large and takes a long time to-instant client1. Download the installation

After a few years of Oracle's book, I have a little experience with different books. Many friends let me recommend some Oracle books, below I will say my opinion.In fact, at different stages, different books will have different effects on you,

Today, the ORA-01756: quoted string not properly terminated error occurred while importing data using volume El. Now I 've sorted out some solutions that are commonly used in oracle. Error 1: ORA-01756: quoted string not properly terminated Chinese

I have been working on Oracle databases for more than a year. My favorite part is PL/SQL. This is Oracle's data programmable language, which can be used to combine procedural code with SQL code. The most interesting thing is that we can use it to

This article mainly describes several tips for connecting Oracle databases through JDBC, and connecting JDBC with a Java Database) APIs are a series of practical interfaces that allow Java programmers to access the database correctly, different

We have provided an overview of the unique features of Oracle 11g R2. At the same time, we also describe the enhancement of the data warehouse performance related to Oracle 11g R2. The following describes the enhanced features of Data guard in

We all know that Oracle SQL Trace and 10046 event are common tools used to diagnose Oracle database performance. However, when the level is over 1, 10046 events are generally called extended SQL trace. It is mainly used to diagnose the performance

The methods defined by the oracle function return type as record may not be available to everyone. The following describes an oracle function return type as record-defined instance for your reference. CREATE OR REPLACE Package pkg_test /*

Oracle handbookSeriesVirtual Private Database VPDThe usage is what we will introduce in this article. VPD, Oracle Virtual Private Database, that is, Oracle Virtual Private Database, refers to the application of some policies, this allows users to

On April 9, June 2013, Oracle officially released Oracle Database 12C release 1. It is as follows: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html According to Sina Weibo, a well-known Chinese DBA, guobiao,

Random acquisition of any row of data (rownum) in the oracle database, using lerownum Recently, when reading oracle data, I learned the concept of rownum. I used to only know how to add, delete, modify, and query database tables; After seeing the

OraceleTimesten connects to DSN to create a user 1. Enable startup [Tt @ host2 info] $ ttDaemonAdmin-start-force /Home/tt/TimesTen/tt1122/info/timestend. pid file exists, attempt start due to-force option. TimesTen Daemon startup OK. 2. Add the test

  Wait for the event source to start The concept of wait events is introduced from ORACLE 7.0.12, with roughly 100 wait events. In ORACLE 8.0, this number has increased to approximately 150, with approximately 220 events in ORACLE 8I and about 400

3. database cache size We talked about how to share execution plans from the programmer's perspective. Next let's take a look at what DBA can do for the shared execution plan. First, we need to know that the execution plan of each statement is saved

The following three statements under alter system flush "oracle cache" are designed to refresh the oracle cache. Here is a summary. 1) alter system flush global context description: www.2cto.com for multi-layer architecture, such as: the application