QUERY 3: To check the size of partition table in Oracle. select PARTITION_NAME,sum(bytes)/1024/1024/1024 GB from dba_segments where SEGMENT_NAME=upper('&TABLE_NAME') and PARTITION_NAME='P01' group by PARTITION_NAME; QUERY 4: To check table owner: select owner from dba_segments where s...
compute sum of savings on report--To Check Database block size:-- column value new_val blksize select value from v$parameter where name = 'db_block_size' /-- To check how much space can be reclaimed --select file_name, ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) smallest, ceil( bl...
If you clear all three check boxes (setting all three bound properties to false), there is no selection; only the lead selection is shown. You may notice that the "Cell Selection" check box is disabled in multiple interval selection mode. This is because cell selection is not supported in...
Re: How to change the Oracle redo log block size Fewer larger IOs improves throughput (depending on the application) by improving the efficiency of the IO.In the case where there are large commits with long running transactions,and there is a large log buffer, sending 1K IO packets is n...
Current Oracle Solaris releases support 512n disks as well as AF disks. Identifying an AF Disk's Type The following examples show how to identify the logical block size and the physical block size of a specified disk, which in turn, identifies whether the disk is 512n, 512e, or 4kn. ...
Identifies block size, such as 128 Kbytes or 256 Kbytes. A large block size value decreases the time it takes to copy the disk. For more information, see thedd(1M) Check the new file system. #fsck /dev/rdsk/device-name Mount the destination disk's root (/) file system. ...
Oracle Solaris customers are reporting ZFS compression ratios in the 2x to 18x range, depending on the compressible workload. If you haven't tried ZFS compression previously because you were concerned about CPU overhead, consider enabling LZ4 (lz4) compression. ...
Oracle database seems to be continually growing in size how to extend the tablespace ? satellite-syncfails with Raw 'ORA-01654: unable to extend index RHNSAT.RHN_PACKAGE_FILE_CID_PID_IDX by 1024 in tablespace -or Raw 'ORA-01654: unable to extend index RHNSAT.RHN_PKG_CL_PID_N_TXT_TIME...
Start the original VM and check its connectivity.RHEL/Centos/Oracle 6.x && Oracle 8.x && RHEL/Centos 7.x with RAW PartitionsStop or deallocate the affected VM. Create a rescue VM image of the same OS version in the same resource group (RSG) and location using a managed disk. Use the...
Linux OS - Version Oracle Linux 5.0 and later Information in this document applies to any platform. Goal *) What is a ramdisk The RAM disk drive is a wayto use main system memory as a block device( Memory used as Disk partition to store data ). It is required for initrd, an initial...