ITPub博客

11g 启用或关闭自动统计任务[@more@]11g启用或关闭自动统计等任务11g默认启动了三个任务，分别是统计信息收集、段指导、自动 SQL 优化，默认运行时间是周一到周五是运行4小时（22:00——次日2:00），周六日运行20小时（6:00——次日2:00）。禁用这三个任务的sql为：BEGINdbms_auto_task_admin.disable(client_name=>'auto optimizer stats collection',operation=>NULL,window_name=>NULL);dbms_auto_task_admin.disable(client_name=>'auto space advisor',operation=>NULL,window_name=>NULL);dbms_auto_task_admin.d

ORA-600 [kkopmCheckSmbUpdate:2] or [kkopmCheckSmbUpdate:3]这个错误可以确认的是oracle的缺陷。bug号是： 13555112oracle有相关的补丁出来了[@more@]DescriptionORA-600 [kkopmCheckSmbUpdate:2] or [kkopmCheckSmbUpdate:3] using plan baseline Workaround Disable the plan baseline that is used by the query. You can find out which plan baseline to disable by doing explain of the query and display its plan using /rdbms/admin/utlxpls.sql in SQLPlus Please note: The above is a summary description only. Ac

好久没有安装2005了，结果花了我2个小时。备注一下： 1. 内存最好大于1G; 2.一定要安装IIS。。。。。[@more@]sq

http://www.tianya.cn/publicforum/content/no11/1/1136654.shtml[@more@]

修改上传文件大小 <constant name="struts.multipart.saveDir" value="/tmp" /> <constant name="struts.multipart.maxSize" value="10485760" />structs.xml[@more@]

oracle bulk collects 之 java select[@more@]stmt.execute("CREATE TYPE EMPLOYEE AS OBJECT (EmpName VARCHAR2(50),EmpNo INTEGER))");stmt.execute("CREATE TYPE EMPLOYEE_LIST AS TABLE OF EMPLOYEE");stmt.execute("CREATE TABLE EMPLOYEE_TABLE (DeptName VARCHAR2(20), Employees EMPLOYEE_LIST) NESTED TABLE Employees STORE AS ntable1");stmt.execute("INSERT INTO EMPLOYEE_TABLE VALUES ("SALES", EMPLOYEE_LIST (EMPLOYEE('Susan Smith', 123), E

1. 现象： Incorrect key file for table ‘/xxxxxxxx/xxxx.MYI'; try to repair it 2.解决措施： 1）. 先停止MYSQL数据库进程； 2）. 备份整个文件。 3）. 重新启动数据库； 4）. 手工修复： check table xxx； repair table xxx；[@more@]

Windows Registry Editor Version 5.00[HKEY_CLASSES_ROOT*shellrunas]@="管理员取得所有权""NoWorkingDirectory"=""[HKEY_CLASSES_ROOT*shellrunascommand]@="cmd.exe /c takeown /f "%1" && icacls "%1" /grant administrators:F""IsolatedCommand"="cmd.exe /c takeown /f "%1" && icacls "%1" /grant administrators:F"[HKEY_CLASSES_ROOTexefileshellrunas2]@="管理员取得所有权""NoWorkingDi

ls *.txt |awk '{ print $0 }' |xargs -n1 gzip[@more@]ls *.txt |awk '{ print $0 }' |xargs -n1 gzip

To enable multipathing on RedHat Linux 5.3 By Robert Tsai on Aug 10, 2009 Set multiple cable connections per your design such as dual connections from the server to the SAN switch and then to the storage array. At Sun Solution center, we use QLogic HBA and its driver can be downloaded directly from Qlogic web site. Check the HBA used and ensure to get the correct driver. i.e. the HBA model we used is QLE2462, download its driver accordingly from below: http://driverdownloads.qlogic.com/QLogicDri

wmsys.wm_concatSELECT t.TABLE_NAME, wmsys.wm_concat(t.COLUMN_NAME) as result FROM user_tab_cols t where table_name = 'C_E_CELEVENTI_N' group by TABLE_NAME [@more@]