Oracle

Oracle Database files are classified into five categories: Parameter files, data files, temporary files, control files, and redo log files. Oralce Memory Structure System global zone (SGA) Process global zone (PGA) User

Data Files and redo log files are important files in the database. Oracle stores data in four file systems Operating System (OS) File System Original Partition New Features of Automatic Storage Management (ASM) and 10g Release 1

Cancel spfile parameter settings Alter system reset parameter SID = 'sid | *' Or alter system set parameter = value to the original value Create pfile using spfile Spfile is a binary file, pfile is a text file, you

Http://www.oracle.com/technetwork/cn/database/windows/downloads/index-101312-zhs.html   To connect ORACLE to VS, use ENTITY.   1. If you only need to use ENTITY, you can use ODAC of the next 11G version or later. Do not enter 10. The English is

1. Stored Procedure writing Create or replace procedure HVM_BYQ_TJ -- Transformer statistics ---> warehouse receiving(Id in number)AsBeginFor num in 1 .. 2 loopIf num = 1 thenUpdate hvm_zsb_tj set byq = (select count (0) as hangshu from

Sga (oracle has a large memory block) Function Maintains various internal data structures that all processes need to access; Cache the data on the disk, and cache the data here before redoing the data to the disk; Save parsed SQL plans.

1. Trace file) Provides detailed debugging information. When a server fails, a trace file containing a large amount of diagnostic information is generated. Enable tracking SQL _TRACE = TRUE Measure oracle V $ view, such as v $ waitstat and

-- Create tablespace test_tablespace logging datafile 'e: \ ORACLETABLESPACE \ test_tablespace.dbf' SIZE 32 m autoextend on next 32 m maxsize 2048 m extent management local; -- Create temporary tablespace test_temptablespace tempfile e: \

1. Create a tablespace Create a tablespace: MDMS_TS_File, and the data file is MDMS_TS_File.DBF. Specify the storage path as '/oradata1/and the size is 2000 M. Create tablespace MDMS_TS_File DATAFILE '/oradata1/MDMS_TS_File.DBF 'size 2000 m

Differences between adding a comment and canceling a comment: F5 shows the effect, and the execution time is compared to the forced execution index example. Select count (1) FROM (select * from vav_stbms_tb_act_source_2012 where cstart_time> = to_

(Original post address http://blog.csdn.net/linghe301/article/details/8501195) Someone asked me a question a few days ago: Suppose I have two layers, one line layer, one surface layer, saved as MXD, and then published the service, I want different

  1. Disable all oracle services. You can disable it in the windows Service Manager; 2. Open the Registry: regedit open path:HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \Delete all service names starting with oracle in this path. This

The lifecycle of a database system can be divided into three stages: design, development, and product. The lowest cost and maximum benefit of database performance optimization during the design phase. In the final stage, database performance

Q] how to view the database Character Set[A] select * fromNls_database_parameters, derived from props $, indicates the character set of the database.Select * fromNls_instance_parameters, which is from v $ parameter,Indicates the character set

Conditional loops can be implemented in two ways. 1. for variable in start value... end value loop end loop; 2. while condition loop end loop; Loop usage: I. X: = 100; LOOP X: = X + 10; If x> 1000 THEN EXIT; End if end loop; Y: = X; Ii. X:

Displaying Data from Multiple Tables Types of Joins SQL: 1999 Compliant Joins: -- Cross joins -- Natural joins -- Using clause -- Full or two sided outer joins -- Arbitrary join conditions for outer joins Syntax: Select tableA. column, tableB.

Basic Select Statement SELECT * | {[DISTINCT] column | expression [alias],...} FROM table; Using Arithmetic Operators SELECT 12 * (column + 10) + 200 FROM table; Using the Concatenation Operator SELECT columnA | columnB FROM table; Using Literal

1. Open Oracle SQL Developer 2.1 and the following error occurs: "Unable to create an instance of the Java Virtual Machine" Solution: Modify ide \ bin \ ide. conf in the tool path.AddVMOption-Xmx 256 M Reference: http://www.faisalmb.com/blog/post/200

If you think a PL/SQL running for a long time has a problem, you need to stop it immediately. What can be done: There are two methods: 1. Execute alter system kill session' Sid, serial #' The sid, serial #, can be found in V $ Session. Sometimes

Syntax: Table Index CREATE [UNIQUE|BITMAP] INDEX [schema.]index_nameON [schema.]table_name [tbl_alias](col [ASC | DESC]) index_clause index_attribs Index_clses:There are two situations:1. Local Index The storage location of the index information