« Back to Members Directory page

niket

Joined on: May 11th, 2009

Recent Posts by niket

• Query tuning
• Global Temporary Table
• Materialised view and Query rewrite.
• Cause of Block Corruption in Testing Environment

Recent Comments by niket

• "Dear Ramesh Sir, Is it possible for you to provide details about Oracle hidden parameter "_or_expand_nvl_predicate" If set "_or_expand_nvl_predi" on Query tuning
• "Dear Ramesh Sir, The index script and column use in the index are as follows. CREATE INDEX IMCL420.BT_BILLING_CHARGES_I4 ON IMCL420.BT_BILLING_C" on Query tuning
• "I have also flush shared pool. I have used histogram (buckets 254) but at the end after all activity i tried. Inorder to check whether it uses inde" on Query tuning
• "INVOICE_CHARGE_PRICE(NUMBER) AvgLen: 4.00 NDV: 218 Nulls: 0 Density: 0.0045872 Min: 0 Max: 126720 Column (#1): CHARGE_ID(NUMBER) AvgLen: " on Query tuning
• "As our application is hard coded i cannot use index hint in the query so i have used DBMS_SQLTUNE (SQL Profiles) - DBMS_SQLTUNE.IMPORT_SQL_PROFILE - i" on Query tuning
• "***************************** Using WORKLOAD Stats CPUSPEED: 888 millions instructions/sec SREADTIM: 12 milliseconds MREADTIM: 143 millise" on Query tuning
• "Dear Ramesh Sir, I have used the event 10053 and output for hinted index query with bind variables are as follows. a) /home/oracle/admin/IMCLDB/" on Query tuning
• " Ramesh , I have carried out all the steps as mention by you. It clear shows that there is only 1 record and 7498 blocks. it clearly shows the diff" on Fragmentation/Space Usage
• "Ramesh, Thanks for the reply. We have the corrupted index on development database. We have taken the backup from production and then restored" on Cause of Block Corruption in Testing Environment
• "Ramesh, The corruption is on Sys index l_COL2 on system tablespace. I dont have backup for the database. How to remove corruption on Sys index. Ki" on Cause of Block Corruption in Testing Environment