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...)

TROUG DBA/Developer SIG 2014

This is a late post (sorry for all Turkish Oracle Users waiting for the presentations) about TROUG DBA/Developer SIG 2014. We successfully organized a hybrid SIG meeting on February 13th, but I could find time to write a blog post about it till today. My company (Innova) hosted the meeting, I would like to thank my manager for his support. There were 5 presentations, and all of them were in Turkish. I made a presentation (more...)

Finding And Deleting Old Files (on Unix and Windows)

I needed to write short scripts to delete old files on a Windows Server. It’s a very easy task on UNIX flavors but the limited capacity of Windows command line made me worried. You can use a simple “find” command to find old files on UNIX. For example, the following command will be enough to find and delete files older than 7 days:

find /folder/ -type f -mtime +7 -exec rm {} +

For the (more...)