How to check Optimizer_index_caching from sql prompt

simple answer is

sql>show parameter Optimizer_index_caching;

Done

Enjoy Naveen

Comments

Post a Comment

Popular posts from this blog

Double click a folder open search box

When i am double click or single click my folder the search box opens :- There are 2 methods to solve this issue 1)Simple helps most of the time start-run-cmd Type regsvr32 /i shell32.dll 2)Solution 2 1. Start Registry Editor (Regedt32.exe). 2. Locate and then click the Default value under the following keys in the registry if this problem occurs with folders: HKEY_CLASSES_ROOT\Directory\shell If this problem occurs with drives: HKEY_CLASSES_ROOT\Drive\shell 3. Click Modify on the Edit menu. 4. Type none in the Value data box, and then click OK. 5. Quit Registry Editor.
Read more

ORA 01172 recovery of thread 1 stuck at block 27269 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed

Error: ORA 01172 recovery of thread 1 stuck at block 27269 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed Cause: Crash recovery or instance recovery could not apply a change to a block because it was not the next change. This can happen if the block was corrupted and then repaired during recovery. Action: Perform a RECOVER datafile for the file containing the block. If this does not resolve the problem, then restore the file from a backup and recover it again. Are you archivelog or noarchivelog mode? Try this first 1. SHUTDOWN IMMEDIATE; 2. STARTUP MOUNT; 3. RECOVER DATABASE; 4. ALTER DATABASE OPEN; If this does not work then you will probably have to do media recovery. The type of recovery depends on type of archive mode you are running. Look at alert log for additional info such as file needing media recovery. The type of file needing recovery also determines type of recovery.
Read more

.net framework 4 has not been installed because hresult 0xc80003f3

.Net framework 4 has not been installed because HRESULT 0xc80003f3 Microsoft .Net Installation fails Installation failed with error code: (0xC80003F3) unable to install microsoft .net framework 4 win7 I just found a solution that worked and I will make it a little easier for those who need it. Now remove the  Microsoft  .Net Framework 1.0 and  .Net Framework 4.0 from control panel as well as using the .Net Frame Work clean up tool Restart the system. Create a batch file with the following and run it from a command prompt. *******Start File Below******** regsvr32 MSXML3.dll /s  net stop wuauserv  cd /d %windir%\SoftwareDistribution  rd /s /q DataStore  net start wuauserv regsvr32 softpub.dll regsvr32 mssip32.dll ******End File Above******* Go to services and stop the Windows Update service  Go to the Windows directory (default is c:\Windows) and rename the "SoftwareDistribution" folder to "SoftwareDistribution...
Read more