Advertisement
Advertisement
- 1. sdstuber 443,501
- 2. schwertner 222,920
- 3. angelIII 145,567
- 4. sujith80 110,921
- 5. sonicefu 76,220
- 6. dvz 68,191
- 7. jinesh_ka... 66,570
- 8. DrSQL 65,282
- 9. nav_kum_v 53,800
- 10. MikeOM_... 48,894
- 11. johnsone 47,977
- 12. rolutola 37,675
- 13. aiklamha 34,990
- 14. rbrooker 34,075
- 15. markgeer 27,009
- 16. ajexpert 26,980
- 17. Milleniuma... 25,805
- 18. awking00 25,028
- 19. joebednarz 21,850
- 20. dbmullen 19,945
- 21. Fekrat 18,750
- 22. Sqaimes 18,720
- 23. ee_rlee 18,318
- 24. Tolomir 13,743
- 25. Dr_Billy 13,200
- 1. sdstuber 501,401
- 2. schwertner 351,424
- 3. angelIII 305,518
- 4. sujith80 272,427
- 5. jinesh_ka... 122,490
- 6. nav_kum_v 117,605
- 7. sonicefu 107,495
- 8. johnsone 103,002
- 9. MikeOM_... 74,562
- 10. markgeer 73,936
- 11. dvz 72,566
- 12. slightwv 70,805
- 13. DrSQL 65,282
- 14. Tolomir 60,371
- 15. jwahl 58,716
- 16. YANN0S 57,625
- 17. rbrooker 55,550
- 18. joebednarz 48,264
- 19. anand_2... 47,685
- 20. paquicuba 45,325
- 21. rolutola 44,668
- 22. awking00 39,567
- 23. aiklamha 34,990
- 24. oleggold 32,515
- 25. gattu007 32,495
| 04.14.2008 at 07:59AM PDT, ID: 23320516 |
|
[x]
Attachment Details
|
||
Performance Tuning in Oracle 10g during Migration
Asked by ajexpert in Oracle 10.x
Tags: Oracle, Oracle 10g, 10g, Performance Tuning
Hi,
I have two queries, these are related so posting one question
Query 1
We are doing migration of huge data in Oracle 10g.
Some of the tables contain a huge data e.g. 7 million records to be migrated.
The table structure of Source Database is different from the Target Database (Where we are doing the migration).
So we have made a use of temporary tables to collect the data from different tables using joins and populate the main table using INSERT INTO tableA SELECT * FROM tableZ
Now the problem statement.
Some of the queries take infinite time and data doesnt get inserted into the main tables. I have seen the explain plan and didnt find anything unusual. The same query works fine when we use date time stamp and restrict the data.
Do we have to look into the temporary and rollback segments?
Query 2
Please examine the screen shots attached for the explain plan of simple query.
I am surprised that using index hint (withhint.jpg) its taking more time. Again, is it because of the temporary and rollback segments?
Start Free Trial
I have two queries, these are related so posting one question
Query 1
We are doing migration of huge data in Oracle 10g.
Some of the tables contain a huge data e.g. 7 million records to be migrated.
The table structure of Source Database is different from the Target Database (Where we are doing the migration).
So we have made a use of temporary tables to collect the data from different tables using joins and populate the main table using INSERT INTO tableA SELECT * FROM tableZ
Now the problem statement.
Some of the queries take infinite time and data doesnt get inserted into the main tables. I have seen the explain plan and didnt find anything unusual. The same query works fine when we use date time stamp and restrict the data.
Do we have to look into the temporary and rollback segments?
Query 2
Please examine the screen shots attached for the explain plan of simple query.
I am surprised that using index hint (withhint.jpg) its taking more time. Again, is it because of the temporary and rollback segments?
Start Free Trial
Attachments:
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628
