Oracle

A large number of zombie processes have been eliminated in the previous article, but this approach can only be palliative and not permanent. In addition to the large number of Racgmain check processes seen in the operating system, some Racgimon

Oracle Resource Manager (Oracle Database Resource Manager, hereinafter referred to as DBRM) manages database resources and assigns different database resources to different sessions. The resources managed by DBRM mainly include CPU time. The

Error when creating EM: Configuration: Failed to unlock Mgmt_view account 2013-4-29 22:47:03 Oracle.sysman.emcp.EMReposConfig Invoke Critical: Unable to unlock all EM related accounts 2013-4-29 22:47:03 Oracle.sysman.emcp.EMConfig Perform

In the 9.2.0.8 RAC Environment, use EXP to dmp any error (per table, exported by user, remote EXP export using TNS method), including export after restarting the database, cannot be imported into other databases (this library, TNS method remote

When two tables are joined, if the data row in table 1 appears in the result set and needs to be judged by at least one matching row of data appearing in table 2, in this case, a semi join occurs, and the inverse join is a partially joined

This error often occurs in an Oracle database after an illegal shutdown: Exp-00056:oracle Error 1033 appears ora-01033:oracle initialization or shutdown in progress User: Password: This is obviously the database does not have the

Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as

The recent merger of Oracle and Sun has been a major concern for many developers, mainly because of the potential for new changes in the MySQL database, which this week made 10 promises to MySQL users, developers and customers. Oracle has had a

oracle| optimization Oracle Optimizer: Migrating to using the cost-based optimizer-----series 1.1 If you are developing an application in a previous version of Oracle (7.0 or earlier), the database uses the Rule-based optimizer (RBO), which will

oracle| Backup | strategy | recovery | data | database SummaryThe recovery of lost database files depends to a large extent on the backup strategy used. Based on the flexibility of recovery, this paper discusses the backup and recovery strategy of

The general To_char is such a to_char (Sysdate, ' yyyy-mm-dd hh:mi:ss am '), and there are several points of use for the book To_char (sysdate, ' DD ') see what date it is today To_char (sysdate, ' ww ') view this is the first few weeks of the

Oracle 11G when exported with export, empty table can not guide 11G R2 has a new feature, when the table has no data, do not allocate segment to save space WORKAROUND: Insert a row, then rollback will produce segment. The method is to insert data

The external table introduced in Oracle 9i allows you to map a sequential text file to an Oracle table definition. Once you have defined an external table, you can apply all the functionality of the SQL SELECT statement-including parallel queries-to

RAC, Data Gurad, Stream are three tools in the Oracle High-availability system, each of which can be used independently or in conjunction with each other. Their respective emphasis is different, the application scenario is also different. RAC its

For the dbms_random described in the previous article. In the case of the value function, it is obvious that the call to the function occurred during the execution of the SQL statement. However, if you look at the processing of constants in SQL

1, read-only table space recovery By default, Rman does not restore a read-only data file when performing a full recovery database restore operation, even if a read-only data file is lost. To restore a read-only data file during a full recovery,

After looking at a number of paging stored procedures, it was found to be for SQL Server, without Oracle, so I wanted to write a stored procedure about Oracle because the database I used was Oracle. --------------------------------------------------

Oracle Performance optimization statistical information management-beyond OCP proficient in Oracle video tutorial training 32This course introduces:Oracle Video tutorial, wind Brother this set of Oracle Tutorial training > 2nd 10 Sets: Oracle

The DECODE function is Oracle PL/SQL is one of the most powerful functions, and only Oracle SQL provides this function, and the SQL implementations of other database vendors do not yet have this function. What is the use of decode? Let's first

This is an emergency data recovery case from a customer we received yesterday. Generally, the database cannot be open due to power loss. After preliminary troubleshooting, it is confirmed that the database version is Oracle 11.2.0.3 (linux RAC) and