My Experiments with Oracle & Others- By $riram $anka

All About Issues, Errors,News & Latest Findings etc

  • Moderator at

  • Member at

  • Categories

  • Archives

  • January 2012
    M T W T F S S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
  • Blogs I Follow

Archive for January 19th, 2012

Article From Infoworld about Oracle Code flaw

Posted by Sriram Sanka on January 19, 2012


Yesterday, there was an interesting article was posted/published On InfoWorld  By .

http://www.infoworld.com/d/security/fundamental-oracle-flaw-revealed-184163
http://www.infoworld.com/t/data-management/calling-all-oracle-customers-184103?source=fssr

Oracle has published this On Its MOS Bug 12371955  Backup task can cause increased SCN growth rate leading to ORA-600 [2252] errors with Document ID [ID 12371955.8] and Old existing Document 253977.1 will also give some information on it.

for this to be fixed , One should apply the latest CPU patch released on 18-Jan-2012 by Oracle.

Oracle has published an article on MOS yesterday: note 1376995.1 with an associated script “scnhealthcheck.sql” you can find and download in note 1393363.1.which are very helpful.

Posted in Uncategorized | Tagged: , , | Leave a Comment »

SQL and Relational Theory, 2nd Edition by C.J. Date

Posted by Sriram Sanka on January 19, 2012


C.J. Date, is an independent author, lecturer, researcher, and consultant, specializing in relational database technology. He is best known for his book An Introduction to Database Systems.This book does n`t deal with SQL statements .. But  is all about between SQL and the Relational concepts theory  in a mathematical way.How SQL departs from relational theory, the basic principles of relational theory etc…

This Book contains 12 Chapters .. you can find Exercises  at the end of each chapter.I like the Appendix section  of this Book.

Appendix A:  The Relational Model
Appendix B : SQL Departures from the Relational Model
Appendix C:  A Relational Approach to Missing Information
Appendix D:  A Tutorial D Grammar
Appendix E:  Summary of Recommendations
Appendix F: Answers to Exercises
Appendix G: Suggestions for Further Reading.
I recommend this book  for all  who  works with SQL.
you can find his books and videos @ http://www.oreillynet.com/pub/au/2136

Posted in Books | 1 Comment »

New My Oracle Support interface….Soon

Posted by Sriram Sanka on January 19, 2012


On 17-Jan-2012,Oracle Announced,That its going to upgrade  (New)  My Oracle Support User interface, which Oracle ADF.

For More details Please refer The New My Oracle Support User Interface [ID 1385682.1]

http://www.dba-village.com/village/dvp_news.NewsDetails?NewsIdA=3874

Posted in Uncategorized | Leave a Comment »

 
Notes On Oracle

by Mehmet Eser

Oracle Diagnostician

Performance troubleshooting as exact science

deveshdba

get sum oracle stuffs

Know-Oracle

Oracle Cloud ERP Blog by Team CLT

Data Warehousing with Oracle

Dani Schnider's Blog

ORASteps

Oracle DBA's Daily Work

DBAspaceblog.com

Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.

Tanel Poder's blog: Core IT for geeks and pros

Oracle Performance Tuning, Troubleshooting, Internals

Yet Another OCM

Journey as an Oracle Certified Master

DBAtricksWorld.com

Sharing Knowledge is ultimate key to Gaining knowledge...

Neil Chandler's DB Blog

A resource for Database Professionals

%d bloggers like this: