oraclequest.wordpress.com

Relative CPU speed | oraclequest

https://oraclequest.wordpress.com/2012/04/01/relative-cpu-speed

Just another WordPress.com site. April 1, 2012. On my job I often have to move a database to a newer hardware. Sometimes company decides to do a tech refresh, sometimes it is a new company spin-off or a data center consolidation. When you get to work on a new hardware, it is always interesting to see what it is capable of and how does it compare to the old system. Select count(*) from emp,emp,emp,emp,emp. The beauty of this sql was that it required almost no IO. The sql I came up with was this:. It gener...

Using EM 12c repository to find ASM growth rate | oraclequest

https://oraclequest.wordpress.com/2013/01/09/using-em-12c-repository-to-find-asm-growth-rate

Just another WordPress.com site. Using EM 12c repository to find ASM growth rate. Using EM 12c repository to find ASM growth rate. January 9, 2013. Our company collocates multiple databases on Linux RAC grids to reduce hardware, OS and HA license expenses. All the databases on a grid are sharing few ASM disk groups. In this environment, when an ASM disk group usage does grow, the question becomes how to track which database is causing most of the growth. One solution is to query EM 12c repository directly.

High-Performance Batch LOB Insert. Part 2. Subpartitions | oraclequest

https://oraclequest.wordpress.com/2011/03/02/high-performance-batch-lob-insert-part-2-subpartitions

Just another WordPress.com site. High-Performance Batch LOB Insert. Part 2. Subpartitions. High-Performance Batch LOB Insert. Part 2. Subpartitions. March 2, 2011. In my recent post High-Performance Batch LOB Insert. Part 1. Extrapolating timings we can arrive at following runtime estimates for 12,000,000 records we were expecting to transfer: 22 hrs for Option 2 and 5 hrs for Option 3. These estimates seemed to leave only Option 3 “enable storage in row” as being able to fit in one-night...Since I reall...

System Throughput Comparison | oraclequest

https://oraclequest.wordpress.com/2012/04/01/cpu-throughput-comparison

Just another WordPress.com site. April 1, 2012. When I brought these observations up to our hardware planners, their counter-argument was – ok, single process may be somewhat slower, but with hundreds of database connections the total system throughput should be great. This got me into thinking of how can I run same SQL test with multiple parallel processes. And here is the script I came up with. Here is sample output:. To get a measure of throughput I simply multiply 100 million records counted in one S...

Empirical Oracle 11g Process RAM Usage | oraclequest

https://oraclequest.wordpress.com/2011/08/15/empirical-oracle-11g-process-ram-usage

Just another WordPress.com site. Empirical Oracle 11g Process RAM Usage. Empirical Oracle 11g Process RAM Usage. August 15, 2011. As we were starting to get ready for 10g to 11g database upgrade, I got curious – how much more RAM the 11g may require? How can I estimate the required RAM ahead of time? So the formula becomes:. Oracle RAM = SGA PGA PM. How do we estimate PM? I will be using empirical approach. I will start a database session and run OS utilities on the server process. In the output above RE...