DBA’s faced data fragmentation issues frequently. Data fragmentation affects the database performance.
In production database, we need to follow any one of the below method to solve the fragmentation issue.
1. Alter table
--- Also we need to rebuild the indexes associate with tables.
2. Export the table / truncate the table / import the table
3. Create table
4. Online Data Redefinition
Table is not accessible for during the reorganization of table using Method 1, 2 & 3.
RAC Background Processes:
1. Lock Monitor Processes ( LMON)
2. Lock Monitor Services (LMS)
3. Lock Monitor Daemon Process ( LMD)
4. LCKn ( Lock Process)
5. DIAG (Diagnostic Daemon)
import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)Submitted by rajabaskar on Wed, 2009-09-30 19:25
Last week I migrated some schemas from 11g database (184.108.40.206) to 9i database (220.127.116.11).
I used to export the 11g schemas using oracle 9i binary & exported successfully.
While importing 11g schema’s into 9i database I faced below issues.
Error: import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)
Operating system: Sun Solaris 10 / 64 bit processor
I exported the 11g schema’s using 10g binary and imported into 10g database
Last week, I worked on schema refresh in 11g database from one box to another box using data pump.
Schema size: around 90 GB.
Normally we follow below steps: (I have sufficient space in file system, so I am using below steps)
1.Export the schema using expdp/exp utility.
2.Compress the dump file.
3.Transfer the data through ftp to another box.
4.Just import it.
Step 2, depend upon dump size.
I have sufficient space in file system, so I am using method 1.
1.Export the schema using expdp/exp utility (during export they used