Posts Tagged ‘SQL’

Database Management Flash (Part I)

April 29, 2010, Posted by admin at 10:18 am
At present the management and administration of databasedatabases is essential to the proper functioning in any information system. The amount of data, variety and the operations are done with them makes it nearly impossible to maintain a web site information without the use of a database. (more...)
Read More

Interpreting TKPROF Output

July 3, 2009, Posted by admin at 1:42 pm
Sample TKPROF Out from a sample trace file. call count cpu elapsed disk query current rows ------- ----- ------ ------- --- -------- --------- - — — — — Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 1.20 1.21 0 86091 4 15 ------- ----- ------ ------- --- -------- --------- - — — — — total 4 1.20 1.21 0 86091 4 15 1. A high (near 100%) parse count to execute count ratio when the execute count is greater 1 – if ratio is 1, then the query is parsed each and every time its execute and that needs to be corrected. The ratio should approach zero. The ideal is parse count should be 1 and execute count would be higer.
Read More