Author: Sriram Sanka
-
Oracle Database 12c Interactive Quick Reference Guide
Downloadable Interactive Quick Reference for Oracle Database 12c available @ http://www.oracle.com/go/?&Src=7875565&Act=4&pcode=WWOU13045613MPP009
-
ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []
Today, we were encountered with this internal error on One of our test environment. On Our Database ,we have 2 temporary table-spaces with a Temporary table space group. While we are performing Data pump Import (IMPDP) into another machine , The job was failed multiple times with following error on screen …. Screen Error :…
-
ORA-27102: out of memory” While Creating a Database
Today ,While Installing Oracle V 10g Using DBCA On a 32 bit Linux machine with 16 GB of RAM,(allocated 5GB as SGA ) We were encountered with this Error and unable to go further. [oracle@db ~]$ oerr ORA 27102 27102, 00000, “out of memory” // *Cause: Out of memory // *Action: Consult the trace file…
-
Microsoft__SQL_Server__2012_Pocket_Consultant By William R. Stanek
Well written and Well Organised resource for DB Admins By William R. Stanek This Book really suits for Current SQL Server database administrators. Accomplished users who have some administrator responsibilities. Administrators migrating to SQL Server 2012 from previous versions. Administrators transitioning from other database architectures. I like the way author Presented the topics in a step-by-step…
-
SCN – What, why, and how?
Here is a good article about SCN see the link below SCN – What, why, and how?
-
Article From Infoworld about Oracle Code flaw
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…
-
SQL and Relational Theory, 2nd Edition by C.J. Date
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…
-
New My Oracle Support interface….Soon
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
-
ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [], [], [], []
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 bounds in PH2POP.], [0], [1240], [], [], [], [], [] Encountered. No clues available On “alert-log” file. Verified with Oracle Support about it and found that its a…
-
“racgmain” Processes
Some good Experience for Me today.Early in the Morning …… One of Our RAC node filled up with 100% CPU usage.As part of Investigation We found that this was because of racgmain Process. It was filled-up with more than 250 racgmain process which are consuming CPU a lot.Due this Our System got Very slow. To…
Sriram Sanka 