liangxianming

摘要： SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0 - ProductionNL 阅读全文

摘要： 自ORACLE7起，ORADEBUG工具就开始被DBA使用了。它可以tracing any session / dump SGA and other memory str ture / wakeup oracle process / suspend and resume processing ….一、 概要首先看看helpSQL> oradebug helpHELP [command] Describe one or all commandsSETMYPID Debug current processSETOSPID <ospid> Set OS pid of process 阅读全文

摘要： Redo Log Data Dictionary Views ViewDescriptionV$LOGDisplays the redo log file information from the control fileV$LOGFILEIdentifies redo log groups and members and member statusV$LOG_HISTORYContains log history informationUndo Space Data Dictionary Views ViewDescriptionV$UNDOSTATContains statistics.. 阅读全文

摘要： udev配置https://blogs.oracle.com/askmaclean/entry/%E5%9C%A8linux_6%E4%B8%8A%E4%BD%BF%E7%94%A8udev%E8%A7%A3%E5%86%B3rac_asm%E5%AD%98%E5%82%A8%E8%AE%BE%E5%A4%87%E5%90%8D%E9%97%AE%E9%A2%98安装grid配置磁盘组http://wenku.baidu.com/view/e5d826c22cc58bd63186bdbd.htmlroot.sh出错,解决参考文件//http://blog.csdn.net/meteorlet/ 阅读全文

摘要： kernel.shmall = 2097152 # 可以使用的共享内存的总量。kernel.shmmax = 2147483648 # 最大共享内存段大小。kernel.shmmni = 4096 # 整个系统共享内存段的最大数目。kernel.sem = 250 32000 100 128 # 每个信号对象集的最大信号对象数；系统范围内最大信号对象数；每个信号对象支持的最大操作数；系统范围内最大信号对象集数。fs.file-max = 65536 # 系统中所允许的文件句柄最大数目。net.ipv4.ip_local_port_range = 1024 65000 # 应用程序可使用的IPv 阅读全文

摘要： SQL> show sgaTotal System Global Area167772160 bytesFixed Size1266392 bytesVariable Size100666664 bytesDatabase Buffers62914560 bytesRedo Buffers2924544 bytesSQL>SQL>select * from v$sgainfo;NAMEBYTES RES-------------------- ---------- ---Fixed SGA Size1266392 NoRedo Buffers2924544 NoBuffer 阅读全文