set lines 300set pages 1000col gname form a10col dbname form a10col file_type form a18 SELECTgname as “DG NAME”,dbname,file_type,round(SUM(space)/1024/1024) mb,round(SUM(space)/1024/1024/1024) gb,COUNT(*) “#FILES”FROM(SELECTgname,regexp_substr(full_alias_path, ‘[[:alnum:]_]*’,1,4) dbname,file_type,space,aname,system_created,alias_directoryFROM(SELECTconcat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) full_alias_path,system_created,alias_directory,file_type,space,level,gname,anameFROM(SELECTb.name gname,a.parent_index pindex,a.name aname,a.reference_index rindex ,a.system_created,a.alias_directory,c.type file_type,c.spaceFROMv$asm_alias a,v$asm_diskgroup b,v$asm_file cWHEREa.group_number = b.group_numberAND a.group_number = c.group_number(+)AND a.file_number = c.file_number(+)AND a.file_incarnation = c.incarnation(+) ) START WITH (mod(pindex, power(2, 24))) = 0AND rindex […]
Author: Oracle DBA
Redo size is not empty for select operation ?
Have you ever met situation that for “select only” operation “redo size” has different value than 0 in autotrace output? It’s possible that sometimes we may face a bug and setting event 70150 or 71830 in database could fix this issue. One example below: Simple count:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
SQL> set autotrace on SQL> select count(*) from ORAVSP; COUNT(*) ---------- 67108864 Elapsed: 00:00:10.79 Execution Plan ---------------------------------------------------------- Plan hash value: 1321210629 --------------------------------------------------------------------- | Id | Operation | Name | Rows | Cost (%CPU)| Time | --------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 598K (96)| 01:59:42 | | 1 | SORT AGGREGATE | | 1 | | | | 2 | TABLE ACCESS FULL| ORAVSP | 64G| 598K (96)| 01:59:42 | --------------------------------------------------------------------- Note ----- - dynamic sampling used for this statement (level=2) Statistics ---------------------------------------------------------- 4 recursive calls 0 db block gets 263992 consistent gets 202814 physical reads 4345324 redo size <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 425 bytes sent via SQL*Net to client 419 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed |
As you can see redo size in statistics […]
Linux – disable IPv6
This article describes how to disable IPv6 functionality in Oracle Linux 5 according to note “How to disable IPV6 on Oracle Linux 5 (Doc ID 1666028.1)”
Virtualbox – install Guest Additions
VirtualBox documentation describes that the Guest Additions are designed to be installed inside a virtual machine after the guest operating system has been installed. They consist of device drivers and system applications that optimize the guest operating system for better performance and usability. After installation there will be no limitations for mouse as there is […]
Oracle Linux installation [minimal version]
In previous article we discussed how to install Oracle Linux Desktop Version with many useful packages. This article describes how to install Oracle Linux 5.4 x86 version in minimal mode. In fact according to note “Linux OS Installation with Reduced Set of Packages for Running Oracle Database Server (Doc ID 728346.1)” the OL5 and RHEL5 […]
Oracle Linux installation [desktop version]
In previous article we discussed how to create empty virtual machine. This article describes how to install Oracle Linux 5.4 x86 version in Desktop mode. Desktop mode allows you to work in graphical environment with graphical editor like gedit, browser like firefox and other tools. You can also check another article which describes minimal Linux […]
Virtualbox – Create VM group
VM groups allow to manage them as group in one click – you can start/stop multiple machines in the same time with one click. Virtual machines management is easier and when you have many virtual machines you can group them either by operating system or functionality.
Virtualbox – Create empty Virtual Machine
Before you start creating new virtual machine be sure that you have latest version of VirtualBox downloaded and installed according to Installation details. In this article we’ll focus only on virtual machine creation. Further steps like how to create a group of virtual machines, install operating system (RHEL, Oracle Linux ) or add more disks to […]