Tuesday, November 3, 2015

Execution Plan and Statistics

›
http://nimishgarg.blogspot.ae/2015/09/how-to-get-execution-plan-and.html How do you check EXECUTION PLAN of a QUERY? I got this questi...
10 comments:
Tuesday, March 31, 2015

How To Install and manage Java JDK on Oracle Linux

›
taken from : http://lorenzkeller.blogspot.ae/2015/01/how-to-install-and-manage-java-jdk-on.html Every Time I set up an Oracle Li...
3 comments:
Tuesday, March 24, 2015

Setting up Linux with public-yum for all updates

›
Log in as user  root Download the yum repo file from  http://public-yum.oracle.com # cd /etc/yum.repos.d # wget http://public-yum.oracl...
Wednesday, September 24, 2014

How to change the screen resolution in Oracle Enterprise Linux on Vmware

›
I found a lot of trouble related to screen resolution which was struck to 800x600 or 600x480 resolutions  after installation of oracle e...
1 comment:
Sunday, April 6, 2014

Oracle Error with Explain Plan | ORA-00904: "OTHER_TAG": invalid identifier

›
when we try to explan plan, we get the below error, this is becauae the plan table is corrupted drop and recreate the plan table. SQL...
2 comments:
Wednesday, December 25, 2013

ORA-00600: internal error code, arguments: [723], [248344], [248344], [memory leak]

›
Solution: 1. For few leaks size: Ignore this ORA-600 [723] as it is more of a housekeeping message and is not really a cause for concern....
Tuesday, December 24, 2013

Troubleshooting ORA-600 [723] "PGA memory leak

›
PURPOSE: This article discusses the internal error "ORA-600 [723]", what it means and possible actions. The information here ...
1 comment: