• Manual Optimisation
  2008-04-30, Ask Tom HOT ARTICLES
  what do you think of the technique used in http://jonathanlewis.wordpress.com/2008/04/27/manual-optimisation/ ? I would like to hear your opinion. It's very interesting but I think we should not use it, am I right ?
  
  
• Oracle installed in E drive and C drive got formatted
  2008-04-17, Ask Tom HOT ARTICLES
  Hi Tom, I installed Oracle9i server in E drive of my computer and I formatted the C drive thinking Oracle is in E drive. But now I am unable to connect to oracle. Guide me what are the steps that i have to follow to start my oracle with the previo...
  
  
• How to retrive last page without querying for row count.
  2008-04-16, Ask Tom HOT ARTICLES
  We have a requirement of pagination where the page size is 1000. we need to provide an option of first, next, prev, last to the user. As suggested in this forum we can use rownum to achieve first, next and prev as follows pagesize = 1000 foprm...
  
  
• Oracle Resource Manager ('overhead')
  2008-04-14, Ask Tom HOT ARTICLES
  Hello Tom, I am looking into using Oracle Resource Manager to limit resources by AppDev folks on the production database so as allow them access yet not hurt production performance. 1) Is Resource Manager a good tool to help achieve my goal, ab...
  
  
• what different between Administration ,Manufacturing,Financial
  2008-04-07, Ask Tom HOT ARTICLES
  hi tom, i have 2 questions :- 1) what different between the following fields :- - Oracle Database Administration - Oracle Erp Manufacturing - Oracle Erp Financial 2) are shifting to Administration make me a good developer ???...
  
  
• Create Insert Statements Dynamically
  2008-04-07, Ask Tom HOT ARTICLES
  Tom,How do you create insert statments dynamically if I give a table name? in TOAD tool, they have this option for each table [Create insert statements] and I was wondering what kind of logic they might have used to create them. I was trying it my...
  
  
• Why a transaction cannot reuse space that was deleted from
  2008-04-02, Ask Tom HOT ARTICLES
  Tom, in your recent presentation in Hartford you were discussing the difference in refreshing materialized views from version 9 to 10 in that it went from a truncate/insert to a delete/insert which caused some confusion. You also mentioned in the co...
  
  
• Expert one-on-one - ebook version
  2008-03-31, Ask Tom HOT ARTICLES
  Tom Is Expert one-on-one ebook version available? If No, will it be made availble? Thanks - Sri
  
  
• Tuning Tips
  2008-03-31, Ask Tom HOT ARTICLES
  Dear Mr.Kyte, Greetings Can you please give me some guidelines of how to tune these topics: 1)db file scattered read, db file sequential read. 2)hot data files reading (Hot blocks), physical read and logical read. 4)high CPU Time. 3) and ...
  
  
• 10g SQL Profiles
  2008-03-24, Ask Tom HOT ARTICLES
  Can you explain how SQL profiles work when it comes to recommendations from the SQL Tuning Advisor in 10g? Thanks in advance.
  
  

Powered by Ask Tom HOT ARTICLES