Marcus Mönnighttps://marcusmonnig.wordpress.com
Oracle, Databases, Cloud and other IT stuff
Wed, 19 Sep 2018 20:35:11 +0000 en
hourly
1 http://wordpress.com/https://secure.gravatar.com/blavatar/d564468426f4ac15f21e0a367d17081a?s=96&d=https%3A%2F%2Fs0.wp.com%2Fi%2Fbuttonw-com.pngMarcus Mönnighttps://marcusmonnig.wordpress.com
Getting the most out of your Oracle database processor license in the cloud – if you dare…https://marcusmonnig.wordpress.com/2017/01/28/getting-the-most-out-of-your-oracle-database-processor-license-in-the-cloud-if-you-dare/
https://marcusmonnig.wordpress.com/2017/01/28/getting-the-most-out-of-your-oracle-database-processor-license-in-the-cloud-if-you-dare/#commentsSat, 28 Jan 2017 13:33:29 +0000http://marcusmonnig.wordpress.com/?p=694Continue reading →]]>Following up on the the Oracle doubled the costs for database licenses on MS Azure and partly on AWS post, I wondered with which setup on which cloud provider you would get the most bang out of an Oracle SE2 database processor license and what the recent change in Oracle licensing means especially for Azure users.

I’ve done an overly simple CPU benchmark test against Azure, AWS and Oracle cloud instances to get a rough idea how they perform in comparison. I’ve used sysbench for this (details below), which basically spits out you the time it needs to find prime numbers.

The numbers

The green rows are setups that you would actually use – you would not select a server instance with just one or two cores if the Oracle database processor license allows you to use it for a server with more cores.

Results

One Oracle database SE2 processor license on Azure will get you only 22% of the CPU power compared to what you get in the Oracle cloud. With AWS you get around 40% of the CPU power compared to the Oracle cloud.

It’s only a point-in-time test, not a statistically valid anaylsis over a longer period of time.

This is a constantly moving target since cloud provider upgrade the underlying hardware.

Probably a lot more…

]]>https://marcusmonnig.wordpress.com/2017/01/28/getting-the-most-out-of-your-oracle-database-processor-license-in-the-cloud-if-you-dare/feed/1mamoennigcloud_cpu_benchmarkOracle doubled the costs for database licenses on MS Azure and partly on AWShttps://marcusmonnig.wordpress.com/2017/01/25/oracle-doubled-the-costs-for-database-licenses-on-ms-azure-and-partly-on-aws/
https://marcusmonnig.wordpress.com/2017/01/25/oracle-doubled-the-costs-for-database-licenses-on-ms-azure-and-partly-on-aws/#respondWed, 25 Jan 2017 13:51:50 +0000http://marcusmonnig.wordpress.com/?p=685Continue reading →]]>On January 23rd, 2017 Oracle published a new version of their “Licensing Oracle Software in the Cloud Computing Environment” document.

Now, the same server on MS Azure (all instance types) or on AWS servers that do NOT have hyperthreading (namely the t2 and m3.medium instance types as stated here: https://aws.amazon.com/ec2/instance-types/) will need 8 processor licenses.

For Standard Edition licenses, the document makes no difference regarding hyper-threading and simply sets back MS Azure users: One processor license is needed for four or fewer AWS vCPUs, however one processor license is needed for just two or fewer AWS (correction) Azure vCPUs.

Additionally, Oracle halved the maximum number of vCPUs that you are allowed to use in Azure instances running Standard Edition 2 from eight to four.

In other news: I have added a piece of paper to my copy of my employment contract stating that, in effect as of today, my hour no longer has 60, but only 30 minutes.

After about 4 months of preparation and by far the most stressing exam in my professional life, I am extremely happy about the email from Oracle University today saying:

Congratulations! on the successful completion of the Oracle DBA 11g Certified Master practicum.

]]>https://marcusmonnig.wordpress.com/2016/11/24/oracle-certified-master-exam-passed/feed/2mamoennigoracle_master.png (352×352)Mumbai version 3.1.1 availablehttps://marcusmonnig.wordpress.com/2016/09/21/mumbai-version-3-1-1-available/
https://marcusmonnig.wordpress.com/2016/09/21/mumbai-version-3-1-1-available/#commentsWed, 21 Sep 2016 16:40:19 +0000http://marcusmonnig.wordpress.com/?p=666Continue reading →]]>Yes, it is still alive. Version 3.1.1 of Mumbai is available for download.

Mumbai served me well over the last months, so there were no updates for quite some time. However, it’s time to do at least some compatibilty fixes, especially in regards to 12c.

So here is the first shot which fixes some of the major compatibilty problems. I expect that there are more things to fix (and extend) regarding 12c and RAC in the near future.

If you have feature requests, let me know in the comments.

Here’s the list of changes for 3.1.1:

Now using Remote Desktop Plus instead of “LaunchRDP.exe” which fixes connecting to Windows Server 2012+/Windows 10+

Breaking change: Any custom command that you set up on the toolbar will be gone.

Breaking change: If you use a master password to encrypt connection passwords, you will loose all your stored passwords with this release. To prevent this, run your current version first and remove the master password, before updating to this version.

There is now a 32 and 64 bit version available (which need either the 32 or 64 bit Oracle client)

Reorganized the button and ribbon layout

Added a lot of new views (memory, storage,…)

There is now a context sensitive help (F1) on V$*, DBA_* views and database parameters that links into the Oracle Referece manual. The necessary files for Oracle 10-12 will be downloaded the first time you access the help feature. Bug: See first comment below, to get this feature to work.

Changed the SQL statement for the “Missing bind variables” view. It now finds similar SQL based on FORCE_MATCHING SIGNATURE and PLAN_HASH_VALUE and aggregates the result set for easier analysis

Mumbai can now connect to ASM instances and you can connect with the SYSASM privilege

You can now test the functionality of database links from the context menu of the database links view

Fixed flickering cursor when executing queries in the console window

Added ASM views including a tree-like file explorer

You can now create your own charts from any table data (right click on a table and select “General function>New custom chart…”):

Fixed refresh of AWR and SP data

RAC compatibility fixes for ASH viewer

The ASH viewer now correctly shows and updates data for the current minute

Added “Select/Deselect all visible” in the multiple connections selection dialog

Added “SP and AWR Physical Disk I/O” report

Added “Test connection” and “Test all connections” to connection dialog

When refreshing a view, you no longer loose your applied filters and sort order

Fixed: All connections now automatically get a name if no name is explicitly given (stopped ASH viewer from working)

Fixed an error when closing connections in console window and “Fetch DBMS_OUTPUT” was still active

Fixed: When executing a query on multiple connection and a query failed with ORA-… no connection back to the initially connected database happened

Fixed: When selecting “Fetch from multiple instances” in ASH setup at least one connection needs to be selected now.

Fixed: Access violation when dragging and dropping a page from the left to right side and vice versa

]]>https://marcusmonnig.wordpress.com/2015/04/01/mumbai-version-3-0-1-available/feed/5mamoennigaintegrated helpsysasm_loginasm_file_exporercustom_chart_setupcustom_chartMumbai 3.0 status updatehttps://marcusmonnig.wordpress.com/2015/01/23/mumbai-2-0-status-update/
https://marcusmonnig.wordpress.com/2015/01/23/mumbai-2-0-status-update/#respondFri, 23 Jan 2015 20:28:55 +0000http://marcusmonnig.wordpress.com/?p=631Continue reading →]]>Thanks a lot to everyone who donated for Mumbai version 3.0 until now! The total is at around 110130 140 US$ right now, but of course you can still change this.

I’ve started adding features and I’m making good progress. Here’s a sneak preview of what already is implemented for version 3.0:

You can now create your own charts from any table data (right click on a table and select “General function>New custom chart…”):

You can now test the functionality of database links from the context menu of the database links view

There is now a context sensitive help (F1) on V$*, DBA_* views and database parameters that links into the Oracle Reference Manual. The necessary files for Oracle 10 to 12 will be downloaded the first time you access the help feature:

Added a lot of new views (memory, storage, metrics, autotasks, ASM, system statistics…)

Added ASM views including a tree-like file explorer:

Mumbai can now connect to ASM instances and you can connect with the SYSASM privilege:

Changed the SQL statement for the “Missing bind variables” view. It now finds similar SQL based on FORCE_MATCHING SIGNATURE and PLAN_HASH_VALUE and aggregates the result set for easier analysis

If you use a master password to encrypt connection passwords, you will loose all your stored passwords with this release.

Fixed flickering cursor when executing queries in the console window

Fixed refresh of AWR and SP data

RAC compatibility fixes for ASH viewer

The ASH viewer now correctly shows and updates data for the current minute

Added “Select/Deselect all visible” in the multiple connections selection dialog

Added “SP and AWR Physical Disk I/O” report

Added “Test connection” and “Test all connections” to connection dialog

When refreshing a view, you now longer use your applied filters and sort order

Bug fixes: All connections now automatically get a name if no name is explicitly given (stopped ASH viewer from working)

Fixed an error when closing connections in console window and “Fetch DBMS_OUTPUT” was still active

Fixed: When executing a query on multiple connection and a query failed with ORA-… no connection back to the initially connected database happened

]]>https://marcusmonnig.wordpress.com/2015/01/23/mumbai-2-0-status-update/feed/0mamoennigcustom_chart_setupcustom_chartintegrated helpasm_file_exporersysasm_loginFund raising for Mumbai 3.0https://marcusmonnig.wordpress.com/2015/01/13/fund-raising-for-mumbai-2-0/
https://marcusmonnig.wordpress.com/2015/01/13/fund-raising-for-mumbai-2-0/#commentsTue, 13 Jan 2015 17:10:22 +0000http://marcusmonnig.wordpress.com/?p=604Continue reading →]]>Mumbai has always been free-to-use and I don’t want to change this ever. However, I’ve spent considerable amounts for development tools over the last years. To be able to implement some new features, I will need to invest a bit again, so I am asking now for donations to support the further development of Mumbai.

Number one on my shopping list is a source code version of the Direct Oracle Access components. They were kind enough to offer me a 25% discount, so I need around 240 Euros (around 280 USD) for this one! Besides other things, this will let me add support for connecting to ASM instances with Mumbai.

If more money comes in, I will spent it for a Developer Express VCL subscription which is around US$600 (510 Euros) US$540 (460 Euros) (Update 2015-01-14: The cool guys from DevExpress offered a 10% discount. Thanks!).
This component suite is the basis for lots of GUI elements in Mumbai, including data grids and most of the diagrams and an update to their current version will benefit Mumbai in the long term.

With both libraries available in their current version, I also hope to implement “server mode“, which would make working with large query result sets (think V$SQL, etc.) much slicker.

If you would like to donate something for the further development of Mumbai, please use the PayPal links below. I would greatly appreciate your support! Thank you!

Donate in Euros

Donate in USD

]]>https://marcusmonnig.wordpress.com/2015/01/13/fund-raising-for-mumbai-2-0/feed/6mamoennigNew version of Mumbai in the workshttps://marcusmonnig.wordpress.com/2015/01/03/new-version-of-mumbai-in-the-works/
https://marcusmonnig.wordpress.com/2015/01/03/new-version-of-mumbai-in-the-works/#commentsSat, 03 Jan 2015 13:11:07 +0000http://marcusmonnig.wordpress.com/?p=579Continue reading →]]>This is just a quick note that, after almost two years, I am again working on Mumbai and there should be a new version out within the next one or two months.

While Mumbai served me well on a daily basis over the last months and year at my job, my job has and will change a bit, so I am back at it. You can expect support for ASM, RAC and Linux and since I am tackling the “Oracle Database 11g Performance Tuning Certified Expert” certification, there will be quite a few performance related updates and additions. A 64-bit build will also be included.

If you have any pressing issues or feature requests for the upcoming version, please leave a comment (no promises…).

Update 2015/01/09: Passed.

]]>https://marcusmonnig.wordpress.com/2015/01/03/new-version-of-mumbai-in-the-works/feed/8mamoennigOCE_ODb11gPerfTun_clrBug fixes for BASH (ASH for the rest of us) in version 8https://marcusmonnig.wordpress.com/2013/08/15/bug-fixes-for-bash-ash-for-the-rest-of-us-in-version-8/
https://marcusmonnig.wordpress.com/2013/08/15/bug-fixes-for-bash-ash-for-the-rest-of-us-in-version-8/#respondThu, 15 Aug 2013 19:24:10 +0000http://marcusmonnig.wordpress.com/?p=575Continue reading →]]>Version 8 of BASH is available and fixes some bugs resulting in no data being flushed to BASH$HIST_ACTIVE_SESS_HISTORY. Again, thanks to Robert Ortel for reporting and tracking down the cause.

If you already have BASH installed, you can use the SQL*Plus update script update_v7tov8.sql.

Changes:

Fixed another UTC-conversion resulting in no entries in BASH$HIST_ACTIVE_SESS_HISTORY

Added missing trigger on BASH.BASH$SETTINGS

Renamed INST_ID to INSTANCE_NUMBER in views accessed through public synonyms

Fixed a bug causing no data flushed to BASH$HIST_ACTIVE_SESS_HISTORY

]]>https://marcusmonnig.wordpress.com/2013/08/15/bug-fixes-for-bash-ash-for-the-rest-of-us-in-version-8/feed/0mamoennigBASH version 7 fixes two bugshttps://marcusmonnig.wordpress.com/2013/07/13/bash-version-7-fixes-two-bugs/
https://marcusmonnig.wordpress.com/2013/07/13/bash-version-7-fixes-two-bugs/#respondSat, 13 Jul 2013 08:11:11 +0000http://marcusmonnig.wordpress.com/?p=569Continue reading →]]>Version 7 of BASH is available and fixes two bugs leading to inconsistent rows in BASH$HIST_ACTIVE_SESS_HISTORY. Thanks to Robert Ortel for reporting and tracking down the cause.

If you already have BASH installed, you can use the SQL*Plus update script update_v6tov7.sql.

Changes:

Fixed a UTC-conversion bug around midnight, resulting in too many entries in BASH$HIST_ACTIVE_SESS_HISTORY

Fixed a bug leading to duplicate rows in BASH$HIST_ACTIVE_SESS_HISTORY after 10 seconds with no active sessions sampled