(Andrew Reid) This is an alternative to if… then… else… elsif… end if when you want to use conditional statements in PL/SQL. Here is a simple example, which checks whether a given number is 1 or 2. You start with the word case.

(David Fitzjarrell) An interesting problem recently submitted to Oracle Support involves a possibly little-known aspect of a table called the Hakan Factor. The problem description, in brief, states that the Hakan Factor isn’t preserved for a partitioned table when a single partition is compressed.

(Hemant K Chitale) An SQL Trace captures SQL statements (including recursive SQL calls — e.g. data dictionary lookups or triggers being executed, which are not “directly” visible to the client or explicitly executed by the client). Optionally, it can capture Wait Events and Binds.

(Andrew Reid) This is an alternative to if… then… else… elsif… end if when you want to use conditional statements in PL/SQL. Here is a simple example, which checks whether a given number is 1 or 2. You start with the word case.

(David Fitzjarrell) An interesting problem recently submitted to Oracle Support involves a possibly little-known aspect of a table called the Hakan Factor. The problem description, in brief, states that the Hakan Factor isn’t preserved for a partitioned table when a single partition is compressed.

(Hemant K Chitale) An SQL Trace captures SQL statements (including recursive SQL calls — e.g. data dictionary lookups or triggers being executed, which are not “directly” visible to the client or explicitly executed by the client). Optionally, it can capture Wait Events and Binds.

(Owen Allen) There was a recent question thread about how you can tweak the OS analytics settings in Ops Center.

(Martien van den Akker) In my former post I explained how to do a REST request to a Mobile Cloud Service API using an Unauthorized access. To do so you need to add an HTTP Header property using a Base64 encoded key.

(Bobby Durrett) We keep 6 weeks of history in the AWR on our databases, but I want to capture some information for long-term trending. What I really want to do is capture some metrics and put them in some database tables to use to generate reports, but I have not had time to build the scripts to do

(Owen Allen) There was a recent question thread about how you can tweak the OS analytics settings in Ops Center.