Follow Anuragkumarjoy's news and updates in a matter of seconds! We will deliver any update via email, phone or you can read them from here on the site on your own news page.
You can even combine different feeds with the feed for Anuragkumarjoy.
Subscribing and unsubscribing is fast, easy and risk free.
The whole service is free of cost.
Anuragkumarjoy: ORACLE DATABASE PROBLEM AND SOLUTIONS
Is this your feed? Claim it!
Achieving distinct Service Level Agreements (SLAs) for a database requires scaling redundancy and infrastructure complexity.
The three-nine (99.9%), four-nine (99.99%), and five-nine (99.999%) tiers correspond to maximum annual downtimes of 8.76 hours, 52.6 minutes, and 5.26 minutes, respectively.
1. Three-Nine (99.9%) SLA ArchitectureMax Downtime: 8.76 h...In Oracle, LOB means Large Object.
You use a LOB column when the data is too large, unstructured, or not practical to store in normal VARCHAR2 / RAW columns.
When do we use LOB?Use LOBs when you need to store:
1) Large tex...Short Answer
No — HugePages do not directly increase disk I/O throughput or IOPS.
What they do improve is memory-management efficiency for Oracle’s SGA, which can indirectly improve overall database performance in workloads where CPU overhead, memory translation, and buffer cache ef...
One-line explanation
HugePages make Oracle’s SGA memory easier for the OS and CPU to manage, but they do not make the disk, SAN, ASM, or file system read/write data any faster.
Why exactly they do not help I/OLet’s break the full path into layers:
1. Storage / I/O layerThis is where physical I/O happens:
Disk / SSD ...1. Normal OS Page vs HugePage (Fundamentals)Default Linux memory pagesStandard page size: 4 KBEvery memory access uses page tables to translate virtual → physicalLarge SGA → millions of page table entries (PTEs)HugePages (HugeTLB)Larger page size: typically 2 MB (or 1 GB on some systems)Reduces:Page table entriesTLB...