Oracle

The first step:From the Windows desktop, execute the start → database configuration Assistant command, open the Welcome screen of the database Configuration Assistant dialog box, click the Next button in the interface, WIN10 below are: "start" →

SECURECRT connect to the Linux machine where the database resides, switch to Oracle user mode[Email protected] ~]# su-oracleSteps to read 2Then log in to the database with Sqlplus and close the database[[email protected] bin]$

Set serveroutput on;Spool C:\sequence_code.txt;DeclareV_sequence varchar2 (4000);V_nextval number (38,0);BeginFor I in (select Sequence_name from user_sequences) loopSelect Dbms_metadata.get_ddl (' SEQUENCE ', i.sequence_name,user) into the

1. How do you solve a lock when designing a database?      Lock: The same time period, many users occupy a resource.　　Rob a train ticket, submit an order but not paid, in order to avoid the deadlock, it can be designed to pre-1, wait a period of

1 first need to enter Oracle with system users 2 then create a table spaceCreating a tablespace requires creating two temporary table spaces a table space-- CREATE TABLE space Create tablespace ABC datafile ' D:\TABLESPCE\LANDHIGH_SFTMS.DBF ' size 50

(1) The Code of the Lock table query has the following form:Select COUNT (*) from V$locked_object;SELECT * from V$locked_object;(2) See which table is lockedSelect B.owner,b.object_name,a.session_id,a.locked_mode from V$locked_object a,dba_objects b

Type of table connection: equivalent connection, self-connect, non-equivalent connection, (left and right) outer connectionOne, equivalent connection: by two tables with the same meaning of the column, you can establish an equal join condition. =====

--Memory allocationWhen you build a library, you can allocate system memory 50%-80% to Oracle and later adjust to your business.SGA, PGA distribution ratio:Oltp:sga%80, PGA%20Olap:sga%50, PGA%50Mixed: SGA%60, PGA%40--SGA Automatic ManagementThe

ReproducedLet's look at data blocks (also called logical block, Oracle block, page), where Oracle stores data in these chunks, and a block of data is the composition of a series of physical bytes in the physical space of the database on disk.A

1.1 Unpacking the installation packageORACLE11GR2 installed as two installation packages, all extracted, you need to combine the contents of two installation packages to install oracle version linux64_11gr2

I found the PL/SQL pop-up variable box when I updated a field in a table yesterday, and it thought that the field value I wanted to change contained undefined variables. For example, I execute a script: Update t_wlf_config set configvalue = '

1.1 Unpacking the installation packageORACLE11GR2 Installs as two installation packages, after all decompression, you need to combine the contents of the two installation packages to install oracle version linux64_11gr2

1. Locate the installation directory for Oracle. such as: C:\oracle\product\10.2.0\db_1\network\ADMIN2. Find the Tnsnames.ora file3.The Chinese part is the part that needs to be modified, in addition to the first "local instance name", other needs

Essentially no difference.Just a function like: Only one variable can be returned with a limit. A stored procedure can return more than one. Functions can be embedded in SQL and can be called in Select, and stored procedures do not work. The essence

--View the database run mode (spfile or Pfile)Select Decode (COUNT (*), 1, ' spfile ', ' pfile ')From V$spparameterwhere Rownum=1 and isspecified= ' TRUE ';--Start the database with PfileCreate pfile=

--View Control file pathShow parameter control_files;--Control file backup, three ways1) Copy using OS command;1) Open state, use the ALTER DATABASE command to generate a copy of the control file;2) in open state, use the ALTER DATABASE backup

There are three ways to connect to a database, using Oracle's own Sql*plus and Sqldeveloper, and using third-party tools Pl/sqldeveloper.I. Using Sql*plus to connect to a databaseSql*plus Connection also has three kinds of connection methods, can be

1. Uninstalling the Database software--10g[oracle]# Cd/u01/app/oracle/product/10.2.0/db_1/oui/bin[oracle]#./runinstaller-ignoresysprereqs--11g[oracle]# Cd/u01/app/oracle/product/11.2.0/db_1/oui/bin[oracle]#./runinstallerOr[oracle]# cd/u01/app/oracle/

(summary) Oracle monitoring service LSNRCTL parameters and query statusLsnrctl command Common parameters in detail: LsnrctlStartStart the specified listener StopClose the specified listener StatusDisplays the status of the listener. The

#!/bin/bash#Test in RHEL 5.5 for 10gC= ' Cat/etc/shadow | grep Oracle | Wc-l 'if [$c! = 0]ThenW=0While [$w-eq 0]Doecho "--find user Oracle has been existed!--"echo "--do want to delete user Oracle?" [Yes/no]: "Read ynCase $yn in"Yes")gpasswd-d