Oracle

Sometimes we need to do a trace analysis of the specific execution of SQL execution, especially when application performance is optimized. Oracle two tools can help us do performance analysis, one is Sql_trace, the other is session_event. Sql_trace

Today, when installing the BO Server, Oracle database, there was a problem with the following description:Install the oracle10g Server 32-bit version first. After installing the ORCL database, using Net Manager under 10gServer to access ORCL, two

That is, static registration, listener do not know the status of the instance, only when the process through its connection to the database to know, if you want to use the remote management database to use static monitoringDynamic registration:

When we use Oracle, we can use Oracle's own EM (Enterprise Manager) to make it easier to manage our databases. But sometimes our EM can not be connected, the cause of this problem is many, such as the lack of proper configuration hostname, or the

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

Recently in the system development need to want to insert more than 4000 bytes of Oracle database Clob field, on-line query for n long to find the following solution, it is retained for later investigation.We can be successful by creating a separate

reprinted from: Http://www.cnblogs.com/rootq/archive/2008/11/17/1334727.html (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 a right-to-left

Recently in the Oracle Sqlplus Official document, the Sqlplus Security section describes the PUP mechanism. With this, I'll use the following:PUP (Product_user_profile) IntroductionProduct_user_profile is the next table in the system account to

OCI: To install the Oracle client, the portability is slightly poor, the theoretical performance is betterTHIN: Belongs to TYPE4, pure Java implementation, good portability, theoretical performance slightly worseRecommendation: It is best to use

Summary of advantages and disadvantages of ORACLE five tables:1, Normal table (heap table): Suitable for most design scenarios, there are advantages and disadvantages.Advantages:A, the syntax is simple and convenientb, suitable for most

Brazil: Tactical Play: 4222 no wavering, no suspense in the structure of the main lineupno objection to the core system, 4222 complete Interpretation, the architecture is so clearTop teams in the world: BrazilDatabase Technology Core Team:

Transferred from: http://blog.sina.com.cn/s/blog_a32eff28010136d9.htmlLog or archive log to obtain data additions and deletions change, and then apply these changes to the target database, the source database and the target database synchronization,

PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. At the same time, PL/SQL is a procedural languageCalled the process SQL language (procedural language/sql). PL/SQL is an

ConceptContains some basic concepts and principles of Oracle database, such as database logical structure, physical structure, instance structure, optimizer, transaction, etc. PDF 460 PageReferenceIncluding dynamic performance view, data dictionary,

Import and export and conversionImport and export is a commonly used data migration and conversion tool, because its export file is platform-independent, so in cross-platform migration, the most common.In the export operation, it is very important

Different cluster products have their own characteristics, RAC features include the following points: • Dual-machine parallel. RAC is a parallel mode, not a traditional master and standby mode. That is, all members of the RAC cluster can receive

ORACLE materialized view and oracle Materialized View In the last few days, I have provided a View to the W System in the P project environment. Due to the complicated query logic and large data volume, the query speed is slow each time a view is

I. OverviewSome time ago, a DBA friend failed to run the business on the morning of the next day after he finished the rename operation and encountered the restriction and error that the data could not be inserted, the error is that after the table

I recently used the vmwarevm to perform ORACLE Database experiments. We all know that on WINDOWS, I can add and delete programs to automatically delete all installed applications, however, this service is not available in LINUX for automatic

Solaris X86-64 ORACLE 11.2.0.3.8 patch:Correct steps:1. patch for BUG6880880 and OPATCH2. Patch 11.2.0.3.8 for BUG16902043 I feel like I have to practice it. I think it's easy to get things done. I think you should be careful if you have any