ITPub博客

安装greenplum

拓展和缩小LV

Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Slow System And Database Hangs (文档 ID 1194613.1)转到底部...

SQL: How to Find Sessions Generating Lots of Redo or Archive logs (文档 ID 167492.1) ***Checked for relevance on 13-Oct-2015***goal: How to find sessions generating lots of redofact: Oracle Server - Enterprise Edition 8fact: Oracle Server - Enterprise Edition 9fact: Oracle Server - Enterpr...

In this DocumentPurpose...

在使用数据泵导入数据时，有时需要禁用掉主键约束。这样做在特定情况下会存在导入数据后朱建索引丢失和主键对应的索引变化的问题。官方支持如下。禁用约束，删除索引：Oracle? Database Administrator's Guide 11g Release 2 (11.2)--》Managing Integrity ConstraintsYou can use the ALTER TABLE statement to enab...

Oracle Database - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.For details please refer to the appropriate migration manual or Changing platforms requires the database be re-built and / or the data moved using one of the following&...

[root@irac01 ~]# ps -ef|grep '2034\|2035\|2005\|2037'gdm       2005     1  0 Apr17 ?        00:00:12 /usr/libexec/gconfd-2gdm       2034  1998  0 Apr17 ?        00:00:17 metacitygdm      ...

[oracle@irac01 scripts]$ cat cutt.txtablgnfrkjdlgbj;fagh10000afrghnlfnhkjneahablgnfrkjdlgbj;fagh10030afrghnlfnhkjneahablgnfrkjdlgbj;fagh10020afrghnlfnhkjneahablgnfrkjdlgbj;fagh100400afrghnlfnhkjneahablgn...

参考How to Recover a Database Having Added a Datafile Since Last Backup (文档 ID 29430.1)HOW TO RECOVER A DATABASE HAVING ADDED A DATAFILE SINCE THE LAST BACKUP-----------------------------------------------------------------------This bulletin outlines the steps required in performing databas...

环境REDHAT 6.5在A服务器挂载B服务器上的nfs，在B服务器开启防火墙重启服务器等一系列的操作后导致A服务器的其他文件系统读不到。df -h卡主备份无法读取/u01目录umount掉A服务器上的nfs后问题解决。

set serveroutput on declare  t_count   number(10);  t_str VARCHAR2(500);  cursor t_tables is select table_name from user_tables;begin  for t_row in t_tables loop    t_str := 'select count(*) from '|| t_row.table_name;    execute immediate t...

测试在丢失归档日志的情况下，跳过部分归档日志进行数据恢复。1构建测试数据文件。SQL> create tablespace arct datafile '/home/oracle/bbedt/oradata/YBBEDT/arct01.dbf' size 50m;Tablespace created.SQL> create user arct identified by oracle default tablespace arct;User created.SQL> grant dba...

经测试下面的脚本，比较准确select to_number(substrb(dbms_session.unique_session_id, 1, 4), 'xxxx') sid,       to_number(substrb(dbms_session.unique_session_id, 5, 4), 'xxxx') audsid  from dual;

Weblogic有两个jms queue，producer是OSB，通过接口管道向jms queue传输日志。consumer是一个Oracle DB 。刚开始没有问题，待到OSB的并发量达到一天15W时，发现jms queue堵塞严重，weblogic内存消耗巨大。数据库IO和CPU高通过top activity和10046发现consumer对应的表中查询列（行数过亿）未作索引创建索引后所有问题...

COALESCE PARTITION | SUBPARTITION (hash)DROP PARTITION | SUBPARTITIONEXCHANGE PARTITION | SUBPARTITIONMERGE PARTITION | SUBPARTITIONMOVE PARTITION | SUBPARTITIONSPLIT PARTITION | SUBPARTITIONTRUNCATE PARTITION | SUBPARTITION上面所有操作都会引起global索引失效。其中下面的操作会引起local索引失...

可通过dba_ind_statistics和dba_tab_statistics中的LAST_ANALYZED字段，观察是否完成了统计信息的收集，只有完成的收集工作才会记录在这两个视图中。测试过程如下：1    创建一个200w行左右的测试表，数据源为dba_objects。2    查看视图中统计信息：select a.OWNER,a.INDEX_NAME,a.TABLE_NAME,a....

冒泡：点击(此处)折叠或打开import java.util.Arrays;class arrayDemo4{    public static void main(String[] args)     {        i...

点击(此处)折叠或打开import java.util.Scanner;class fundemo6{public static void main(String[] arg){    Scanner s=new Scanner(System.in);    System.out.println("Please input first ...