Oracle

1. Oracle installation After the completion of the initial password? Internal/oracle Sys/change_on_install System/manager Scott/tiger Sysman/oem_temp 2. Oracle9iAS WEB Cache's initial Default user and password? Administrator/administrator 3.

The workaround is as follows: 1: Check V$db_object_cache SELECT * from V$db_object_cache WHERE name= ' crm_lastchginfo_day ' and locks!= ' 0 '; Note: Crm_lastchginfo_day is the name of the stored procedure. Found locks=2, 2: Identify the value

One. Why to learn Oracle We learn a thing the first time, must be asked if we have the value to learn this thing? Well, I've collected some information from the Internet! ~ sorted out the form below! ~ You can see the red part, the red indicates

Configuring Hugepage in Linux can improve Oracle performance and reduce the page exchange of Oracle SGA, similar to the Lagepage in Aix. Why use a large page? The default block size for Linux memory is 4K If the SGA is: 128G Select 128*1024*1024/

The following error was reported when executing the script to create the control file: Sql> @/orac/controlfile.sql Sp2-0042:unknown command "datafile"-rest of line ignored. Sp2-0734:unknown command Beginning "'/orac/ora ..."-rest of line ignored.

Normal table online redefinition is an error in the partitioning table, the range of values exceeds the partition limit size, so what steps do you need to redefine the table online? This example records the processing process: Sales@orcl>exec

--Current ordinary user creates issgzt create table Tab_ddl (Login_user VARCHAR2, audsid number, MACH INE VARCHAR2, IPAddress VARCHAR2, Schema_user VARCHAR2 (a), schema_object VARCHAR2, Ddl_time DATE, Ddl_sql VARCHAR2 (4000), MODULE VARCHAR2 (10

Oracle Install GuideMemory Requirements:Minimum:1 GB OFRAMRECOMMENDED:2GB of RAM or More#grep Memtotal/proc/meminfoTo view virtual memory space:Df-h/dev/shm/To install a dependency package:Yum install binutils compat-libcap compat-libstdc++ gcc

Oracle Server Automatic Backup1.$sqlplus/nolog$conn sys/as sysdbasql> Create directory Expdata as '/home/oracle/oraclebak ';D irectory created.  Sql> Grant Read,write on the directory expdata to public; Sql> exit2.$mkdir/home/oracle/oraclebak3.

Oracle Install GuideMemory Requirements:Minimum:1 GB OFRAMRECOMMENDED:2GB of RAM or More#grep Memtotal/proc/meminfoTo view virtual memory space:Df-h/dev/shm/To install a dependency package:Yum install binutils compat-libcap compat-libstdc++ gcc

First step, on the cmd command line, enter sqlplus or Open command window directly in PlsqlStep two, follow the prompts to enter the user name and password1. View processes and Sessions parameters 12345678910111213 SQL> show

Optimization of SQL statements in Oracle Learning discourse① when querying with a SELECT statement, do not use "*" instead of all column names, as this will present an analytic dynamic problem for the Oracle system. The Oracle system translates "*"

1. Querying all Table spacesSelect Dbf.tablespace_name,Dbf.totalspace " Total (M)",Dbf.totalblocks as total block number ,Dfs.freespace " Total remaining (M)",Dfs.freeblocks " number of remaining blocks ",(dfs.freespace/dbf.totalspace) * " idle

12.1.0.2 has been released for some time, with the increase of users, the current version of 12C stability, as well as all aspects of the functionality, get everyone's approval.Many users, need to upgrade the database from a low version to 12C, this

Open Navicat----->oci options Right--Select Oci.dll pathBy default in the Navicat installation directory there is a instantclient folder directly select the inside of the OCI.LL can beMy navicat is 11.1.10 64-bit instantclient is

Today I attended the OCP training to listen to the teacher told a little skill about Oracle, the feeling is very useful to record.This in the official website of the document also has everyone interested in also can go to see, official website

Job timed Run INSERT statement1. Build stored procedure for inserting dataCreate or replace procedure Report_web asV_start_date DATE;V_end_date DATE;BeginV_start_date: = TRUNC (sysdate)-1;V_end_date: = TRUNC (sysdate);Begininsert into [email

Organize some sql&plsql statements as AliasSelect X as Y from ...//use Y to display the X column nameDISTINCT to remove duplicate rowsSelect DISTINCT x from ...//table to filter x rows of data that are not duplicated in range filteringSelect X from

1. Standard SQL specification1, single ifIFV=... Then END IF;2、IF...ELSE IFV=... Then ELSEt ....; END IF; 3, multiple ifIFV=... ThenElsif v=... Thent ...; ENDIFL Note: multiple if is'elsif'No'ELSE IF'2. Decode functionDECODE

Oracle boot? Most of the population says when Oracle starts, and so on.Actually, it's wrong.Really speaking1.Oracle software Startup2. Software to read 3 files and start the DB instanceOracle's Operation1. Software startup2. Software to read 3