Designing and setting up a new database system can take a lot of planning. But typically, one important decision is overlooked: choosing the right character set. A basic consideration for choosing a character set is to make sure it can handle any language that needs to be supported immediately and in the future. Oracle has documentation on the capabilities and performance implications of different character sets (Choosing a Character Set). Sometimes you have to change the database character set to support a new application.
Viewing entries in
2014
As downtime (planned and unplanned) trends lower and SLAs continue to increase, it is important to be able maximize online operations as much as possible. In this article, we will be looking at performing a storage upgrade or refresh online, which is possible if you are running on Oracle Automatic Storage Management (ASM).
In order to keep this simple, let’s assume that our database is running on one ASM disk group: DATA. That disk group is composed of one ASM disk: SPINNING. We’re going to create a new disk, FLASH, on our brand new, all-flash storage array. In the example below, you’ll see us migrate from SPINNING to FLASH with no downtime at all.
April 30, 2014 — VLSS LLC today announced that it has successfully completed the Infrastructure Virtualization and Virtualization of Business Critical Applications solution competencies. This achievement demonstrates that VLSS LLC is committed to becoming an expert in helping customers enhance their IT environments. Further, in achieving this competency, VLSS LLC acknowledges that this distinction and VMware solutions are key accelerators for enabling their growth in the virtualization and cloud markets.
The purpose of this blog is to show how different performance strategies can be implemented using the Oracle Database Resource Manager. Some practical examples are looked at to illustrate the point.
Resource Manager is designed to maximize throughput, so the resource plan directive given is no hard limit. In a CPU constrained system, we can allocate more CPU resources to OLTP users than to batch-jobs. With Resource Manager, the DBA can plan for a more proactive and predictable performance perspective – meeting service level agreements.
This article will be discussing regular expression capabilities that have been incorporated into SQL. Previously, the LIKE operator could only be used for simple pattern matching of a string; however, new operators, such as REGEXP_LIKE, can be used to do powerful regular expression pattern matching.