asmcheck

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 […]

Read More

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:

As you can see redo size in statistics […]

Read More

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 […]

Read More

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 […]

Read More