Friday , October 4 2024

Primary Key Creation Procedure

In today’s article we will be discussing the Primary Key Creation Procedures in Oracle Database.

1. Check if there is another Primary Key with the same name.

2. Parallel is given to ensure that the result occurs in a short time.

3. Since the study reporting will be done in the database, the relevant REPLICAT Process is STOPPED.

4. At this time, if the database is in archive mode, the archive amount should be checked.

There should be twice the space of the table size.

If there is not enough space, the second step of the return plan should be applied and then the operations should be started.

** If in archive mode;

5. The tablespace in which the table is located should be checked.

If there is not enough space, RETURN PLAN step 3 should be applied.

6. The Primary Key creation process is started on the table.

It is more logical to do this process on the TERMINAL Server, not on the personal computer.

Thus, the processes are completed without disconnecting the connection.

7. Database RAM and CPU usage should be monitored with both OEM and TOP commands.

8. Check INDEX.

9. Restart REPLICAT.

Return Plan

1. If an increase in server RAM and CPU is observed, the process that started the INDEX process should be killed to free up resources.

** This process should be done on the same NODE.

2. Index creation process causes high amount of archive logs.

Therefore, FRA area should be kept under observation.

If this area starts to fill up, the oldest archive records should be deleted to make room in FRA.

3. The tablespace size of the table should be kept under control.

If there is a possibility of a space problem, the following steps should be followed.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories