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
The premaredstatement.exe cutebatch method calls a void executeforrows method at the underlying layer for execution. They are very lazy. to reuse this method, they lose the returned value, therefore, you cannot know what the current statement
34th lecture 1. the no_data_found proposed last time will expire in update, because the manual only applies to select into when you must use update table set, select * w can be added to achieve the effect of using select *. 2. function, its
When using Oracle, we often encounter some problems that cause us to have to uninstall or reinstall the Oracle database. However, uninstalling the Oracle database is a headache. If it is not correctly uninstalled, it may cause you to have to
I,Basic SELECT statement
Select * from table name;
Slect field name from table name;
Select identifies which columns to select.From identifies from which table to select.
II,Note:
The SQL language is case insensitive.SQL statements can
Stored Procedure Lecture: the following content was heard when I waited at the bus station in Ningbo yesterday. At that time, she fell in love with a girl (with a red coat and bright eyes) and finally sat down in Ninghai's car.
1.
Create
Backup:
Alter Database Backup controlfile to 'xxxxxxx' reuse;Alter database bakcup controlfile to trace as 'xxxxxxx ';RMAN backup control file
Restore an instance: 1. Use binary backup for recovery after the control file is damaged
Today, due to the working relationship, we need to design a backup solution for ORACLE. Because the database is large and it is not suitable for daily backups, we have designed a coverage backup of 7 files per week, the procedure is as follows:
1.
Search for user locksView Code
Select s. username,Decode (l. type, 'TT', 'table lock ','Tx ', 'row lock ',NULL) LOCK_LEVEL,O. owner, o. object_name, o. object_type, s. terminal, s. machine, s. program, s. osuserFrom v $ session s, v $ lock l, dba_
Because these functions are rarely used, they are almost forgotten. However, they are useful for greatly simplifying some SQL syntax. As for efficiency problems,As CCW said, they have no difference with EXISTS, IN, and so on, and need to analyze the
In my practical work, I have the honor to be exposed to the massive data processing problems. It is an arduous and complex task to process them. The reasons are as follows: 1. If the data volume is too large, there may be any situation in the data.
Query/Check Privileges in Oracle Database
§-- Determine the role privileges
Select*FromRole_tab_privs; -- The object privileges granted to roles in data dictionary views.
Select*FromRole_role_privs; -- Containing the role granted to another role.
ORacleMethods for generating random numbers
Selectdbms_random.random from dual;
Select abs (mod (dbms_random.random, 100) from dual; -- generate a random number between 0 and 100.
Selecttrunc (100 + 900 * dbms_random.value) from dual; -- 100
Recently, I have seen two query syntaxes that are not commonly used on the Internet for sorting queries. For the usage of analysis functions, remember, authenticate, and explain;
How can I query the maximum and secondary values of each column in a
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
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
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:
FourthPurpose:Master the two different methods for moving data files and understand the application scenarios of these two methods. Master how to create a tablespace and understand how to use the OMF mechanism to facilitate DBA.Measure the test
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service