Oracle

I sent a blog post two days ago. Win7 started Oracle error, so I installed the latest version of Oracle oracle11g, this may be because I am more interested in Win7, otherwise I do not want to use a high version of Oracle installed to install,

This article from the following aspects to collate the concept and operation of the partition table: 1. Table space and the concept of partitioned tables 2. The specific role of table partitioning 3. Advantages and disadvantages of table

Patrol content 1. Check database basics In this section, the basic state of the database is examined primarily, including: checking Oracle instance status, checking Oracle service processes, and checking the Oracle Listener process for a total

Install Oracle 9i, unexpectedly changed the database administrator password to forget, and do not reinstall, too troublesome, tried for a long time, finally modified successfully. 1, run to C packing directory 2. Input: SET oracle_sid = your SID

Oracle performance analysis in the introduction of learning, encountered Oracle database performance problems, the most important step is to export the AWR analysis report, AWR is a new tool introduced in 10g, before this is generally the use of

1. Oracle differs from SQL Server 2005.On the macro level:1. The biggest difference is that the platform, Oracle can run on different platforms, SQL Server can only run on the Windows platform, because the stability and security of Windows platform

In the recent use of Oracle, if the concurrent state inserts data will result in duplication of data, the need to use Oracle lock mechanism, the following is a common Oracle lock table method. First, row-level locks:(The following sentence will

Today, a co-worker called me and asked me about this problem that was listed in my daily development, and it's true that both of them are related to grouping, but note that one is a grouping function and the other is an analytic function, The table

Original in August 02, 2009, October 22, 2009 migration to this. Oracle Analysis Function--sum,avg,min,max,count SUM Function Description: This function calculates the cumulative and the expression in the group. Sample: The following example

First, firstly: the cause of the problem, I previously created in the f:/llh/directory of a bookspace table space, and then do not want to this table space, so I directly deleted, this error is because I will f:/llh/bookspace.dbf and several files

ORACLE10G Certified Associate (OCA) is certified by Oracle's database Assistant engineer, also known as Oracle Technology entry-level professional certificate, with OCA certification that you have the basics of getting started with large Oracle

Install Oracle 11g R2 Prerequisite Check Failure resolution collection to mobile phone forwarding Comments 2012-03-28 10:43Physical memoryPhysical memory-This prerequisite will test whether the total physical memory of the system is at least 922MB (

Original: http://space.itpub.net/24778843/viewspace-693743 Brief introduction: This article provides a comprehensive overview of the relevant concepts of the Oracle execution plan, access to data, connectivity between tables, and more. and a summary

Download Oracle Database 11g with wget Daniel September 23, 2014 Leave a comment The project needs to deploy a new Oracle server, the room bandwidth is much faster than its own download, all to find ways to download the installation files directly

Oracle database is one of the most complex databases so far. It is this complexity that allows Oracle databases to face a wide variety of business needs. But most of the time, database administrators have some skills to make database maintenance

What is a stored procedure. is a collection of SQL that can be manipulated programmatically. the advantages of stored procedures. execution is efficient because the stored procedure is precompiled, that is, when the compile is created, and the

Oracle Lookup Duplicate Records SELECT *From T_info AWHERE (SELECT COUNT (*)From T_infoWHERE Title = a.title) > 1)ORDER BY Title DESC One. Find Duplicate Records 1. Find all duplicate records SELECT * FROM table Where repeat field in (Select

Today, you need to test a tool in an ASM environment that lacks a test base for the ASM environment, so migrate a single instance of a filesystem to the ASM for testing and record To install the Configure ASM instance this is not repeated here. 1,

One. To see if the Oracle database is in archive mode:1.select Name,log_mode from V$database;NAME Log_mode------------------ ------------------------QUERY Noarchivelog2. Use archive LOG LIST commandDatabase log mode No Archive modeAutomatic Archival

Stored procedures are an essential tool in a database system, and stored procedures are precompiled sets of SQL statements that implement a complex function. The advantages of it I will not say more, to talk about the problems I encountered. In the