在维护数据库过程中,需要把一些年份已久的数据查询出来插入到另外一张表里去,如何去实现?1.没有目标表(这里所谓的目标表就是你要插入数据的那张表)create table 表名(目标表) as select * from 表名(数据源) 条件表达式2.有目标表insert into 表名(目标表) select * from 表名(数据源) 条件表达式成功之后,...【阅读全文】
目的:添加多路复用在线日志组1.添加成员至4号在线日志组alter database add logfile member '/arp/oraarp/oradata/arpdb/redo041.log' to group 4;2.查看在线日志组日志位置column MEMBER format a20;set linesize 200;SQL> select group#,MEMBER,TYPE,STATUS from v$logfile; GROUP# MEMBER ...【阅读全文】
Steps To Migrate/Move a Database From Non-ASM to ASM And Vice-Versa (文档 ID 252219.1)APPLIES TO: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]Information in this document applies to any platform.***Checked...【阅读全文】
ORACLE 配置hugepage 脚本 #!/bin/bash## hugepages_settings.sh## Linux bash script to compute values for the# recommended HugePages/HugeTLB configuration# on Oracle Linux## Note: This script does calculation for all shared memory# segments available when the script ...【阅读全文】
概述:本篇文章重点对 AWR 报告中的 DB Time、DBCPU、IO 等数据进行了说明,可帮助读者更加清楚的理解这些数据代表的含义,与数据库的性能表现有何关系。同时通过两个简短的例子,实践如何分析 AWR 报告。1. AWR 概述Automatic Workload Repository(AWR) 是10g引入的一个重要组件。在里面存贮...【阅读全文】
rem Before begin with replication, DBA should disable such Oracle objects as triggers, rem foreign key constraints, cascading deleting contraints, check constraints and so on set echo offset verify offset feedback offset pagesize 10000set heading offset lines 100spool disable_c...【阅读全文】