玄白的专栏

lener.__db_cache_size=159383552 lener.__java_pool_size=4194304 lener.__large_pool_size=4194304 lener.__oracle_base='/u01'#ORACLE_BASE set from environment lener.__pga_aggregate_target=104857600 l

# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then         . ~/.bashrc fi # User specifice environment and startup programs PATH=$PATH:$HOME/bin export PATH unse

ALTER DATABASE db01 mount//open read only 置数据库为受限状态：数据库未启动时：startup restrict                                                   数据库已启动时：alter system enable restricted session； 强制关闭某些已连接的用户：alter

查看当前用户的缺省表空间 　　SQL>select username,default_tablespace from user_users; 　　查看当前用户的角色 　　SQL>select * from user_role_privs; 　　查看当前用户的系统权限和表级权限 　　SQL>select * from user_sys_privs; 　　SQL>select * from

1.查看所有用户： select * from dba_users; select * from all_users; select * from user_users; 2.查看用户或角色系统权限： select * from dba_sys_privs; select * from user_sys_privs; 3.查看用户对象权限： select * from dba_ta

select t.table_name,i.index_name,i.index_type,s.synonym_name from dba_tables t left outer join         dba_synonyms s on t.table_name = s.table_name         left outer join dba_indexes i on t.TA

# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then         . ~/.bashrc fi # User specifice environment and startup programs PATH=$PATH:$HOME/bin export PATH unse

Syntax STARTUP options | upgrade_options where options has the following syntax: [FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] | [ OPEN [open_options] [dbname] ] | NOMOUNT ] wher

RMAN> startup nomount; RMAN> restore controlfile from autobackup; RMAN> alter database mount; RMAN> recover database; RMAN> alter database open resetlogs; restore: 还原（文件级恢复），与backup相对，从备份读出恢复备份

-- 数据库相关设置 [client] default-character-set = utf8mb4 [mysql] default-character-set=utf8mb4 [mysqld] character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-serve