Here is a good article about SCN see the link below
Archive for January, 2012
SCN – What, why, and how?
Posted by Sriram Sanka on January 20, 2012
Posted in Oracle Server Administration | Tagged: scn | Leave a Comment »
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 Paul Venezia.
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: infoworld, oracle, oracle customers | 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 »
ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [], [], [], []
Posted by Sriram Sanka on January 11, 2012
Recently we upgraded Our Development Database from Oracle V10.2.0.1 to V10.2.0.5.
Today While I was Compiling an Invalid procedure,
ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of Encountered.
bounds in PH2POP.], [0], [1240], [], [], [], [], []
No clues available On “alert-log” file.
Verified with Oracle Support about it and found that its a Bug{Bug 10400244} on 10.2.0.5.
Oracle Meta-link Document [ID 1358114.1] Will give some clues about it.
Fixing errors other than this Internal error will resolved this issue.
Posted in Oracle Server Administration | Tagged: development database, internal error, oracle support | 11 Comments »
Sriram Sanka - My Experiences with Databases & More 