この1年間で24万人のエンジニアが利用!OTNの技術記事を活用しよう

皆さんの会社の新年度はいつですか?オラクルでは5月が年度末でビジネス・イヤーが終わります。今週あたり「今年度もがんばったよねー。来年度もまた心機一転がんばりましょう~!」と1年の一区切りにほっと一息ついてお疲れ様会を催している社員も多いようです。



さて、OTNではオラクル社員の執筆による、主にデータベース関連のオリジナル技術記事を提供しておりますが、この1年間の利用者数をカウントしてみたところ、なんと237,468人(ユニークユーザー数)の方に閲覧されていました。   

派手に宣伝することもなく、サイト内の置き場所もわかりにくい(?)地味なこのコーナーにもかかわらず、こんなに多くの方がここに辿りついて利用してくださっていると思うと、大変ありがたく、また気持ちがひきしまる思いがします。

[今年度良く利用された記事TOP 5] 2014年6月~2015年5月

1位 津島博士のパフォーマンス講座

2位 しばちょう先生の試して納得! DBAへの道

3位 シバタツ流! DWHチューニングの極意 
   (こちらのページの中に目次があります)

4位 ユージ&ギョータの実践データベース講座 Oracle Database 12cを使ってみよう

5位 "PL/SQL 101" ~ PL/SQLの基礎を学ぶ ~


DBのプロフェッショナルの方が最も活用しているのが津島博士としばちょう先生シリーズ。津島博士シリーズは今回で46回目、しばちょう先生は39回目を迎える、スーパー・ロングセラー連載で多くのファンが毎号楽しみにされています。他のエンジニアさんがどんな記事を読んでいるか気になりますよね。そこで津島博士としばちょう先生のこの1年のトップ5を調べてみましたのでご参考下さい。

■津島博士のパフォーマンス講座
 (全Indexはこちら

1.第9回 良いSQLについて
2.第14回 メモリ・チューニングについて
3.第11回 良いSQLについて(2)
4. 第19回 UNDOデータとREDOログについて
5. 第3回 Statspackから探る、パフォーマンス問題の原因特定方法


■しばちょう先生の試して納得!DBAへの道
 (全Indexはこちら

1.第5回 SQLの実行計画からパフォーマンスの違いを読み解く
2.第1回 表領域の作成と拡張
3.第2回 表と表領域の関係
4.第28回 UNDO表領域の管理~保存期間の自動チューニング~
5.第17回 表領域の縮小とセグメントの格納位置


「お客さんに喜ばれたよ」「この記事があって助かった!」など社内のエンジニアからも好評の声が挙がっているイチオシ記事を挙げてみました。

”Oracle Database 11gから12cへのアップグレードを無事やり遂げたい”

 →辻先輩と大橋君の「Oracle Database 進撃のアップグレード」談義

”Oracle Databaseのシステムパフォーマンステストを効率的に行いたい”

 →シンジ&アヤノの実践データベース性能テストの極意: Oracle Real Application Testingを使ってみよう

”津島博士を読みこなす前に、まず「パフォチュー」の基本から理解したい”

 →パフォーマンス・チューニング入門


今までOTNの技術記事を読んだことがない方もこの機会に活用してみませんか? 部下の方や後輩エンジニアさんにも是非オススメしてください。

>>目次を見る

なお、「こんな記事を書いて欲しい」、「こんなテーマを取り上げて欲しい」といったご要望がありましたら、是非お寄せ下さい。OTN問合せフォームからお願いします。

Introduction to Oracle Database 12c

With the launch of DB 12c in 2013, Oracle introduced a new architectural concept, called “multitenant databases”, where you have one super database (=container; CDB) and one or more sub databases (= pluggable DBs; PDB).

Before running the installer on an Oracle Linux 6 environment, a library can be installed through yum to meet all the system per-requisites:

yum install oracle-rdbms-server-12cR1-preinstall

The software installer and DBCA are similar to 11g, except for this screen where (more...)

Publish a REST service from PL/SQL to handle HTTP POST requests – using the embedded PL/SQL gateway

Oracle Database can act as an HTTP server – using the Embedded PL/SQL Gateway (the 10g successor of the MOD_PLSQL gateway). With just a few statements, we can have the Oracle Database become a listener to HTTP requests (GET or POST). When requests are received at the configured host, port and URL, the request is passed to a PL/SQL procedure that handles it and prepares a response.

In this article, we will expose a REST (more...)

Invoke a REST service from PL/SQL – make an HTTP POST request using UTL_HTTP in Oracle Database 11g XE

This article is small and simple. It discusses how from PL/SQL an HTTP POST request can be made to a REST service. This particular service is exposed at http://localhost:9002/cinema and it expects a POST call.

Making HTTP requests from PL/SQL is fairly simple, using the supplied package UTL_HTTP. Starting in Oracle Database 11g, some security constraints are in force around network interactions. This means that before from a specific database account a PL/SQL unit can (more...)

Keeping track of your licenses with OEM12C – reports

Wouldn’t be nice to get regularly informed how (in)compliant you are with Oracle licenses in an easy – centralized – way, and therefore not have to worry about visits of Oracle’s LMS – License Management Services? I think that would be nice for the most of us. Running LMS-scripts on the target databases, hosts and middleware is for now the most thorough way to get informed about possible incompliancy. Or in some cased,  using some (more...)

The Great Hypervisor Bake-off: VMware ESX vs Oracle VM

lock-horns

This is a very simple post to show the results of some recent testing that Tom and I ran using Oracle SLOB on Violin to determine the impact of using virtualization. But before we get to that, I am duty bound to write a paragraph of text featuring lots of long sentences peppered with industry buzz words. Forgive me, it’s just the way I’m wired.

It is increasingly common these days to find database environments running (more...)

Re-Adding a Database to the AWR Warehouse Without Losing Historical Snapshots

There may be a reason that one needs to re-add a database to the AWR Warehouse.  This is a new opportunity for me to learn and offer assistance, but I’m working off the grid to figure out a solution.  Luckily, it’s just a matter of creating a new process from pre-existing code and processes.

The process requires both the AWR Warehouse UI and a SQLPlus connection.

1.  Disable the snapshots

2.  Extract the AWR for (more...)

ASM Rebalance Too Slow? 3 Tips To Improve Rebalance Times

see-saw

I’ve run into a few customers recently who have had problems with their ASM rebalance operations running too slowly. Surprisingly, there were some simple concepts being overlooked – and once these were understood, the rebalance times were dramatically improved. For that reason, I’m documenting the solutions here… I hope that somebody, somewhere benefits…

1. Don’t Overbalance

Every time you run an ALTER DISKGROUP <NAME> REBALANCE operation you initiate a large amount of I/O workload as (more...)

DBAKevlar at Collaborate 2015

Here’s a quick guide to my schedule of sessions at IOUG Collaborate 2015 for this year.  I’m looking forward to seeing everyone next week, (I’ll be arriving on Saturday, so I really should say in a couple days) and have no doubt we’re up for another phenomenal conference at Las Vegas, this year at the Mandalay!

Additionally, there are some great opportunities in professional development at the IOUG Strategic Leadership Program.  I’ll be speaking with James (more...)

IOUG Collaborate 2015 – #C15LV

Like many other Oracle professionals and speakers I will be attending IOUG Collaborate 2015 this year in Las Vegas.  I’m not a big fan of Las Vegas, but hey cannot turn down an opportunity to speak, especially when IOUG asked me to do more than one session.  

This year my schedule is going to keep me busy; yet full of good topics that cover both EM12c and GoldenGate.  If you are going to be (more...)

Paris Oracle Meetup (Jeudi 26 Mars 2015 @ 7pm)

A quick post to say that this week, on Thursday 26th, I will be giving a talk (in English!) on the subject of Flash for DBAs (and architects, designers, developers, managers etc) at the Paris Oracle Meetup:

global_197134042Flash for DBAs: A new technology is sweeping the world of storage. Flash, a type of non-volatile memory, is gradually replacing hard disk drives. It began in consumer electronic devices such as phones, cameras and tablets (more...)

TNSNAMES.ORA Learning

If I have an alias entry named “TEST1″ in tnsnames.ora twice with different descriptions, which one will Oracle*Net use when connecting to database? What if the duplicate alias entry is in the IFILE referenced from tnsnames.ora – which entry will be used? In my tests, Oracle*Net reads the tnsnames.ora file from bottom up. So if there […]

Annonce : Oracle Database In-Memory Advisor

Oracle Database In-Memory Advisor est maintenant disponible.
Pour utiliser cet assistant, le "Database Tuning Pack" est nécessaire.

Plus d'information :
  • Page OTN
  • Note MOS 1965342.1

Complément : Tutoriels sur Oracle Public Cloud

Complément : Vidéos Oracle Public Cloud

Test MySQL on AWS quickly

Using sysbench to performance test AWS RDS MySQL hardware is an easy three step  operation. 

Sysbench creates synthetic tests and they are done on a 1 mil row 'sbtest' table that sysbench creates in the MySQL database you indicate. The test doesn't intrude with your database schema, and it doesn't use your data, so it is quite safe. The test is an OLTP test trying to simulate event operations in the database as it (more...)

Oracle Exadata X5: The Road To Ten Billion Dollars

money

Now that the dust has settled on the announcement of Oracle’s new Exadata X5 Database Machine, I’ve been doing some research in order to update my History of Exadata post (it’ll be ready soon). While reviewing the datasheets and other collateral for the X5 I was struck by the meteoric increase in one particular statistic: the number of processor cores on each database server. Oracle is riding that Moore’s Law train all the way to the bank.

(more...)

Deprecation of Non-CDB Architecture in Oracle 12c

dead-end

Back in July 2013, Oracle released the latest version of its flagship database product, Oracle 12c. Among the usual fanfare was information about a number of new options – including one known as Multitenant. With the Multitenant option, databases use a new architecture which features a container database (or CDB) which in turn contains one or more pluggable databases (or PDBs). Use of Multitenant requires a licence – which at the time of writing retails at $17,500 (more...)

Pre-Built Oracle Database 12.1.0.2 on VirtualBox

Step by step screenshots showing the installation of Virtual box and configuring pre-built Oracle Database 12.1.0.2 (including in-memory option). A quick way to get started on Oracle Database 12c. This is a very easy setup, though many do not know how easy it is to get started and playing with Oracle Database 12c on Linux […]

Complément : Analyse de performances via AWR Warehouse