Oracle

Today, we encountered an AIX system BUG where the Oracle database could not be started or even Nomount, And the instance Crash immediately after Nomount.The reported error is that PMON cannot be started.Extract alarm log information:PMON started

The stored procedure is written by flow control and SQL statements. The procedure is compiled and optimized and stored on the database server. You only need to call FienReport for use. There are two steps to call the Oracle stored procedure: Step 1:

Any database may have certain security risks during its long-term use. For database management Personnel should not only hope for the safe operation of computer operating systems, but establish a complete set of database backup and recovery

Recently, we need to optimize the efficiency of the Oracle database, and then check a lot of efficient methods on the Internet to determine whether the record exists.There are many suggestions for the first method on the Internet. I did a test, but

In normal project development, the paging stored procedure uses a large number of stored procedures. top is often used in the SQL Server paging stored procedure, and RowNum is often used in Oracle. Now, there is a UserInfo table, where one field is

Parse the oracle select locking method and the query of the lockI. oracle select locking methodCopy codeThe Code is as follows:Create table test (a number, B number );Insert into test values (1, 2 );Insert into test values (3, 4 );Insert into test

Some time ago, after installing oracle for the old girl, I found that the computer name of the old girl was long and difficult to remember. So I changed the name of my computer and did not expect this operation, but it's time to break down the old

Lpad usage in oraclePad Translation: FillThe lpad function adds the specified string to the left of the string. Usage:Www.jb51.netLpad (String, truncation length, added String ).It is said that adding strings is not accurate. A more accurate

When deleting a user in Oracle, the following statement is prompted: ORACLE cannot delete the current connected user:SQL codeSQL>Copy codeThe Code is as follows: select username, sid, serial # from v $ session;Username sid serial #-------------------

IN is mainly used to input parameters, which can be variables, constants, and expressions. The value cannot be changed within the subroutine.Copy codeThe Code is as follows:DECLAREN NUMBER: = 10;PROCEDURE do_something (N1 in number)

Oracle client NLS_LANG settingsOracleWindowsMicrosoftUnixBash1. Composition of the NLS_LANG ParameterThe NLS_LANG parameter consists of the following parts:NLS_LANG = _. The meanings of NLS_LANG are as follows:LANGUAGE:-Oracle message

1. IntroductionScript: a script is an executable file written in a certain format in a specific descriptive language, also known as a macro or batch processing file.Ii. BackgroundRecently, the oracle database has been installed in Windows. Because

1. intersect is the intersection of multiple query results;2. query the SQL statements recorded in the table within two basic periods;Select * from shengjibiao t where t. createtime between to_date ('2017-7-26 ', 'yyyy-MM-dd') and to_date ('2017-7-29

First, write a batch processing file and give an example.Copy codeThe Code is as follows:Set rq = % date :~ 0, 10%Exp system/system's password @ local service name file = d: \ backup \ bak % rq % full = yes log = d: \ backup \ bak % rq % buffer = 655

The principle is to declare constants, including the number of columns, number of rows, and attributes of each column, and then use these constants to control Cells in other procedures of the program. Very convenient for modification and

The implementation of Oracle regular expressions is in the form of various SQL functions and a WHERE clause operator. If you are not familiar with regular expressions, this article will show you about this new extremely powerful yet mysterious

1. Start-> Run. Enter SERVICES. MSC to the service and stop all Oracle SERVICES;2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal Installer. Uninstall all Oracle Products, but the Universal Installer cannot be deleted;3

Delete a user using the oracle command line:Copy codeThe Code is as follows:Connect/as sysdba;Shutdown abort;Startup;Drop user user1 cascade;Exit Create a user using the oracle command line:Copy codeThe Code is as follows:Create user user1Identified

Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we

The ORACLE tutorial is: Excellent Oracle performance. Increasing the SGA buffer seems to have not significantly improved the performance, and the loading time has only increased by 1.73%. Next we will increase the size of the SGA redo log:DB3: Log