刚好遇见Mysql

摘要： SQL> select para_name,para_value from v$dm_ini where para_name='ENABLE_RQ_TO_NONREF_SPL'; LINEID PARA_NAME PARA_VALUE 1 ENABLE_RQ_TO_NONREF_SPL 0 SQL> 阅读全文

摘要： 关机重启数据时遇到报错如下： SQL> alter database open;alter database open*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00704: boot 阅读全文

摘要： 从库 对表做truncate 时报1209 - The MySQL server is running with the--read-only option so it cannot execute this statement 处理： select @@read_only; set global 阅读全文

摘要： 查看统计信息 SELECT object_id , OBJECT_NAME(object_id) AS TableName , name AS StatisticsName , auto_created FROM sys.stats where objectproperty(object_id,'I 阅读全文

摘要： SELECT OBJECT_NAME(IDX.object_id) Table_Name , IDX.name Index_name , PAR.rows NumOfRows , IDX.type_desc TypeOfIndexFROM sys.partitions PARINNER JOIN s 阅读全文

摘要： 查看当前用户 select user； select oid from pg_class where relname='t2';select pid from pg_locks where relation=24627; select * from pg_stat_activity where st 阅读全文

摘要： USE master;gocreate DATABASE ncdbON PRIMARY( NAME = N'ncdb', FILENAME = N'D:\sqldata\ncdb\ncdb.mdf' , SIZE = 1000 , FILEGROWTH = 200, MAXSIZE = 10000) 阅读全文

摘要： ls -l /sys/class/scsi_hostls -l /sys/class/fc_hostfor host in `ls /sys/class/scsi_host` ;do echo "- - -" > /sys/class/scsi_host/${host}/scan; donefor 阅读全文

摘要： 内存溢出参数：-XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=d:/dump 阅读全文

摘要： 用户在rac环境当中添加数据文件时文件存放位置没有存放到asm磁盘组存放到文件系统上，上去处理时文件已处于offline状态，expdp导出某张表时报ORA-31693，ORA-01110错误导致某张表没有备份出来 查看需要恢复的数据文件 select * from v$recover_file 1 阅读全文