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

(1)Alter system set log_archive_dest_n= ' location=d:\ an existing directory '; ----expectedHowever, if "D:\ an existing directory" is not a valid directory, then "d:\ an existing directory" will be archived to the D packing directory, "an existing

Oracle Regexp_like Introduction and examplesStudied: http://www.cnblogs.com/einyboy/archive/2012/08/01/2617606.htmlThere are four main functions in Oracle that support regular expressions: 1,regexp_like: Similar to the function of like

Before thought is the system reason, has made the reload system t^t because listens many schoolmates to say that Oracle some difficult to install, did not find the main reason to start reloading, this is really a waste of time.Baidu reason, if in

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.-----------------------------------------------------------------------------------------------------

Create table spaces and usersCreate temporary tablespace nhgl_tempTempfile ' E:\oracledata\nhgl\nhgl_temp.dbf 'Size 50mAutoextend onNext 50mExtent management Local;Create Tablespace Nhgl_dataLoggingDataFile ' E:\oracledata\nhgl\nhgl_data.dbf 'Size 10

Install SERVER2008, such as when installing a production environment in a virtual machine, you need to add multiple hard disks to install Oracle and data backup, and create a new partition when you install the system, (you cannot mount the hard disk

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 ');

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

--1, viewing time-consuming SQLSELECT *From (select v.sql_id,V.child_number,V.sql_text,V.elapsed_time,V.cpu_time,V.disk_reads,Rank () Over (order by v.elapsed_time Desc) Elapsed_rankFrom V$sql v) awhere Elapsed_rank --2. View the top 10 SQL

--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 transferred from: http://www.cnblogs.com/QDuck/archive/2010/08/11/1797225.html1. View All Users: SELECT * from Dba_users;   SELECT * from All_users; SELECT * from User_users;2. View user or role system permissions (System permissions

The Oracle startup process involves several modes, which involve different files, each state of the database doing different things, and these patterns are suitable for different maintenance needs, the main mode has three kinds: nomount, MOUNT, OPEN.

Tag: Oracle Common Command Oracle650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/8F/26/wKiom1jUy2iQxTFcAAEwFW7sslc476.png "style=" float : none; "title=" 1.png "alt=" Wkiom1juy2iqxtfcaaewfw7sslc476.png "/>650) this.width=650; "src="

Today do bootstrap treeview, require input Node ID ID, parent node ID PID, textBut the SQL aliases executed are all uppercase, so the question of how to find the next ORCL alias is lowercaseThe code is as follows:Select t.fun_id "pid", T1. fun_id id,

--1 Import data to the database times the ora-01653:unable to extend table error, online Check the following reason is due to lack of table space;Querying table space Usage statementsSelect a.tablespace_name,a.bytes/1024/1024 Total, (a.bytes-b.bytes)