Why parallel expdp gives unable to write error DATAPUMP With PARALLEL > 1 ON 11.2 RAC

hello, Problem: Datapump on 11.2 RAC with PARALLEL > 1  hits the following errors. ORA-31693: Table data object "IIR_USER"."IDS_00_INUSE" failed to load/unload and is being skipped due to error: ORA-31617: unable to open dump file "/export/expıırdb_04.dmp" for write ORA-19505: failed to identify file "/export/expıırdb_04.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or … Continue reading Why parallel expdp gives unable to write error DATAPUMP With PARALLEL > 1 ON 11.2 RAC

Advertisements

Oracle 11g: DDL WAIT Option (DDL_LOCK_TIMEOUT)

Hello,In Oracle 11g, the new initialization parameter DDL_LOCK_TIMEOUT controls the duration (in seconds) for which a DDL statement will wait for a DML lock.The maximum value of 1,000,000 seconds will result in the DDL statement waiting forever to acquire a DML lock. The default value of zero indicates a status of NOWAIT. SQL> show parameter DDL_LOCK_TIMEOUT; NAME … Continue reading Oracle 11g: DDL WAIT Option (DDL_LOCK_TIMEOUT)

ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

hello, problem : ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device   Linux-x86_64 Error: 28: No space left on device Additional information: 4 Additional information: 981795 Additional information: -1 ORA-31693: Table data object "EBDYSLIVE"."VeriTarihcesi":"SYS_P726" failed to load/unload and is being skipped due to error: ORA-31644: unable to position to block number 842047 … Continue reading ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

How to check Database Size, Used and Free Space in a Database

  select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' GB' "Database Size" , round(sum(used.bytes) / 1024 / 1024 / 1024 ) - round(free.p / 1024 / 1024 / 1024) || ' GB' "Used space" , round(free.p / 1024 / 1024 / 1024) || ' GB' "Free space" from (select bytes from v$datafile … Continue reading How to check Database Size, Used and Free Space in a Database

VirtualBox UDEV SCSI Rules Configuration In Oracle Linux 6 ( Install Oracle Grid on VM )

Oracle grid 11g r2, i added three disk on oracle vm. like as : Identify the Disks (/sbin/scsi_id) [root@erman ~]# /sbin/scsi_id -g -u -d /dev/sdb 1ATA_VBOX_HARDDISK_VB08a6b549-f300066c [root@erman ~]# /sbin/scsi_id -g -u -d /dev/sdc 1ATA_VBOX_HARDDISK_VBe062438c-ccbaf371 [root@erman ~]# /sbin/scsi_id -g -u -d /dev/sdd 1ATA_VBOX_HARDDISK_VBfcd96dfe-06d07a8b Create the "/etc/udev/rules.d/99-oracle-asmdevices.rules" file. [root@erman ~]# KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", … Continue reading VirtualBox UDEV SCSI Rules Configuration In Oracle Linux 6 ( Install Oracle Grid on VM )

Memory management in Oracle database

  SQL> COLUMN component FORMAT A30 SELECT component, current_size, min_size, max_size FROM v$memory_dynamic_components WHERE current_size != 0;SQL> SQL> 2 3 COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE ------------------------------ ------------ ---------- ---------- shared pool 771751936 318767104 771751936 large pool 67108864 67108864 603979776 java pool 50331648 50331648 50331648 streams pool 33554432 0 33554432 SGA Target 2030043136 1862270976 2030043136 DEFAULT buffer … Continue reading Memory management in Oracle database

Sequences (Autonumber) Drop, Create, Alter commands.

In Oracle, you can create an autonumber field by using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key. Oracle SQL Syntax : SELECT last_number FROM all_sequences WHERE sequence_owner = … Continue reading Sequences (Autonumber) Drop, Create, Alter commands.