Oracle Home

Oracle Home

For Everything Oracle and more

Menu

  • Home
  • Articles
  • About Me
  • Computer Book Reviews
  • New Computer Books

Articles

You are here: Oracle Home > Articles

How to find the library cache hit ratio

Library Cache Hit Ratio. select sum(pins) Executions, sum(pinhits) “Execution Hits”, ((sum(pinhits) / sum(pins)) * 100) phitrat, sum(reloads) Misses, ((sum(pins) / (sum(pins) + sum(reloads))) * 100) hitrat from v$librarycache;

orahome 19/09/2018 Articles No Comments Read more

Numeric For Loops in Oracle

Numeric for loops are one of the workhorses of the PL/SQL programming language. They allow you to iterate through a piece of code an arbitrary number of times. For example, to loop through all the years of this decade: For

orahome 19/09/2018 Articles No Comments Read more

Web Site Accessibility Tips and Techniques

Web Site Accessibility Tips and Techniques There is a lot of talk about making websites accessible to people with varying disabilities, this page should help you design your website to better cater for everyone who visits it. Accessibility Tips and

orahome 18/09/2018 Articles No Comments Read more

Windows Oracle Service not starting?

Windows Oracle Service not starting? If when using Oracle on the Windows platform, you get the following error message when trying to login: ORA-12514: TNS:Listener does not currently know of service requested in connect descriptor Your tns listener is probably

orahome 18/09/2018 Articles No Comments Read more

Network Windows XP to Windows Vista

Networking Windows XP to Windows Vista I have more than one PC in my office and house and after newly installing Windows Vista Home Premium I could not get my XP machine to see my Vista machine on my network

orahome 18/09/2018 Articles No Comments Read more

Oracle 11g New Features

It hardly seems five minutes since Oracle 10g was released and we were discussing the new features of that, but now we have Oracle 11g Database. Below are the main new features of Oracle Database 11g. Oracle Real Application Testing

orahome 18/09/201818/09/2018 Articles No Comments Read more

Deleted Oracle Datafile by mistake?

Deleted Oracle DataFile? Database Not Starting? The other day whilst doing a backup of my Windows PC running Oracle 10G, I noticed a large datafile which was too big for the External Hard Drive (as it was greater than 4GB

orahome 18/09/2018 Articles No Comments Read more

Recent Posts

  • Find the size of directories
  • How to Solve IP address conflict on Unix or Windows
  • Delete files older than 30 days in Linux
  • Excel Countif in Oracle SQL
  • Shotcut stuck rendering at certain percentage

Categories

  • Access Functions
  • Affiliate Marketing
  • Articles
  • Book Reviews
    • MySQL Book Reviews
    • Oracle Book Reviews
    • Other Book Reviews
    • PHP Book Reviews
    • Web Marketing Book Reviews
  • Computer Book Releases
  • Computer Magazines
  • Computer Products
  • CSS Tips
  • Excel Functions
  • Javascript Code
  • MySQL Code
  • Oracle Built-in SQL Functions
  • Oracle DBA
  • Oracle Error Codes
    • EXP Error Codes
    • IMP Error Codes
    • ORA Error Codes
    • PLS Error Codes
  • Oracle Forms
  • Oracle Functions
  • Oracle Procedures
  • Oracle SQL
  • PHP Code
  • SEO Tips
  • Unix Code
  • Video Editing
  • Web Hosting

Archives

  • November 2020
  • August 2020
  • June 2020
  • May 2020
  • March 2020
  • March 2019
  • September 2018

Tag Cloud

059652708X 0596100892 0596101058 0596528000 book review computer magazine exp-00079 error code IMP-00066 mysql stored procedure programming ora-00229 error code ORA-00325 ora-00957 error code ORA-01046 ora-01226 error code ORA-01317 ora-01559 error code ORA-01646 ora-01722 ora-01747 error code ORA-01844 ora-02028 error code ORA-02141 ora-02318 error code ORA-02427 ora-02818 error code ORA-03206 ora-06032 error code ORA-06314 ora-06756 error code oracle error ora-00083 oracle error ora-00447 oracle error ora-01141 oracle error ora-01471 oracle error ora-01942 oracle error ora-02233 oracle error ora-02723 oracle error ora-04033 oracle error ora-06544 oracle error pls-00356 oracle pl/sql programming oracle set PLS-00220 pls-00451 error code PLS-00566 windows vista the definitive guide

Amazon Offers

Categories

  • Oracle SQL
  • Unix Code
  • MySQL Code
  • Oracle Functions
  • PHP Code
  • Oracle DBA
  • Oracle Procedures
  • Oracle Forms
  • ORA Error Codes
  • Computer Magazines

Pages

  • ASCII Table Lookup
  • Computer Book Reviews
  • New Computer Books
  • Oracle Database 10g
  • Oracle Employers
  • Oracle Forms
  • Oracle Jobsites
  • Oracle Reports
  • Oracle White Papers
  • Top 10 Javascript Books
  • Top 10 MySQL Computer Books
  • Top 10 Oracle Computer Books
  • Top 10 PHP Computer Books
  • Top 10 Raspberry Pi Books
  • Top 10 SEO and Internet Marketing Books
  • Unix Commands Cheat Sheet
Copyright © 2021 Oracle Home.
The owner of this website, OracleHome, is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking www.oraclehome.co.uk to Amazon properties including, but not limited to, amazon.co.uk
  • Sitemap
  • Contact us
  • Privacy Policy