ITPub博客

在用到package dbms_metadata的时候发现问题SQL> desc dbms_metadata ERROR: ORA-03117: two-task save area overflow From metalink :Subject: Describe of DBMS_METADATA Raises 'ORA-3117: two-task save area overflow' Doc ID: 362447.1 Type: PROBLEM Modified Date : 22-MAY-2007 Status: PUBLISHEDApplies to:Oracle Server - Enterprise Edition - Version: 10.2This problem can occur on any platform.SymptomsFrom 10.2 SQL*Plus, an attempt is made to describe a large PL/SQL ob

1. 登录mysqlmysql -u root -p2. 查询哪些用户可以登录mysqlmysql> select host,user from user;3. change column name(oracle好像不能change column name)alter table [test] change [old_column_name] [new_column_name] tinytext;4. 修改权限mysql> flush privileges;[@more@]

1.到http://www.rpmfind.net 下载个rdesktop for linux[root]# rpm -ivh rdesktop-1.5.0-5.fc9.i386.rpm Preparing... ########################################### [100%] 1:rdesktop ########################################### [100%]2.rdesktop -g 90% -a 24 192.168.1.45-g 90%表示屏幕显示90%， -a 24表示使用24位显示(可用8 16 24)[@more@]

SQL> select * from v$flash_recovery_area_usage;FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------CONTROL FILE 0 0 0REDO LOG 0 0 0ARCHIVED LOG 92.64 0 229FILE_TYPE

1.发现问题，从statspack中抓到一个sql需要的buffer gets和disk reads很高STATSPACK SQL report for Hash Value: 2088862589 Module: InSiteXMLServer.exeDB Name DB Id Instance Inst Num Release Cluster Host------------ ----------- ------------ -------- ----------- ------- ------------INST933 3144597339 inst933 1 9.2.0.8.0 NO mesdb01Start Id Start Time End Id End Time Duration(mins)--------- ------------------- --------- ------------------- --------------7017 16-Mar-08 00:00:04 7041 17-Mar-08 00:00:04 1,44

Solaris的/home目录是由automounter控制的，只有automounter可以在这个目录下创建文件。如果不希望automounter管理/home目录，可以在删除/etc/auto_master文件中包含"/home"的那行，并且运行automount -v让设置生效，当然reboot也可以.[@more@]

no more addition operation for this message[@more@]

1.ORA-00600: internal error code, arguments: [504], [0x70000000006C900], [640], [7], [shared pool], [2], [0], [0x70000000006C808]solution : bug 升級到92072.ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []solution : To verify this, go to Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option, and retry the compilation. PL/SQL Developer compile問題3.ORA-00600: internal error code, arguments: [kghpi

一般来说，OLTP 系统适合采用全局索引，而数据仓库系统或 DSS 系统适合采用本地索引。此外，用户应尽可能地使用本地索引，因为此种索引更易管理。在选择索引类型时，可以参考以下经验： 如果表的分区键（partitioning column）是索引键（index key）的子集，应使用本地索引。否则继续参考经验 2。 如果索引为唯一索引（unique），应使用全局索引。否则继续参考经验 3。 如果用户对可管理性的要求更高，应使用本地索引。否则继续参考经验 4。 如果应用系统为 OLTP，且对系统的响应时间要求较高，应使用全局索引。如果应用系统为 DSS，且对系

/opt/mpp/lsvdev 查看lunvxdisk list 查看硬盘vsdisksetup -i sdab 初始化硬盘vxdg init oradg305 oradg305-sst0020-disk001=sdd 建dg加入硬盘vxdg -g oradg305 adddisk oradg305-sst0020-disk020=sdwvxdg -g oradg305 adddisk oradg305-sst0020-disk011=sdnvxdg -g oradg305 adddisk oradg305-sst0020-disk004=sdg# vxassist -g oradg305 make vol001 `vxassist -g oradg305 -p maxsize layout=stripe stripeunit=1m ncols=3 oradg305-sst0020-disk006 oradg305-sst0020-disk022 oradg305-sst0020-disk024` layout=stripe stripeunit=1m

Developer met a error ora-30496 when modify column length.SQL> ALTER TABLE Test MODIFY (ID CHAR(10));ORA-30496: argument should be a constant.It maybe a bug , in version 9201 and cursor_sharing=similar.solution:alter session set cursor_sharing=exact;[@more@]

From alert log :< ORA-12012: error on auto execute of job 1 < ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated < ORA-06512: at "PERFSTAT.STATSPACK", line 1361 < ORA-06512: at "PERFSTAT.STATSPACK", line 2471 < ORA-06512: at "PERFSTAT.STATSPACK", line 91 < ORA-06512: at line 1environment : Redhat AS4 , oracle9208Bug number : 27847961.ALTER TABLE PERFSTAT.STATS$SQL_SUMMARY MODIFY CONSTRAINT STATS$SQL_SUMMARY_PK DISABLE NOVALIDATE;

Steps to export/import db statistics between 2 databases.Here schema_name1 = schema_name2rem 1) Create the holding table using DBMS_STATS in production DB1exec dbms_stats.create_stat_table('schema_name1','table_name1');rem 2) Move the statistics to the STATS holding table in Production DB1 for backup purpose exec dbms_stats.export_schema_stats('schema_name1','table_name1');rem 3) Create the holding table using DBMS_STATS in DB2exec dbms_stats.create_stat_table('schema_name2','table_name2');rem 4

1) create sqlnet.ora in $ORACLE_HOME/network/admin with this content# SQLNET.ORA Network Configuration File: /oracle/app/orai911/product/9.2.0.1.0/network/admin/sqlnet.ora# Generated by Oracle configuration tools.tcp.validnode_checking = yestcp.invited_nodes = (szmesdb01)2) reload oracle listener Lsnrctl reload test[@more@]

SQL> select * from test;CARD Q1 Q2---------- ---------- ----------a 1 12a 1 21a 2 43a 2 65b 1 12b 2 87b 2 17 rows selected.SQL> SELECT 2 a.card,a.q1,3 SUM(decode(a.q1, 1, a.q2, 0)) x1, 4 SUM(decode(a.q1, 2, a.q2, 0)) x25 FROM test a 6 GROUP BY a.card,a.q17 ORDER BY 1; CARD Q1 X1 X2---------- ---------- ---------- ----------a 1 33 0a 2 0 108b 1 12 0b 2 0 88SQL> select * from test1;CARD Q1 Q2 Q3 Q4---------- ---------- ---------- ---------- ----------a 3 1 2 3b 1 2 3 4SQL> SELECT 2 t.c

取消註冊catalogSQL> select db_key,db_id from db; db_key db_id 429 201401412SQL> execute dbms_rcvcat.unregisterdatabase(429,201401412); /**** MAINTENANCE COMMANDS ****/ CROSSCHECK BACKUP; delete expired backup; REPORT NEED BACKUP; DELETE OBSOLETE; DELETE ALL OBSOLETEDELETE ALL EXPIRED EXPIRED 表示备份集在磁盘或者磁带上不存在了OBSOLETE 表示根据保存策略判断备份集不再需要了LIST BACKUP SUMMARY; list backup of controlfile; list backupset; restore database validate; /* check if database can be re

常用的分析函数如下所列:row_number() over(partition by ... order by ...)rank() over(partition by ... order by ...)dense_rank() over(partition by ... order by ...)count() over(partition by ... order by ...)max() over(partition by ... order by ...)min() over(partition by ... order by ...)sum() over(partition by ... order by ...)avg() over(partition by ... order by ...)first_value() over(partition by ... order by ...)last_value() over(partition by ... order by ...)lag() over(partition by ... order b

$ more create9idb.sqlspool CreateDB.log-- shutdown immediate;-- shutdown abort;-- !strings /oracle/305/oracle/product/9.2.0/dbs/spfileinstance.ora > /oracle/305/oracle/product/9.2.0/dbs/pfileinstance.orastartup nomount pfile=/oracle/app/oracle/product/9.2.0/dbs/pfileinstance.ora;!mkdir -p /oracle/305/oradata/instance!mkdir -p /oracle/305/redo1/instance!mkdir -p /oracle/305/redo2/instance!mkdir -p /oracle/305/arch/instance!rm /oracle/305/oradata/instance/*.ctl!rm /oracle/305/oradata/instance/*

[root ~]# more /etc/resolv.conf# Added by kickstart file# -----------------------domain test.comnameserver 165.204.224.33nameserver 165.204.224.2[root ~]# grep hosts /etc/nsswitch.conf#hosts: db files ldap nis dnshosts: dns files [root ~]# time nslookup szcadminServer: 165.204.224.33Address: 165.204.224.33#53Name: szcadmin.test.comAddress: 165.204.233.5real 0m0.079suser 0m0.004ssys 0m0.008s[root ~]# time nslookup localhostServer: 165.204.224.33Addr

SQL> conn /as sysdbaConnected.SQL> show parameter utl SQL> @?/rdbms/admin/dbmslm.sqlPackage created.Grant succeeded.SQL> @?/rdbms/admin/dbmslmd.sqlProcedure created.No errors.Grant succeeded.PL/SQL procedure successfully completed.Package created.SQL> alter system set utl_file_dir='/oracle/304/arch' scope=spfile;System altered.SQL> shutdown immediateSQL> startupSQL> execute dbms_logmnr_d.build ('test.ora','/oracle/304/arch');PL/SQL procedure successfully completed.SQL>