(Craig A. Shallahamer) We have all heard that it doesn’t make sense to have more latches than the number of CPUs. Why? Because you can never use more latches simultaneously than the number of CPUs. While this appears to make perfect sense, it conceals a hidden lie. And here’s why… (R)
Tag: Oracle
Flashback for OCPs
(Aradhana Puri) Oracle Database 10g: Admini-stration I and Oracle Database 10g: Administration II are the two exams a candidate must take to achieve the Oracle Database 10g Administrator Certified Professional level of certification. This column focuses on topics pertaining to Flashback technology a
Build a PL/SQL Web Service
(Jason Price) As we’ve all learned by now, the web services model has proven to be an efficient way to connect applications. Web services protocols such as XML, the de facto standard for information interchange; SOAP (Simple Object Access Protocol), which allows you to exchange XML documents in a di
Retail in Flux as Oracle Battles SAP
(Michael Singer) While SAP and Oracle fight over who has the cash to acquire Retek, the retail industry is stuck with the bill for now, according to research published this week.
Build Your Own Oracle RAC 10g Cluster on Linux and FireWire
(Jeffrey Hunter) One of the most efficient ways to become familiar with Oracle Real Application Clusters (RAC) 10g technology is to have access to an actual Oracle RAC 10g cluster. There’s no better way to understand its benefits—including fault tolerance, security, load balancing, and scalability—t
Oracle Database 10g Standard Edition One: Meeting the Needs of Small and Mid-size Businesses
(Carl Olofson) Databases have become key in enabling businesses to efficiently manage their data assets and to effectively use information to better understand their businesses. This white paper considers the question of what is needed for small and medium-sized businesses to successfully implem
What’s Behind the Retek Battle?
(Evan Schuman) As Oracle and SAP engage in their half-billion battle for who will takeover retail software vendor Retek, the most obvious reasons for the fight are not the true ones.
Introduction to Linux Cluster Filesystems
(Sheryl Calish) Traditionally, a cluster is simply a group of servers, either PCs or workstations, acting as a single system. That definition is stretching considerably, however; cluster technology is now a dynamic field with diverse applications that is continually absorbing new features. Furthermo
Oracle Further Orchestrates Its SOA Forays Part One: Event Summary and Market Impact
(P.J. Jakovljevic) The main idea behind this article is not to further delve into the strengths and weaknesses of the impending merger between Oracle Corporation (NASDAQ: ORCL), the largest database and enterprise software provider (recently “inaugurated” the number two leading business applications
Bitmap Index vs. B-tree Index: Which and When?
(Vivek Sharma) Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values—such as GENDER, MARITAL_STATUS, and RELATION. This assumption is not completely accurate, however. In reality, a bitmap index is always advisable for systems in which data is not
