orcle笔记个人笔记

scott下的建表语句在：/opt/oracle/product/11.2.0/dbhome_1/rdbms/admin/utlsampl.sql文件中${oracle_home}/rdbms/admin/utlsampl.sql


  开启监听
 lsnrctl start
 
重新开启
 lsnrctl reload
查看状态
 lsnrctl status

 查看数据库实例名称
 select instance_name from v$instance;

  show parameter name;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      strmtarg
db_unique_name                         string      strmtarget
global_names                               boolean     TRUE
instance_name                          string      strmtarget
lock_name_space                        string
log_file_name_convert                string
processor_group_name             string
service_names                      string      target


--打开页面输出的显示
set serveroutput on;