Oracle Learning-Management One (3 No. 06 lecture Chapter 03)

Tag:oracle    view process    

No. 06 Lecture  chapter 03--managing an oracle instance--learning process: $ id$ sqlplus / Nologsql> conn / as sysdbasql> startupsql> !$ ps -ef|grep  oracle   last view process-Knowledge point:initialization parameter  (Pfile and SPFile) sql> desc v$ parameter; name                                        Null?    Type -----------------------------------------  -------- ---------------------------- NUM                                                   number name                                                 VARCHAR2 ( TYPE )                                                 NUMBER VALUE                                                 VARCHAR2 (4000)  DISPLAY_VALUE                                        VARCHAR2 (4000)  ISDEFAULT                                             VARCHAR2 (9)  ISSES_MODIFIABLE                                     VARCHAR2 (5)  ISSYS_MODIFIABLE                                     VARCHAR2 (9)  ISINSTANCE_MODIFIABLE                                VARCHAR2 (5)  ISMODIFIED                                           varchar2 (Ten)   isadjusted                                           VARCHAR2 (5)  ISDEPRECATED                                         VARCHAR2 (5)   isbasic                                              VARCHAR2 (5)  DESCRIPTION                                          VARCHAR2 (255)  UPDATE_COMMENT                                        VARCHAR2 (255)  HASH                                                 number--set the width of the name,value sql> col  Name format a20sql> col value format a30sql> select name,value  from v$parameter;--View the value--method of the parameter Pga_aggregate_target one:sql> select name,value  From v$parameter   2  where name= ' Pga_aggregate_target ';NAME                   VALUE-------------------- ------------------------------pga_aggregate_target 0sql> clear  scr--Method Two:sql> show parameter sga;name                                   TYPE         VALUE------------------------------------ ----------- ------------------------------lock_sga                              boolean      FALSEpre_page_sga                          boolean      FALSEsga_max_size                          big integer 536msga_ target                            big integer 0sql> --pfile - File name   initSID.ora--Modifications made manually--vi edit--Changes take  Effect on the next start up--only opened during instance start up--default  location is  $ORACLE _home/dbs--> inside the Unix-like operating system [[email protected] dbs]$ pwd/u01/app/ oracle/product/11.2.0/db_1/dbs[[email protected] dbs]$ lshc_dbua0.dat     initorcl.ora  orapworcl       peshm_orcl_one_0   spfileorclone.orahc_ora11g.dat   lkora11g      orapworclone     pwdorcl.orahc_orcl.dat     lkORCL         peshm_DBUA0_0   snapcf_orcl.fhc_orclone.dat  lkORCL_ONE     peshm_ora11g_0  spfile.orainit.ora         orapwora11g   peshm_orcl_0    spfileora11g.ora[[email protected]  Dbs]$ env | grep oracleoracle_unqname=orcloracle_sid=orcloracle_base=/u01/app/oracleoracle_home=/u01/app/oracle/product/ 11.2.0/db_1--oracle_base=/u01--oracle_home=/u01/oracle--oracle_sid=orcl  ---> Full name:sid:site  Identifier--path= $ORACLE _home/bin: $PATH   --> This step can not be forgotten, or  sqlplus do not recognize-recommend a book   expert  oracle database architecture

This article is from the "You Devil" blog, please be sure to keep this source http://599184429.blog.51cto.com/5147223/1530506

Oracle Learning-Management One (3 No. 06 lecture Chapter 03)