oracle
jetmouse
这个作者很懒,什么都没留下…
展开
-
oracle查杀会话进程
查看会话对应的系统进程SELECT SID, SERIAL #, PROCESS, LOGON_TIME, USERNAME, PROGRAM, status, '''' || sid || ',' || serial #|| '''' FROM V$SESSION ORDER BY LOGON_TIME DESC;结束会话批量生成kill语句SELECT 'alter system kill session ''' || sid || ',' || serial # |原创 2021-10-17 00:17:35 · 208 阅读 · 0 评论 -
oracle修改db_writer_processes
SQL> show parameter db_writer_processes;NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_writer_processes integer 1SQL> alter system set原创 2021-03-29 11:49:20 · 533 阅读 · 0 评论 -
Oracle 11g安装em
安装em[oracle@database ~]$ emca -config dbcontrol db -repos createSTARTED EMCA at Mar 22, 2021 2:09:04 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following information:原创 2021-03-22 14:22:50 · 543 阅读 · 0 评论 -
Oracle修改最大进程数
查看最大进程数SQL> show parameter processes;NAME TYPE VALUE------------------------------------ ----------- ------------------------------aq_tm_processes integer 1db_writer_processes原创 2021-03-22 13:41:10 · 616 阅读 · 0 评论 -
ORACLE11g redolog查看 创建 修改
Oracle 11g redolog默认大小为50M, 在一些业务场景下会出现报错"Checkpoint not complete"。可以观察redo log file切换时间,考虑增加文件大小,如果 redo log文件太大也可能会造成数据丢失的风险。查看redo log查看日志文件切换时间SELECT b.recid, to_char( b.first_time, 'yyyy-mon-dd hh24:mi:ss' ) start_time, a.recid, to_char( a.fi原创 2021-03-22 12:16:59 · 896 阅读 · 0 评论