Oracle

1. IntroductionProcedures are used to perform specific operations, when the process is established, you can specify either an input parameter (in) or an output parameter (out), you can pass the data to the execution section by using the input

Logminerbased on package: [[email protected] ~]$ ls/u01/oracle/10g/rdbms/admin/dbmslm.sql-->DBMS_LOGMNR Tool/u01/oracle/10g/rdbms/admin/dbmslm.sql[Email protected] ~]$ Ls/u01/oracle/10g/rdbms/admin/dbmslmd.sql-->dbms_logmnr_d

Preparation: Upload the Oracle installation software to the Linux system/mnt directory via the FTP tool and unzip the software via the unzip command.-----------------------------------------------------------------------------------------------------

　　 when you use Plsql to connect to a database after startup starts the database ,ora-12170 error occurred:Make sure to check the status of the Oracle listener using the LSNRCTL status command before starting, shutting down, or restarting the Oracle

Select A.tablespace_name "Tbsname", 100-round ((NVL (b.bytes_free,0)/a.bytes_alloc) *100,2) "ratio",Round (a.bytes_alloc/1024/1024,2) "Size (m)", Round (NVL (b.bytes_free,0)/1024/1024,2) "Free (m)",Round ((A.BYTES_ALLOC-NVL (b.bytes_free,0))/1024/102

User-owned System permissions select  privilege  from dba_sys_privs  where grantee= ' & USERNAME ' Union select  privilege  from  dba_sys_privs  where   grantee  in   (Select  granted_role  from  dba_ Role_privs  where  grantee= ' &username ');

The index of the database if there are more frequent Delete operations, it can cause the index to produce a lot of fragmentation, so, at some point, all indexes need to be re-REBUILD to merge index blocks, reduce fragmentation, and improve query

Select B.machine, B.program, COUNT (*) from v$process A, v$session b where a.addr = B.paddr and b.username are NOT NULL GRO Up by B.machine, B.program ORDER by COUNT (*) descOrView Session:SELECT * FROM v$session where username are not nullSelect

Linux host 16g memory, modifying Oracle database memory parameters:1, edit/etc/fstab file: For TMPFS line defaults change to defaults,size=12g (pay attention to the format, can not appear error) After modifying the contributing memory parameters,

--v$lock in ID1 when lock mode is TX, the first 2 segments of the physical ID are savedSELECT *From (SELECT S.sid,TRUNC (Id1/power (2,)) RBS,Bitand (ID1, To_number (' ffff ', ' xxxx ')) + 0 slots,Id2 seq,Lmode,RequestS.usernameFrom V$lock L,

Round () functionReturns a numeric value that is the result of rounding operations by the specified number of decimal places syntax round (number, decimal_places) numbers: The numeric value to be rounded up decimal_places: rounding, fractional

1, tree-shaped table, query all the bottom of the recordScenario: Based on the ID of the current record, to query all its child records, each child record then query all child records of the current child record, if any, continue to iterateCurrent

This article mainly introduces the use of RowNum and Row_number () in Oracle, as well as the differences and links, very detailed, the need for small partners can refer to.Row_number () over (partition by col1 ORDER by col2) indicates that,

I. OverviewWhen we use SYSDBA to create a new user, the user does not have any permissions, and even the login database permissions are not, the code is as follows:Here you use SYSDBA to create a new user named ' Zc ' and enter the code to log

1. Use dual with Connect by levelCreate Table as Select as ID from by Level100000;However, there is a limit of connect by level, if exceeding the limit, the system will report, "Connect by Level" Memory is not enough, I tried 10 billion data can,

Dbms_random is a random function package provided by Oracle, and the following are some of its common features:1, Dbms_random.valueFunction: Generate a random 38-bit decimal number greater than or equal to 0, greater than or equal to 1, the code is

Oracle database is a distributed database product based on C/S mode, which supports multi-user, distributed data, and event volume processing. The Oracle database structure is divided into logical storage structures and physical storage structures. (

To view information about the Oracle Undo segment segment:SELECT T1. USN, t2.name, T1. STATUS, T1. LATCH, T1. Extents, T1. Wraps, T1. EXTENDS from v$rollstat T1, v$rollname T2 WHERE=To check

--5 constraints, PRIMARY KEY constraints, FOREIGN KEY constraints, UNIQUE constraints, check constraints, non-null constraints.--Add PRIMARY KEY constraint Alter table table_name add constraints Constraint_name Primary key (column_name);--Syntax

--Insert Add StatementInsert intotable_name (column_name,column_name,...)Values(Data1,data2,...); --adding data through a table Insert intotable_name (column_name,column_name,...)SelectColumn_name,column_name,... fromtable_name; --To create a