Topic: User Administration >> DML very slow
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| sai |
Posted: Sep 02, 2007 05:08:57 AM |
Total Post: 14
Joined: May, 2007
|
| What are the initial things we should check if DML statements are slow in my database? And how to resolve this issue? |
|
|
 parthokonar |
| Posted: Sep 25, 2007 01:56:25 PM |  |
|
Total Post: 26
Joined: Sep, 2007
|
A lot of things has to be taken care of. The DML statement which is been issued madifying how many records, Whether the statement is cached or not
whereby some io issues are there are not. if large DML operation is going on then we should commit it. Try to get some hit ratios and see the statspack report, it will give a better indepth idea.
|
|
|
|
|
| dbavinod |
| Posted: Feb 15, 2008 02:22:38 AM | |
|
Total Post: 81
Joined: Sep, 2006
|
Failing to set ASSM, freelists or freelist_groups for DML-active tables and indexes can cause very slow DML performance.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Mohammed Taj | 634 |
| Murtuja Khokhar | 587 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 385 |
| Ramesh Jois | 226 |
| neeraj sharma | 189 |
| snehalatha p | 166 |
| Gitesh Trivedi | 157 |
| Gopu Gopi | 149 |
| Kushal ratnaker | 136 |
|
|
