Oracle

The recent Zabbix Alert RAC Library table space usage exceeds 75% needs to be expanded, this document records the change operation.1. Table Space ViewSet pages 999set linesize 999SELECT a.tablespace_name "tablespace name", 100-round ((NVL

Why do you need flashback log and archive log when flashback?If the activity of the database is not very frequent, you can see that its flashback log is relatively small. So what is the way to flashback to the past?The schematic is as follows:12:50

1. Open Status renamingSYS@userdata>Select Tablespace_name,file#,File_name,v.status,v.enabledFrom Dba_data_files D,v$datafile Vwhere D.file_id=v.File#; Tablespace_namefile#file_nameSTATUS ENABLED-------------------- ---------- -----------------------

Sql> --Create Test TableSql> Drop Tablelist_partition_test;TableDroppedsql> Create Tablelist_partition_test2 ( 3Empno Number(4), 4EnameVARCHAR2(Ten), 5JobVARCHAR2(9), 6Mgr Number(4), 7hiredate DATE,8Sal Number(7,2), 9Comm Number(7,2),

1. Dual is a table that actually exists in Oracle. is a table with only one field, a row of records, which can be read by any user, often in a SELECT statement block without a target table.2, in practice, we call it "pseudo-table". Because he does

After I test if the silent modeling version, in other database server calls need to copy the absolute path to the database, in order to facilitate implementation, this side using graphical modeling.Modeled version, cmd Command Window input

Oracle stored procedure exception capture learning, execution, and presentation process:Stored procedures: CREATE OR REPLACE PROCEDUREsp_test_2 (param1inch int,--Input ParametersParam2inch int, Out_return outvarchar2 --return Results )

Encountered this problem "in the number of parameters in Oracle Limit", which is recorded here,There is a limit to the number of arguments in the parentheses, and the number of Oracle 9i cannot exceed 1000 256,oracle 10g.When the number of in is

Oracle additions and deletions--the deletion1. Delete database usersSql> Conn/as SYSDBAConnected.sql> drop user Feiyu cascade;The user has deletedIf the user cannot delete and error:ERROR at line 1:Ora-01940:cannot drop a user that is currently

CREATE OR REPLACE PROCEDURE update_log_proc (plids in Varchar2,pparas in Nclob,msg in NCLOB) asbeginupdate G3_log_info SET Paras=pparas,xml_data=msg WHERE lids=Plids; END; Database execution: Execute Update_log_proc (' 00000 ', ' Clerk ', ' msg ')

Primary and Standby library switching is mainly in two cases, switchover and failover, both of which need to be done manually.One is switchover (planned switchover, no loss of data)The second is failover (the main repository switch role is required

The detailed procedures are listed below:1. Log in to the database via the SQL Plus command.Enter Sqlplus "Login username/password as login type" on the command line to log in, the system built user name commonly used is sys, password is set during

1 Common commands 1 Sqlplus Scott/[email PROTECTED]:1521/ORCL The back not add ; Sqlplus sys/oracle as SYSDBA "Password Authentication" Sqlplus User name arbitrary/password any as SYSDBA

Task Name: Schema Elon Data migration to schema TIAN in the production environment########################################Pre-Preparation:1: Confirm the object status under the Elon userSelect

This seemingly missing 32-bit package, you try to install a 32-bit installation package tryYum install libxt.i686 libxtst.i686 libxp.i686--setopt=protected_multilib=falseYum installation Error error:protected Multilib versions:Yum-y Install binutils

First, describeThe execution plan could not be viewed during the review of the execution plan test, and was found to be dbms_xplan.display because a set autot on was turned on during the test, and after it was closed (set Autot off), the Execute

Oracle View lock table case and Solution table createtime--2018 April 27 17:24:37author:marydon1. Lock Table Query-- Lock Table Query SELECT object_name as table_name, machine, S.SID, s.serial# from WHERE L.object_id= O.object_idand = S.sid;2.

# Listener.ora Network Configuration file:d:\develop\oracle11g\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools. Sid_list_listener=(Sid_list=(Sid_desc=(Sid_name=Clrextproc) (Oracle_home=

1, the server's monitoring configuration: The default port number 1521Start and turn off monitoring: Lsnrctl start|stop [listerer listener name]It is common to start the listener before starting the instance, or you can register statically in the

The Oracle decode function, regardless of whether the result of the query satisfies ' PRIMARY ', is executed by the SELECT statement in the parameter, and you know by looking at the execution planSet Autotrace traceonlyselect decode(database_role