Oracle TKPROF Hidden/Undocumented Parameters

While I was examining with tkprof, I noticed that there are 3 undocumented parameters (Oracle 11gR2): verbose, diag and record. Specially “record” parameter seems very useful. Let’s take a look at them.

Verbose: If you set verbose=y, tkprof will provide some extra information on output files. It adds “SQL Text addres(s)” and “SQL Text Hash Value” lines for each query:

SQL ID: 3g7sxtj9d6zd3 Plan Hash: 742841275

select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))
from
 objauth$ where obj#=:1 and grantee#=:2 group  (more...)

Configuring Oracle SQL Developer for PostgreSQL

I see that some people wonder if Oracle SQL Developer can be used with PostgreSQL. I wrote a blog post to show how you can configure Oracle SQL Developer to connect Microsoft SQL Server and MySQL. You can use the same method to configure SQL Developer for PostgreSQL. First we need to download a compatible JDBC driver from PostgreSQL site. Latest version of SQL Developer uses JDK 1.7, so we can download the JDBC41 (more...)

When is a Table Populated into the In-Memory Column Store?

I was playing with in-memory feature of Oracle 12c, and wondered when a table is loaded/populated into in-memory buffer (of course I’m talking about a table which is enabled for in-memory). In “the Oracle Database In-Memory blog”, it says Oracle typically populates the table after it has been accessed for the first time. It’s possible to check V$IM_SEGMENTS to see the memory segments of in-memory tables, so we can easily see when the table is (more...)

Enterprise Manager 12c: Failed Jobs

After I added some database targets to my Enterprise Manager 12c, an incident opened for failed jobs on a newly added database. We have some jobs scheduled to run every 5 minutes on that database, and of course we have some error-handling and alerting mechanism which will notify us if any of them fails, so there shouldn’t be any failed job. I checked run logs of all the scheduler jobs to see if there are (more...)

New EMCLI Verbs in Enterprise Manager 12c R4 (12.1.0.4)

Today I see Ray Smith’s blog post about EM CLI Verb Changes. He provided a quick list of several new and deprecated EMCLI verbs in Enterprise Manager 12c R4. Pete Sharman commented on the blog post and said there are missing verbs. Ray said he made the list based on Oracle Documentation. So I decided to make another list based on EMCLI HELP output. Here’s the list of new EMCLI verbs:

Upgrading Enterprise Manager Cloud Control 12.1.0.3 to 12.1.0.4

Enterprise Manager Cloud Control 12.1.0.4 is released yesterday, and I have downloaded it immediately to upgrade our system. It was a very smooth process. The version of our Enterprise Manager was 12.1.0.3. Enterprise Manager 12.1.0.4 is compatible with 12.1.0.3 agents, so total downtime was about 30 minutes (of course it depends on your hardware). I upgraded our system using “one system upgrade” option (more...)

Enterprise Manager 12c: Be Careful About Naming DB Systems

Yesterday, we added a development database to our EM12c system. About 15 minutes later, the incident management flooded us with alert mails about newly added database. Unfortunately its SID was same with our production DB, and when adding the database, my colleague didn’t change its name and accepted the defaults. I was out of office when I got those mails, after a short panic, I called my colleague to check the situation and she said (more...)

Oracle Enterprise Manager Cloud Control 12c Plugin for PostgreSQL

In my company, we use PostgreSQL, Postgres Plus (a commercial fork of PostgreSQL provided by EnterpriseDB) beside Oracle databases. Unfortunately different databases need different tools to monitor, and implementing a standard monitoring procedure for all databases becomes a real problem. Good thing is Oracle Enterprise Manager is an extendable software supporting 3rd party plugins, and there are companies like Blue Medora which focuses on the product enhancements for Enterprise Manager. Blue Medora released a plugin (more...)

EMDIAG Repvfy Kit for Oracle Enterprise Manager Cloud Control 12c

EMDIAG Repvfy is a tool which is designed to collect data from a Cloud Control Management Repository to assist in the diagnosis and optimization of EM12c. It’s mentioned on “Oracle Enterprise Manager 12c Configuration Best Practices (Doc ID 1553342.1)”, and you can find the required information on Doc ID 1426973.1, to download, install and run EMDIAG Repvfy. Yesterday, I installed it for our EM12c system, and I got some errors while running it. (more...)

A Short Script to List Mappings of ASM Disks to Physical Devices

I got a warning mail from our Enterprise Manager Cloud Control, it says “Disk Device emcpowere1 is 98.468% busy.”. I logged into the server to see the busy disk. There were no related mount point points so it should be used by ASM, but because we use ASMLIB, I needed to query each ASM disk to see which physical device it’s mapped to.

If you have a few disks, it won’t take time (more...)