Oracle

A series of reports from the software ecosystem:Oracle EcosystemAccording to the evaluation, with the continuous acquisition of Oracle, the comprehensive competitiveness of its ecosystem has rapidly increased in recent years. In particular, after

Windows 7HowUninstall Oracle 10g 64-bitWhat about databases? This article mainly introduces this part. Oracle 10g 64-bit of Windows 7 was previously installed on the host. Since PL/SQL DEV is not compatible with 64-bit Oracle, only 64-bit Oracle10g

OracleDatabaseAnalysis functionsThe ID in which the search status of an application instance is all 1 is the content we will introduce in this article. Through the example in this article, let's take a look at the use of Oracle Database analysis

  A very powerful function in Oracle is to convert functions written in Java into functions in Oracle databases. after conversion, we can use it like a common function. because Oracle is developed in Java, it is naturally compatible with Java. let's

  C: \> exp businessdata/businessdata file = dropcol. dmp tables = ACSTRULE, ARREARSCFG, role al_account, role al_account_his, INVOICE, INVOICE_HISTORY, role, RULCOCAP, STEVREAC   Export: Release 11.2.0.1.0-Production on Mon Dec 5 19:59:39

 SQL:> select numtodsinterval (365, 'second') from dual;Result: + 000000000 00:06:05. 000000000; SQL:> select SUBSTR (numtodsinterval (365, 'second'),) from dual;Result: 00: 06: 05; SQL:> select to_char (to_date ('201312', 'ssss'), 'hh24: mi: ss')

The database used by the customer is mysql, and the developed product supports oracle, We must switch the database environment from oracle to mysql. We encountered the following problems during the conversion process, hoping to give some reference

ORA-12838: cannot read/modify a object after modifying it in parallelThis error occurs during the call process. After query, it is because the append insert operation is not submitted in time during the process. The exact explanation for this

Differences between the Oracle optimizer CBO and RULE 1. When the Rule-Based Optimization (RBO) optimizer analyzes SQL statements, oracle rules are followed and are not sensitive to Data. It uses only a small amount of information to determine the

An article written in the previous troubleshooting section was accidentally found in the analysis of node cascade restart failures of rac clusters, which was recorded for future search. Www.2cto.com rac cluster node cascade restart Fault Analysis

ORA-06502: PL/SQL: Number or value error: String Buffer too small error analysis 1. problem cause this error is always encountered when you recently perform some oracle operations: ORA-06502: PL/SQL: Number or value error: string buffer is too small,

Oracle network configuration and connection management oracle network configuration, for the use of PL/SQL Developer to connect to Oracle errors, especially when the network environment changes caused by connection errors. The listener. ora, sqlnet.

Oracle utility: oradebug 1 oradebug introduction oradebug is mainly used by oracle support staff. Although it was very early, it is rarely recorded on the oracle official website. It is an SQL * plus command line tool. You can log on with sysdba

Solutions for handling Oracle SQL in over 1000 ,..., 1000,100). If the clause contains more than 1000 entries, an error is returned. This is mainly because of oracle's restrictions on performance. If you want to solve the problem, you can use where

Oracle rman automatic backup script #! /Bin/sh. /opt/oracle /. bash_profilePWD_SYS = "/" BAK_DIR = "/opt/oracle/backup/oatest" BEGIN_SEQ =$ (sqlplus-s $ {PWD_SYS} 'as sysdba' /opt/oracle/backup/oatest/backup_rman.log 2> & 1 & 

To export (import) the oracle import and export documents in detail, use % ORACLE_HOME %/db_1/BIN/exp.exe(imp.exe) to configure the environment variable path, and then directly use the exp command Export ----------------------------------------------

Oracle 11g Alert Log location Oracle 11g Alert Log location 1. Obtain ADR-related information by querying the v $ diag_info View ADR(Automatic Diagnostic Repository)--> A a file-based hierarchical data store for managing diagnostic information,

Date-related operations are currently used. 1. Obtain the date of the current week and Monday. select trunc(sysdate, 'yyyy') - to_char(trunc(sysdate, 'yyyy'), 'd') - 5 + (select to_char(sysdate, 'ww') from dual) * 7 startweek from dual;  2.

Using PL/SQL profiler to locate PL/SQL bottleneck code for SQL optimization, you can use SQL tuning advisor to achieve automatic SQL optimization and adjustment. For PL/SQL code, there are both SQL code and PL/SQL code. It is far from enough to use

DBA classic interview questions (1) 1: List several table join Methods: hash join, merge join, nest loop join (cluster join), and index join 2: no third-party tools, how to view the SQL Execution Plan set autotrace on if the following error occurs: