content top

Using EMCLI to Create Named Credentials

One of my blog readers asked me to write a sample EMCLI codes to create named credentials for Database. To be able to create a named credential, you need to know the target name (unless you create a global credential), target type and credential type associated with the target type. Let’s say I want to create a named credential for my database named “TESTDB”. First I need to login to our EM12c server, and list targets named “TESTDB”:

The % sign after the TESTDB means any target type (be careful about the colon (:) symbol between target name and target type). So we know that our TESTDB is an “oracle_database”. I’m sure you will memorize most of the target types after you start to work with EMCLI but I still prefer to check them before executing commands. Now we need to get the credential types (and their attributes) associated with “oracle_database”:

Read More

BBED Block Browser EDitor for Oracle 11g

BBED (Block Browser Editor) is a tool for Oracle internal use, and it helps you to read and manipulate data at the Oracle Database block level. No need to say that it’s very powerful and also extremely dangerous because you can corrupt data/header blocks. There’s an unofficial but very comprehensive manual for BBED. It’s written by Graham Thornton. You can download it as PDF:

Before Oracle 11g, BBED object code is shipped but you need to compile it to be able to run it. On 11g, the required files to compile BBED is not shipped. So you need to copy the following files from an Oracle 10g home to Oracle 11g home:

Read More

Oracle TKPROF Hidden/Undocumented Parameters

While I was examining with tkprof, I noticed that there are 2 undocumented parameters (Oracle 11gR2): verbose and diag. 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:

It also adds a summary part to the end of the output file:

Read 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 Postgresql Driver:


Then we open Oracle SQL Developer, open preferences, database section and third party JDBC driver.

Read 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 populated into the memory. Let’s create a test table and fill it with some data:

Now let’s access the data:

I checked again the V$IM_SEGMENTS:

Read More
Page 1 of 2912345...Last »
content top