Here is a much simpler version: ——————————- Create table t1 (c1 number primary); session1: insert into t1 values (1); session2: insert into t1 values (1); — would hang v$lock would reveal session 1 blocking session2 on TX lock why? because you have a constraint where you are asking Oracle to check uniqueness of data (unique…
Case 1:- Allocate More space to temp tablespace before starting the analyze. U can reclaim space by doing. Alter tablespace temp offline; Alter tablespace temp online; Alter tablespace temp coaelsce; Case 2:- If there is some spcace then allocate around 10 GB of space to TEMP .
change the file /etc/sysctl.conf for the kernel parameters. DBA generally do this for changing semaphore and shared memory parameters. Run the following command to change the current kernel parameters. $ /sbin/sysctl -p
A new mechanism to control the allocation of temporary storage space was introduced in 7.3, initially as support for OPS, but it is equally applicable to non-OPS environments. This requires the creation of a designated temporary tablespace, that is one created with the designation TEMPORARY. The effect of this is twofold: 1. No permanent objects…
Restart networking: # /etc/init.d/network restart
=> Edit file /etc/sysconfig/network using your favourite editor. => Look for HOSTNAME=xxxxxx => Change the xxxx to the name you wish to set for your computer. (ex: HOSTNAME=techiecorner.com) => Save the file and restart the server.
http://tldp.org/HOWTO/Partition/intro.html
After doing further research on Oracle errors from metalink, I found following for ORA-8031. CAUSE: The data_object_id (seg/obj) stored in the block is different than the data_object_id stored in the segment header. EXPLAINATION: The expected behavior can be that tables are being truncated while a query from those tables is still in execution. Look if…
Read More “ORA-8031 issue and solution if it is occuring due to truncate.” »
# fdisk -l Disk /dev/hda: 240 heads, 63 sectors, 1940 cylinders Units = cylinders of 15120 * 512 bytes Device Boot Start End Blocks Id System /dev/hda 1 286 2162128+ c Win95 FAT32 (LBA) /dev/hda2 * 288 1940 12496680 5 Extended /dev/hda5 288 289 15088+ 83 Linux /dev/hda6 290 844 4195768+ 83 Linux /dev/hda7 845…
Read More “fdisk -l explaination about Primary-Logical-Extended Partitions” »
Dropping a Database in 10G Consists of the following steps. echo $ORACLE_SID sqlplus “/as sysdba” SQL> startup nomount; ORACLE instance started. Total System Global Area 1077936128 bytes Fixed Size 2034344 bytes Variable Size 427824472 bytes Database Buffers 633339904 bytes Redo Buffers 14737408 bytes SQL> alter database mount exclusive; Database altered. SQL> alter system enable restricted…
