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

Explore the structure of data file header under LMT table space management and the recording mode of bitmap Central The experiment is divided into two steps: 1.LMT locally managed table space, the structure analysis of data files in ASSM automatic

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/

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

Steps: (1) Create script file bak_112.sh, as follows (automatically back up the database by current date): #!/bin/sh export oracle_base=/u01/app/oracle; oracle_home=/u01/app/oracle/product/11.2.0/db_home1; Export Oracle_home oracle_sid=xxx export

--View SID Sql> show parameter instance_name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ Instance_name String tos --Create Pfile sql> create pfile= '/tmp/tospfile ' from SPFile; File

sql> desc V$lock; is the name empty? Type ----------------------------------------- -------- ---------------------------- ADDR RAW (8) Kaddr RAW (8) SID number TYPE VARCHAR2 (2) ID1 number ID2 number Lmode number REQUEST number CTIME

1, the structure of the V$sqlarea table Sql> desc V$sqlarea is the name empty? Type ----------------------------------------- -------- ------------------------ Sql_text VARCHAR2 (1000) Sql_fulltext CLOB sql_id VARCHAR2 (13) Sharable_mem

1, v$session table structure sql> desc v$session; is the name empty? Type ----------------------------------------- -------- ---------------------------- Saddr RAW (8) SID number serial# number Audsid number Paddr RAW (8) user# number

Today, adding a field to a compressed table can increase success, but at the time of deletion, it was reported ORA-39726 Unsupported add/drop column operation on compressed tables error. The error is that you cannot add or remove fields to a

1.dba_logstdby_events This view can be viewed as a logical standby action log, so if an error occurs, you can see what the recent logic standby has done with the view. By default, this view retains only the records of the last 100 events (you can

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