Oracle

Oracle Control files is a binary file, the initialization size is specified by the CREATE database, and you can use Rman backup The structure information of the current database is recorded, as well as the information of the data file and log file,

How the procedure is called Declare Realsal Emp.sal%type; Realname varchar (40); Realjob varchar (40); Begin//Stored procedure call start realsal:=1100; Realname:= '; realjob:= ' clerk '; Runbyparmeters (Realsal,realname,realjob); --Must be

For log buffers, the settings are too small to cause log buffer space to wait for events. But it's not that the bigger it is, the better it is, because the LGWR process will constantly start refreshing the log buffer to free up memory, so it may not

Oracle Query Table Space usage --Query table space usage Select UPPER (f.tablespace_name) "Table space name", D.TOT_GROOTTE_MB "Table space size (M)", D.tot_grootte_mb-f.total_bytes "used Space (M)", To_char (ROUND

Physical Standby and logical standby Log application services are divided into two types, one is the physical standby redo applications, similar to media recovery, its advantage is fast, but 10g case standby must be in the Mount State, Unable to

The parameters discussed in this article are: Log_archive_dest Log_archive_dest_n Log_archive_start Db_recovery_file_dest Oracle version: Sql> select * from V$version; BANNER -------------------------------------------------------------------

DBMS_METADATA.GET_DDL () is used to get the DDL for the object, as follows. Note: In Sqlplus, to better demonstrate the DDL, you need to set the following parameters: Set line set pagesize 0 set long 99999 set feedback out set echo off 1

A stored procedure is a program block stored in a data dictionary that can be shared among different users and applications, and enables optimization and reuse of programs. First, the creation and execution of stored procedures 1. Create stored

Definition of a view View, also called a virtual table, does not occupy physical space, which is also a relative concept, because the definition statement of the view itself is still stored in the data dictionary. The view has only a logical

A system that, after a long period of operation, maintenance, and versioning, may produce a large number of indexes, even though the index occupies far more space than the data. Many indexes are useful for systems in the initial design. However,

First, modify the password: Alter user test_user identified by password; Second, modify the user default table space: Alter user Test_user default tablespace users; Third, modify user temporary table space: Alter user Test_user Temporary

Test Table name: D 1, to determine whether a table has been analyzed: Select T.num_rows,t.avg_row_len from User_tables t where T.table_name = ' D ', If the result is empty, it means that the table has not been parsed; 2, the table has not been

There are 3 kinds of analytic functions commonly used by Oracle for sorting, rank (), Dense_rank (), row_number (); The test table is as follows: 1, rank () Jump ranking With temp as ( Select T_id,t_age, rank (t_age desc) sec from AAA )

Concept: Briefly, profile is a means of further restricting the resources that database users can use in Oracle databases, such as controlling the CPU resources that can be used to connect to a user's session or SQL, such as controlling the password

Starting with Oracle9i, index and uniqueness constraints when primary key creation can be defined independently when the table is being built. Subsequently, the constraint can be individually drop, and the index can be preserved. This is one of

ALTER DATABASE open resetlogs This command I think we all very familiar with, then did not think of this resetlogs option why use? When do you use it? What is the principle mechanism of it? What role does he play? We all know that data is going to

1. In Oracle:Select org_idFrom organizationsStart with org_id=: org_idConnect by Prior org_id=supervision_org_idORDER BY supervision_org_id 2. SQL Functiong:Functionno Subfunctionno SubfunctiontypeSystemadmin Privilege 0Systemadmin Subsysadmin 1

In Sql_plusSpool Execcompproc.sqlSelect ' Alter PROCEDURE ' | | object_name| | ' compile; ' From all_objects where status = ' INVALID ' and object_type = ' PROCEDURE ';Spool off@ExecCompProc. Sql; Organize into a stored procedureCreate Or Replace

The merge statements introduced in Oracle 9i R2 are often referred to as "update Inserts" (Upsert), because the merge allows you to update and insert (insert) rows of data in the same step, for extraction, Converting and loading types of

Oracle data can be exported to a text file using the spool buffer pool technology in Oracle. 1, enter the buffer start command in Oracle Pl/sql, and specify the file name of the output: Spool D:\output.txt 2, enter your SQL query at the command