tag:blogger.com,1999:blog-4589246368716980870.post578441319806495704..comments2023-05-22T02:31:57.051-07:00Comments on Oracle tips and techs: Check Database User privileges and RolesSelvakumar Nagulanhttp://www.blogger.com/profile/03703859252278464644noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4589246368716980870.post-26247109679242933922011-04-26T22:17:18.480-07:002011-04-26T22:17:18.480-07:00Your databases are fine at this point. All the 3 a...Your databases are fine at this point. All the 3 are far below 15%. <br /><br />Oracle places the data in cache before it does any operation on those datas (update/retrieve) and gives the o/p for easy retrieval of the same data when accessed again. Also oracle places the whole data block in the cache rather than the single data(record) alone. So when data is accessed from the same table and does not find the data in the data block which it has placed in cache of that particular table, this is called cache miss. Hence it has to place a new data block which contains the required data which is called as cache gets. Also cache has to be tuned enough to get the records from the cache to avoid high i/o which will become bottleneck for performance. <br /><br />Hope this helps you. <br />You may correct me if I miss something.Selvakumar Nagulanhttps://www.blogger.com/profile/03703859252278464644noreply@blogger.comtag:blogger.com,1999:blog-4589246368716980870.post-4123096966010673702011-04-26T07:09:50.891-07:002011-04-26T07:09:50.891-07:00really excellent work .appreciate for the efforts ...really excellent work .appreciate for the efforts u always put in ...great going ..move on ..<br /><br />doubt <br />select sum(getmisses)/sum(gets)"miss ratio" from v$rowcache;<br /><br />miss ratio<br />----------<br />.005271585<br />------------------<br />select sum(getmisses)/sum(gets)"Miss ratio" from v$rowcache;<br /><br />Miss ratio<br />----------<br />.005131652<br />----------------------<br />select sum(getmisses)/sum(gets)"Miss ratio" from v$rowcache;<br /><br />Miss ratio<br />----------<br /> .01052949<br /><br />---------------<br /><br />three different values in three dbs can u tell why and what .......? mail meariefhttps://www.blogger.com/profile/11485813844375527617noreply@blogger.com