Oracle

--View SID Sql> show parameter instance_name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ Instance_name String tos --Create Pfile sql> create pfile= '/tmp/tospfile ' from SPFile; File

1, v$session table structure sql> desc v$session; is the name empty? Type ----------------------------------------- -------- ---------------------------- Saddr RAW (8) SID number serial# number Audsid number Paddr RAW (8) user# number

1. Table structure sql> desc v$transaction; is the name empty? Type ----------------------------------------- -------- ---------------------------- ADDR RAW (8) XIDUSN number Xidslot number XIDSQN number Ubafil number UBABLK number UBASQN

After modifying the Awr collection frequency (http://zxf261.blog.51cto.com/701797/762046), it was found that sysaux table space was still heavily occupied. Here's how to clean up the Sysaux table space I. Clean-up of historical statistics under

Today, adding a field to a compressed table can increase success, but at the time of deletion, it was reported ORA-39726 Unsupported add/drop column operation on compressed tables error. The error is that you cannot add or remove fields to a

I. ASM disk and Disk Group management 1. Create a disk group Create DiskGroup DG2 EXTERNAL redundancy DISK ' orcl:a1′; NOTE:1) disk name requires uppercase 2) disk name using V$asm_disk.path 2. Adding disks to the disk group Alter DiskGroup DG2

O7_dictionary_accessibility is also an important initialization parameter related to security. This parameter is used to control whether the data dictionary access behavior is consistent with Oracle 7. By default, this parameter is set to False,

In 11GR2, Oracle analysis functions are further enhanced. This article introduces the new analysis function Nth_value. Previous versions of the analytic functions, which provided first_value and last_value functionality, and in 11GR2, Oracle added

For prior operations in a tree query, it is generally used in a connect by statement, and this prior operation is also available in the field list of select. Look at a simple example: Sql> CREATE TABLE T (ID number, parent_id number, name VARCHAR2

1, write the script to generate the backup script #cold Backcup Remark set sql*plus variable to manipulate output//note Set feedback off heading out verify off Trimspool off echo off Set pagesize 0 linesize 200 Remark set Sql*plus user variable

Case 5: Restore the data file to a new location 1. Simulated environment Sql> CREATE TABLE LXTB01 (id int) tablespace lx01; sql> INSERT INTO LXTB01 values (1); 1 row created. sql> INSERT INTO LXTB01 values (2); 1 row created. Sql> select *

Overview: Oracle database is currently the industry's most commonly used large database systems, I encountered in the actual project ORA-00257 error (lack of space error), by looking for information, most of this is due to the archive log too much,

The steps to minimize Oracle downtime are discussed here. All forms of downtime-planned or unplanned-always occur, and a DBA should have the right backup strategy so that it can recover more quickly if there is a problem with the database. The

Methods that Oracle stored procedures return arrays: 1. Create a Package create or replace package test isTYPE filename_array IS TABLE OF varchar2(1);filename filename_array;end test; 2. Establish a stored procedure create or replace procedure

1. Foreword In the actual application process of Oracle database, the business processing logic is placed in the stored procedure, and the client calls through ADO. Some business logic processing is large and complex, so that after the client calls

　　 Create procedure procedue_name　　[@parameter data_type][output]　　[with]{recompile|encryption}　　as　　sql_statement Explanation Output: Indicates that this parameter is available for return. with {recompile|encryption} Recompile: means recompiling

The redo log file is a very important log file in the Oracle database and is a feature of its own. The redo log file records any operations to the database, such as using DML statements or DDL statements to make changes to the data, or database

In Oracle databases, we may experience a lot of data corruption and how it is important to recover data in the face of these situations. In many cases, recovery is extremely complex and requires careful, reckless operations and attempts that can

The primary role of the Sys_connect_by_path function is to distinguish all child nodes under a parent node from a single character, and then connect to a column to display select level ,sys_connect_by_path( id , '/' ) from test start with pid= 1

Query initialization parameters A lot of ways, such as show PARAMETER, or query V$parameter, here a brief summary. This article describes how to determine the origin of an initialization parameter. To determine if the database startup is enabled