Oracle

Familiar with DBAORACLE DatabaseThe common operation method has a very important role. The following lists several aspects: I. Oracle Database shutdown Methods For ORACLE, there are three methods to disable: In SVRMGRL, you can enter the following

I. Purpose of Optimization Application optimization can be divided into two aspects: source code optimization andSQL statement Optimization. Due to changes in program logic, source code optimization is costly in terms of time cost and risk

Following the previous introduction: After Oracle Database User-managed backup and recovery redo log, we will introduce backup of other files based on user management, includingArchive logsBackup andParameter file. Next let's take a look at this

Oracle DatabaseMediumAdd/delete set ElementsHow to Implement the operation? Actually useJavaFunction can be easily implemented. This article mainly introduces this implementation method. The source program is as follows:

Oracle 11gWhen developing a project, useXML TableA bug occurs, which is summarized as follows: the problem is actually very simple, that is, we use a lot of super-long SQL statements in the project, resulting in low SQL Execution efficiency, it

Oracle 10gError: shared memory realm does not exist analysis and solution is the content we will introduce in this article, the situation is as follows: an error occurs when connecting to Oracle 10 GB: "shared memory realm does not exist", as shown

Oracle Database date range queryThere are two methods:To_charAndTo_date MethodNext, we will introduce this process through an instance. Suppose we want to query the data from to. The implementation method is as follows: To_date method: select *

Oracle DatabaseVariousControl statementThe usage is what we will introduce in this article, including some logical control statements, the use of Case when, the use of While, and the use of, next we will introduce this part one by one, hoping to

OracleDatabaseDECODEImplement row-column conversion andCommon window functionsThe related knowledge is what we will introduce in this article. I hope this introduction will be helpful to you! Use DECODE to convert rows and columns The Code is as

OracleDatabaseKFOD view disk header contentThe related operations are what we will introduce in this article. Let's take a look at this part. The content of the disk header is intercepted here: [Oracle @ rac2 ~] $ Kfed read/dev/mapper/datap1

ConnectionOracle Virtual MachineAppearsOra-12154The knowledge about the solution to the problem is what we will introduce in this article. Speaking of ora-12154 problems, there are a lot of solutions online, the reasons are basically unified: tns or

OracleDatabaseDML commandThe processing process is what we will introduce in this article. From Oracle 9i, there are two undo Management Methods: Automatic Undo Management (AUM) and Manual Undo Management (MUM ). Before Oracle 9i, only MUM can be

Cloud computing, Iot, and mobile Internet are popular words in recent years. While these new concepts emerge one after another, a large amount of semi-structured and unstructured data is growing rapidly, pictures, audios, videos, social networks,

Recently, Oracle provided the release of NoSQL databases released not long ago. Currently, only the Enterprise Edition and the open-source community edition are available. That is to say, the source code is not available yet. However, you can also

BKJIA: I am a NoSQL user, and I am also very familiar with big data. This combination of skills is quite appropriate. As you can see, database technicians may discuss the topic "data growth is out of control" most. The relational database management

Error resolution -- ORA-01791 in oracle: not SELECTed expression error Oracle database, an error occurred while executing the following statement: ORA-01791: not SELECTed expression ": Select distinct t. name from auth_employee t order by t.

The demo of rman using catalog backup shows how to use catalog for RMAN backup and how to cancel the Backup Using catalog. Step 1: Create the rman catalog tablespace and users. [Oracle @ oel-01 ~] $ Sqlplus/as sysdbaSQL> create tablespace catalog1

The oracle 10g RAC node is restarted, but no valid log information is recorded-the problem diagnosis oracle 10g RAC is restarted, but no valid log information is recorded from: Oracle? Database Release Notes10g Release 2 (10.2) for Linux x86-64B15666

DBA classic interview questions (4) 1. What if the information collection management system (ICM) crashes? Answer: All other managers will continue to work. ICM only processes the queue control request, which means to enable and disable other

In a new environment, the company needs to install RHEL (Red Hat EnterPrise Linux, the same below) 5.5 64-bit and Oracle 11g 64-bit in a virtual machine environment, so it has been tossing for three days, the pain, only the person who knows. Here,