ITPub博客

create table tom1 (id int,age varchar(10),name varchar(20));insert into tom1 values(1,'20','tom');select * from tom1;##查找当前SGA值show parameter sga_targetselect * from v$sgastat;##查找在给定时间内分配给PGA的最大值select value from v$pgastat where name='maximum PGA allocated'；##sga_tar...

V$ASM_DISK Contains one row for every disk discovered by the Oracle ASM instance, including disks that are not part of any disk group.This view performs disk discovery every time it is queried.V$ASM_DISK_IOSTATDisplays information about disk I/O statistics for each Oracle ASM client.In an Oracle D...

background:  Received Disk capacity Warning on one of our oracle database servers,So needs to check is the data increasing as expect or any abnormal case1. Checked on the target Drive to check if any other files created   --checked--No2. Checked the tablespace useage as followSQL...

ORACLE 本地RESTORE的过程很简单。。但因为之前根本就没有通过TDP从磁带上直接恢复的经历。。。因此为了准备这个通过TDP 直接RESTORE的计划，也算煞费苦心。给oracle提过SR（没有得到明确的解决方案），各种GOOGLE（也没有人实施过）。没办法只能参照SQL SERVER直接从TSM的磁带库上恢复的方法尝试。结果如预料的一样成功。。。希望能帮助到有相同需求的童鞋。。。

----------------------------------------------------------------------------------------------------------------------------------环境介绍：WINDOWS 7/ORACLE 12CORIGNAL DB: prodTARGET db:dev-----------------------------------------------------------------------------------------------------------...

 1.DB 数目:ps -ef|grep pmon2.查看bankup: 及路径crontab -l3.DB 大小:select sum(tsize)/1024/1024/1024 as total_sizefrom (select bytes as tsize from v$datafileunion all select bytes as tsize from v$tempfileunion all select bytes*members as tsize from ...