Oracle

Anyone who has used Oracle databases knows that the speed and efficiency of Oracle databases are among the best among similar databases, especially when accessing a large amount of data. So what is Oracle Database implemented? I will use a series of

Solution to Oracle database running errors: Error 1: ORA-01034: ORACLE not available After Oracle is installed and started, use sqlplus "/as sysdba" to log on. If you run any select statement, an error occurs: Select * from dictionary * ERROR at

Method 1: Use the script that comes with oracle to start and close... 1 1. oracle user modify the/etc/oratab file:... 1 2. oracle users modify the $ ORACLE_HOME/bin/dbstart file:... 1 3. Test and run dbshut and dbstart 1. 3.1. Execute the

The oracle listening mechanism is the portal for external applications to connect to oracle. Use the lsnrctl program provided by oracle for management. Generally, when managing oracle, many people tend to ignore the security management of listener:

1. inner connection (natural connection) 2. External Connection (1) left Outer Join (the table on the left is not restricted) (2) Right Outer Join (the table on the right is not restricted) (3) Full outer join (no restrictions are imposed on both

Everyone and so on have set the permission. The system rejects the permission, but you still can read it without knowing why. everyone has all the permissions. I used CACLS to change the permission, but there are still problems with restarting, add

After Incomplete recovery, the database may not meet the recovery requirements. At this time, the database has been opened in the resetlogs mode. If the database is not fully backed up before Incomplete recovery, at this time, I want to restore some

7.1 What is redo logThe most critical part of the recovery operation is redo logs, which include two or more pre-allocated files to store all the changes in the database. Each database process is associated with the redo log to prevent instance

6.1 Introduction to control filesThe control file is a very small binary file.Define the physical status of the current databaseEnsure database integrityRequiredUsed when the database is started to the mount status to help the database startThe

Method 1 for querying table field attributes in Oracle: search for all indexes in the table (including index names, types, and columns): select t. *, I. index_type from user_ind_columns t, user_indexes I where t. index_name = I. index_name and t.

Last_ddl_time the correct meaning of the test has always thought that the last_ddl_time is the ddl end time, but the actual results are not like this, the test results are very confusing. I was impressed with some of the items. -- Test results of

After the tablespace file is accidentally deleted by Oracle, the database cannot be started. [Problem description] After the tablespace file is accidentally deleted by Oracle, the database cannot be started. The error table space file does not exist.

The oracle case when index, null index, and bitmap index table T1 contains million data records. ID = 2 contains only 10 records, and the case when index can be used when ID = 2 is queried. You can create an index as follows: Create index I _1 ON T1

[Oracle]-[architecture]-[DBWR]-DBWR Process-related understanding of DBWR some understanding of DBWR first from the name, DBWR is the full name of Database Writer Process, DBWn is a type of Oracle background process, which is also called DBWn in

Oracle EM 11g/12c database migration operation 1. overview The Oracle EM11g database needs to be migrated. The main steps are as follows: 1. Disable OMS 2. Back up the current database in the full database, restore to the new server. 3. update the

When oracle deletes a table with a large amount of duplicate data and the table has a primary key referenced, clear the duplicate data. 1. Save the data to be retained and put it into the temporary table USERCOMPANYINFO_tmp. Java code create table

Count the data of yesterday and today, and first find out the Unit by unit grouping, and then perform external association with the subquery in the Java code select * from -- Query all the institutions in the organization table (select distinct dc.

During the project's analysis on the dramatic expansion of the Oracle system tablespace, we found that the database could not be logged on. An exception is reported when any user logs on: the system tablespace is insufficient due to the above error.

Database ACID and CAP theory 1. ACID is the theoretical cornerstone of RDBMS. Atomiclty is the transaction atomicity. C is consistent and inserts A table data, will affect other (index/other tables) consistency. I isolation (ioslation) transactions

Oracle execution plan -- all_rows and first_rows (n) optimizer Mode 0. environment Creation [sql] SQL> create usertest identified by test 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users; User