Oracle

Oracle Bug 6136074-ORA-04068/ORA-04065/ORA-06508 addressed on 10.2.0.3, where a bug may cause compilation or view failure, and the Failure result is not just that the current view or process is not available, instead, the entire data dictionary may

After modifying parameters, the database cannot be started. problem: when you set the parameter SQL> alter system set dispatchers = 0 scope = spfile; the parameter dispatchers cannot be set to 0, leading to error 2. symptom: at this time the

Oracle datapump expdp/impdp: When importing and exporting data to the database, the hang has been used to solve the problem of being hang when recently exporting schema-level data and has to stop the current export job. If you have similar problems,

The sys user of oracle9i recently installed an oracle9i on linux. When using sqlplus to log on, there was a confusion. Now, it is recorded, so it is better to remember it... It has always been believed that an as dba should be added after logon

RHEL6 uses udev to modify the asm disk name. The current system uses emc power Multi-path software, and the disk name changes after the restart. to standardize the use of the asm disk, you need to use udev to fix the disk name. The specific steps

Oracle SQL statement Operation Number: integer, rounding, and formatting. Use oracle SQL to operate the number: rounded up, rounded down, N decimal places retained, rounded down, and number formatted (rounded down): select floor (5.534) from dual;

Recovery steps for oracle log files and control files corruption: 1. add _ allow_resetlogs_upload uption = true, _ uploupted_rollback_segments = true, _ offline_rollback_segments = true, start to nomount2. use the backup of the control file to

Creating a view with parameters in Oracle is in Oracle. Unlike stored procedures and functions, a view can define input parameters. However, you can change the mode by using a package to define the package first: /* as defined by personal needs, I

The structure and execution sequence of select statements. The following sequence numbers represent the execution sequence 8 select (9) DISTINCT 11 1 ROM 3 JOIN 2 ON 4 WHERE 5 group by 6 {CUBE | ROLLUP} 7 HAVING 10 order by additional

Undofile fault recovery test table: SQL> select count (*) from t1; COUNT (*) ------------------ 100958 event simulation: SQL> insert into t1 select * from dba_objects; 50479 rows created. simulate Data File Corruption rollback: SQL>! Oracle @

Summary of Oracle Database optimization 1. Optimizing applications and business logic is the most important thing. 2. flexible application of the database design phase paradigm and the anti-paradigm. Generally, the internal design should be physical

AIX + bare device, ORACLE tablespace expansion hardware environment: minicomputer IBM P670, storage: ibm shark F-20 software environment: Operating System AIX5.1 database oracle9i theme: physical volume PV->; volume group VG->; logical Volume LV

Alter database open resetlogs Statement today, when I was reading the 11g admin, I found this passage: "If you previusly created a control file specifying RESETLOGS and either did not specify filenames or specified nonexistent filenames, then the

Summary of oracle beginner knowledge points 1. dba, sysdba, and sysoper are different roles. roles can include system permissions, object permissions, and roles. dba does not include sysdba and sysoper permissions. sysdba and sysoper are two types

Six methods for generating sequences in Oracle [SQL] Method 1: sys @ ORCL> select level from dual connect by level select rownum from dba_objects where rownum select to_number (column_value) n from xmltable ('1 to 5'); N ---------- 1 2 3 4 5

Select... in oracle... connect by prior... start with and (+) usage 1. select... connect by prior... usage of start with: select... from where -- filter condition, used to filter all returned records start with -- query results from the start of

Oracle read consistency principle 1: The concept of undo segment when the database is modified, you need to save the old data to a place and then modify it, the segment used to save the old data is the undo segment. Previously, old things can be

Oracle Partition Table type usage Partition Table use our oracle table data is finally saved to the disk file. by default, the data in the following table is put together, but if there are more data in the table, the operation on the table will

Oracle functions: intercept and merge Java code select to_char (t. create_time, 'yyyy-mm-dd') as date _, remark, substr (t. remark, 1, 4) as yyyy, substr (t. remark, 5, 2) as dd, (case when substr (t. remark, 7, 2) = '00' then' 01 'else substr (t.

Validate database and datafiles DB_BLOCK_CHECKSUM is a database initialization parameter that controls the writing of checksums for the blocks in datafiles and online redo log files in the database (not backups ). if DB_BLOCK_CHECKSUM is typical,