Oracle

When the database has a serious performance problem or hang, the server side Sqlplus also can not connect, at this time if you want to get the current state information of the database, in order to diagnose afterwards, then we very much need to

When using PL/SQL, the first time you open the table, you will be prompted to "dynamic execution table is inaccessible, automatic statistics of this session is forbidden" error, a message is as follows: V$session,v$sesstat,v$statname is not

Here is an example of the official 11g document:Today, how to get the knowledge you need quickly from the official documents. Official online document Address: http://tahiti.oracle.com/almost includes documentation for Oracle's various products

The story of Ash and awr1.1 About AshAs we all know, when a user performs an operation in an Oracle database, it is necessary to create the appropriate connection and session, where all current session information is saved in the dynamic performance

Source of the blog post (exists and not EXISTS usage in Oracle): http://chenshuai365-163-com.iteye.com/blog/1003247Bowen Source (in VS. exists statement efficiency issues): http://www.cnblogs.com/iceword/archive/2011/02/15/1955337.htmlAexists (SQL

Create user Create an Oracle user group: sudo addgroup OracleCreate Oracle User: sudo adduser-ingroup oracle OracleAssigning root permissions to Oracle users: sudo gedit/etc/sudoersPress ENTER to open the Sudoers fileAdd under Root all=

1. Single table access : sub-table, partition , build cable , full table scan---Open parallel, always put it in memory, compression2. Multi-table Association, any time can only be 2 Table association, the resulting set of results and other tables

Ora-28000:the Account is locked-solution2009-11-11 18:51Ora-28000:the account is locked1th step: Use PL/SQL, login name System, database name unchanged, select type to change normal to SYSDBA;2nd step: Select Myjob, view users;3rd Step: Select

Web Api 2, Oracle and Entity FrameworkI spent about the trying of the "to" figure of the expose the Oracle.manageddataaccess 4.121.1.0 library over a Web API 2. 2 OData v4 Endpoint. Looking through the Oracle documentation, Oracle Managed Data

Sqlplus is a very concise management tool developed by Oracle, and Sqlplus is the best and most core Oracle management tool. Sqlplus is simple and efficient, giving up flashy, anti-basics. Using Sqlplus, go to Sqlplus and do a simple operation to

Operating system: windows2008Database: oracle11gProblem occurs: A set of normal run a year of application system, suddenly unable to connect to the database, but another application can be normal link, data storage normal.Database server-side

Use Cloning to install Oracle 11g, then use CADB to build the library error:ora-12547:tns:lost ContactFor such a not obvious mistake, it is very difficult to locate the problem of confirmation, the Internet gave a lot of advice:1, lack of bags,

Physical memory requirements: Minimum 1G, minimum 2G on windows7,windows8,windows8.1.Virtual memory (or paging space) capacity requirements: Available RAM Swap Space Required Between 2GB and 16GB Equal to the

Oracle RAC has both ha (high availiablity) and lb (loadbalance). And the basis of its highly available Failover (fail over)  It means that the failure of any node in the cluster will not affect the user's use, the user connected to the failed node

Common meanspartitions, hash-join, Data Warehouse functions, materialized views, bitmap indexes, etc. are common in the Data Warehouse technology,and the tips listed below are the most commonly used optimization tools/techniques in the project, the

Oracle RAC Learning notes: Basic concepts and Getting Started April 19, 2010 10:39 Source: Book's Blog book Editor: Xiao Xiong【Technical Development Technical Articles】Oracle 10g Real Application Clusters introduction1. What is clusterA cluster is

Oracle study--rman enable block change tracking errorSystem environment:Operating system: RedHat EL6Oracle:oracle 11g R2Target Db:prodCatalog DB:ORCLAfter making an incremental backup using Rman Backup, a ORA-600 error occurred while starting "Block

Some Oracle database query optimization suggestions are comprehensive, oracle Database 1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order. 2. Try to avoid null

Solution to oracle Database ORA-01654 errors, oracleora-01654 Introduction:Database suddenly reported: ORA-01654: unable to extend index BO. INDEX_indexname by 311072 in tablespace error, online query causes, found that there is only one solution,

Oracle BASICS (1): Use the oracle instance and SQL * plus commandI. Three-tier structure of oracle Database1. Client: used to access databases. Such as sqlplus and pl/SQL dev. 2. database Server-oracle dbms (database management system). This is what