RSS Feedset head off set headsep off set newp none set linesize 100 set pagesize 10000 set sqlblanklines OFF set trimspool ON set termout off set feedback off –oracle background process select name,description from v$bgprocess –see the default tablespace,roles,system priveate select * from user_users select * from user_role_privs select * from user_sys_privs –check the table size [...]
Archive for the ‘oracle’ Category
Posted in 
ORACLE如何查看INSERT\UPDATE\DELETE次数
十一月 15th, 2011 
lookdata ALL_TAB_MODIFICATIONS ALL_TAB_MODIFICATIONS describes tables accessible to the current user that have been modified since the last time statistics were gathered on the tables. Related Views DBA_TAB_MODIFICATIONS provides such information for all tables in the database. USER_TAB_MODIFICATIONS provides such information for tables owned by the current user. This view does not display the TABLE_OWNER column. Note: [...]
Tags: 手动建立数据库
十一月 15th, 2011 lookdata （b14231 第75-80页） 1、设置oracle数据库的sid ora_test@oracle[/home/oracle]> export ORACLE_SID=cnhtm 2、确定数据库的认证方式 如果需要在其他客户端以sysdba方式连接这个实例，按如下方法创建口令文件 ora_test@oracle[/home/oracle]> orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=5 force=y 3、编辑参数文件 创建参数文件，文件名为 $ORACLE_HOME/dbs/init$ORACLE_SID.ora，其内容如下 ora_test@oracle[/home/oracle]> cat $ORACLE_HOME/dbs/init$ORACLE_SID.ora control_files = (+DATA/cnhtm/controlfile/control01.dbf, +DATA/cnhtm/controlfile/control02.dbf, +DATA/cnhtm/controlfile/control03.dbf) db_name = cnhtm log_archive_dest_1 = “LOCATION=+DATA/cnhtm/arch” log_archive_dest_state_1 = enable db_block_size = 8192 pga_aggregate_target = 100M processes = 1000 sessions = 1200 open_cursors = 1024 undo_management = AUTO shared_servers = [...]