数据库
一枚小夥子
1.从事软件开发5年, 熟练运用Java,Objective-C,C,C++,Python;熟练各类关系数据库、NoSQL等;
2.职位:架构师, 熟练上述语言相关各类框架
3.由一群忠于IT爱好者组成的开发小团队
4.工作起来很疯狂
展开
-
spfile
lener.__db_cache_size=159383552lener.__java_pool_size=4194304lener.__large_pool_size=4194304lener.__oracle_base='/u01'#ORACLE_BASE set from environmentlener.__pga_aggregate_target=104857600l原创 2013-08-26 11:02:17 · 488 阅读 · 0 评论 -
我的.bash_profile
# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specifice environment and startup programsPATH=$PATH:$HOME/binexport PATHunse原创 2013-10-09 20:17:14 · 521 阅读 · 0 评论 -
oracle实例管理中常用的命令
ALTER DATABASE db01 mount//open read only置数据库为受限状态:数据库未启动时:startup restrict 数据库已启动时:alter system enable restricted session;强制关闭某些已连接的用户:alter原创 2013-10-09 20:15:31 · 550 阅读 · 0 评论 -
oracle中常用的数据字典表 与动态性能视图(不断更新)
查看当前用户的缺省表空间 SQL>select username,default_tablespace from user_users; 查看当前用户的角色 SQL>select * from user_role_privs; 查看当前用户的系统权限和表级权限 SQL>select * from user_sys_privs; SQL>select * from转载 2013-10-09 20:14:37 · 1227 阅读 · 0 评论 -
oracle用户/角色权限查询
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转载 2013-08-21 17:11:28 · 480 阅读 · 0 评论 -
SQL语句查出某个用户下所有表, 以及表对应的同义词,主键,索引。
select t.table_name,i.index_name,i.index_type,s.synonym_namefrom 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原创 2013-08-21 17:17:56 · 1115 阅读 · 0 评论 -
我的.bash_profile .bashrc .emacs
# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specifice environment and startup programsPATH=$PATH:$HOME/binexport PATHunse原创 2013-08-23 21:07:44 · 780 阅读 · 0 评论 -
数据库实例管理中startup
SyntaxSTARTUP options | upgrade_optionswhere options has the following syntax:[FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] | [OPEN [open_options] [dbname] ] | NOMOUNT ]wher转载 2013-10-09 20:16:12 · 515 阅读 · 0 评论 -
restore与recover使用
RMAN> startup nomount;RMAN> restore controlfile from autobackup;RMAN> alter database mount;RMAN> recover database;RMAN> alter database open resetlogs;restore: 还原(文件级恢复),与backup相对,从备份读出恢复备份原创 2013-10-09 20:15:12 · 710 阅读 · 0 评论 -
MySql 关于存储 emoji表情
-- 数据库相关设置[client] default-character-set = utf8mb4 [mysql]default-character-set=utf8mb4[mysqld]character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-serve原创 2017-10-25 13:12:30 · 398 阅读 · 0 评论