Feed aggregator

Upcoming Webinar, “WebCenter Search that Works!” highlights Oracle WebCenter integration with Mindbreeze InSpire

Earlier this month, Fishbowl announced the release of our Oracle WebCenter Content Connector for Mindbreeze InSpire. The Connector enables the Mindbreeze enterprise search appliance to securely index and serve content stored in WebCenter Content. The Connector also allows customers to leverage the Mindbreeze Search App Designer to embed modern search apps directly in WebCenter Content.

As the quantity of unstructured information continues to expand, content management success depends on the ability to find data in a growing information flood. Without search that works, managed content becomes lost content. By integrating Oracle WebCenter with Mindbreeze InSpire you can improve information discovery, increase user adoption, and encourage content reuse through better search.

In our upcoming webinar, we will provide an overview of the Mindbreeze InSpire enterprise search appliance and our integrations with both WebCenter Content and Portal. We’ll cover what a typical implementation looks like and why customers are making the switch. We’ll also discuss the migration path off deprecated Oracle Secure Enterprise Search and Google Search Appliance technologies, and options for adding other sources like SharePoint and network shares.

We hope you’ll join us.

The post Upcoming Webinar, “WebCenter Search that Works!” highlights Oracle WebCenter integration with Mindbreeze InSpire appeared first on Fishbowl Solutions.

Categories: Fusion Middleware, Other

Imanis Data

DBMS2 - 9 hours 55 min ago

I talked recently with the folks at Imanis Data. For starters:

  • The point of Imanis is to make copies of your databases, for purposes such as backup/restore, test/analysis, or compliance-driven archiving. (That’s in declining order of current customer activity.) Another use is migration via restoring to a different cluster than the one that created the data in the first place.
  • The data can come from NoSQL database managers, from Hadoop, or from Vertica. (Again, that’s in declining order.)
  • As you might imagine, Imanis makes incremental backups; the only full backup is the first one you do for that database.
  • “Imanis” is a new name; the previous name was “Talena”.


  • Imanis has ~35 subscription customers, a significant majority of which are in the Fortune 1000.
  • Customer industries, in roughly declining order, include:
    • Financial services other than insurance.
    • Insurance.
    • Retail.
    • “Technology”.
  • ~40% of Imanis customers are in the public cloud.
  • Imanis is focused on the North American market at this time.
  • Imanis has ~45 employees.
  • The Imanis product just hit Version 3.

Imanis correctly observes that there are multiple reasons you might want to recover from backup, including:

  • General disaster/system failure.
  • Bug in an application that writes data.
  • Malicious acts, including encryption-by-ransomware.

Imanis uses the phrase “point-in-time backup” to emphasize its flexibility in letting you choose your favorite time-version of your rolling backup.

Imanis also correctly draws the inference that the right backup strategy is some version of:

  • Make backups very frequently. This boils down to “Do a great job of making incremental backups (and restoring from them when necessary). This is where Imanis has spent the bulk of its technical effort to date.
  • In case recovery is needed, identify that last clean (or provably/confidently clean) version of the database and restore from that. The identification part boils down to letting the backup databases be queried directly. That’s largely a roadmap item.
    • Imanis has recently added the capability to build its own functionality querying the backup database.
    • JDBC/whatever general access is still in the future.

Note: When Imanis backups offer direct query access, the possibility will of course exist to use the backup data for general query processing. But while that kind of capability sounds great in theory, I’m not aware of it being a big deal (on technology stacks that already offer it) in practice.

The most technically notable other use cases Imanis mentioned are probably:

  • Data science dataset generation. Imanis lets you generate a partial copy of the database for analytic or test purposes.
    • You can project, select or sample your data, which suggests use of the current query capabilities.
    • There’s an API to let you mask Personally Identifiable Information by writing your own data transformations.
  • Archiving/tiering/ILM (Information Lifecycle Management). Imanis lets you divide data according to its hotness.

Imanis views its competition as:

  • Native utilities of the data stores.
  • Hand-coded scripts.
  • Datos.io, principally in the Cassandra market (so far).

Beyond those, the obvious comparison to Imanis is Delphix. I haven’t spoken with Delphix for a few years, but I believe that key differences between Delphix and Imanis start:

  • Delphix is focused on widely-installed RDBMS such as Oracle.
  • Delphix actually tries to have different production logical copies of your database run off of the same physical copy. Imanis, in contrast, offers technology to help you copy your databases quickly and effectively, but the copies you actually use will indeed be separate from each other.

Imanis software runs on its own cluster, based on hacked Hadoop. A lot of the hacking seems to related to a metadata store, which supports things like:

  • Understanding which (incrementally backed up) blocks need to be pulled together to make a specific copy of the database.
  • Putting data in different places for ILM/tiering.

Another piece of Imanis tech is machine-learning-based anomaly detection.

  • As incrementally backed-up blocks arrive, Imanis flags anomalous ones and states a reason for them.
  • A flag is given a reason.
  • You can denounce the flag as a false alert, and hopefully similar flags won’t be raised in the future.

The technology for this seems rather basic:

  • Random forests for the flagging.
  • No drilldown w/in the Imanis system for follow-up.

But in general concept this is something a lot more systems should be doing.

Most of the rest of Imanis’ tech story is straightforward — support various alternatives for computing platforms, offer the usual security choices, etc. One exception that was new to me was the use of erasure codes, which seem to be a generalization of the concept of parity bits. Allegedly, when used in a storage context these have the near-magical property of offering 4X replication safety with only a 1.5X expansion of data volume. I won’t claim to have understood the subject well enough to see how that could make sense, or what tradeoffs it would entail.

Categories: Other

An Important Change Is Coming for Application Express 5.2 (if you use the Mobile User Interface)

Joel Kallman - 10 hours 17 min ago
An important change is coming in Oracle Application Express 5.2.  The mobile user interface (based upon jQuery Mobile) will be deprecated.  The deprecation announcement will be included with the forthcoming Application Express 5.1.3 patch set release.

What this means for you
  • If you have applications developed with the mobile user interface based upon jQuery Mobile, they will continue to function in a supported fashion in Application Express 5.1.x.  Premier Support of Oracle Application Express 5.1.x continues until December 2021.
  • New mobile applications should be created using the Desktop User Interface and Universal Theme (Theme 42) and not the Mobile User Interface & jQuery Mobile-based theme (Theme 51).
  • Existing mobile applications should be migrated to the Universal Theme if you want to run them on Oracle Application Express 5.2 and later.

Why is this happening?The last stable version of the jQuery Mobile library was released on October 31, 2014, and it only provides support for jQuery versions 1.8 through 1.11, and jQuery 2.1.  Patches are no longer provided for these versions of jQuery.  Application Express 5.2 will ship with jQuery 3.2 (necessary for us to adopt the latest Oracle JET libraries).  jQuery Mobile will not function properly with jQuery 3.2.

While we will make every effort to devise a way to include the necessary libraries for jQuery-mobile based applications in Application Express 5.2, that may not solve all problems entirely, especially when we try to include the data visualizations via Oracle JET, which have different dependencies.  We do truly strive to ensure backward compatibility of APEX applications across upgrades.  It's of paramount importance to us, and we spend a lot of time and energy ensuring that stability, operation, look and feel remain constant across APEX version upgrades.  But in this specific case, there doesn't appear to be a practical solution.  We're in a box.

There has been some recent activity in a new version of jQuery Mobile, namely 1.5alpha.  But given the fact that there was a very long hiatus on jQuery Mobile for an extended period of time, and it's unlikely that jQuery Mobile 1.5 will be stable enough by the time Application Express 5.2 is released, we collectively decided to announce depreciation of the Mobile User Interface based upon jQuery Mobile.  We literally spent months researching and contemplating this dilemma.  It's unfortunate.  The positive angle, though, is that we're in complete control of the Universal Theme and should not encounter similar issues with Universal Theme-based applications in the future.

DATE output format

Tom Kyte - 17 hours 15 min ago
Hi, In database_properties table date format is in 'DD-MON-RR', but in table it showing different format in date columns. Connected to: Oracle Database 12c Enterprise Edition Release - 64bit Production With the Partitioning, OLAP, Ad...
Categories: DBA Blogs

Database Upgrade / APEX versions

Tom Kyte - 17 hours 15 min ago
Hi Team, We're planning to upgrade our database from to (non-pluggable configuration). The current version of APEX installed in our environment is 5.1 My question is - during the upgrade process, is the installer smart enou...
Categories: DBA Blogs

Inserts into materialized view tables are parsed each time.

Tom Kyte - 17 hours 15 min ago
Hi We have a PL/SQL application which is inserting into database tables. These tables have materialized view logs. Noticed when looking into v$sql, that number of executions of these insert statements is much greater then number of parsing ope...
Categories: DBA Blogs

Search for top 10 queries generating huge redo

Tom Kyte - 17 hours 15 min ago
Dear Experts, Please can you help in knowing how to find for top 10 queries/sessions generating huge redo. I tried with the below queries to check redo generated per day, but not able to find top 10 such sessions which generates so. select t...
Categories: DBA Blogs

use clause optionally enclosed by '"' in sql loader

Tom Kyte - 17 hours 15 min ago
I have strange behavior using optionally enclosed by '"' in my .ctl file. it doesn't works as expected and I do understand why. Could you please help me? here the .ctl file: <code>OPTIONS (PARALLEL=TRUE,DIRECT=TRUE,ROWS= '150000',BINDSIZE= '4500...
Categories: DBA Blogs

Unable to extend Tablespace - ORA-01683

Tom Kyte - 17 hours 15 min ago
Hi Oracle Masters, We run End of Day (EOD) for our bank, and once in a while the EOD process aborts with the following error: ORA-01683: unable to extend index XXXXXX.PK01_TABLE_NAME partition P_1132 by 1024 in tablespace TBLSPCNAME. This kind...
Categories: DBA Blogs

BTree Index or Bitmap Index on Financial Transactions Table

Tom Kyte - 17 hours 15 min ago
Hi Tom, I need some advices on correct bitmap selection. We have a table with 200,000,000 Records of some payment cards transactions. Each transaction has a unique CardSerialNumber and a TransactionCounter which is generated by the card itself,...
Categories: DBA Blogs

Data dictionary impact of creating and deleting tables

Tom Kyte - 17 hours 15 min ago
Hi Tom! Could creating and deleting tables in warehouse many times (20000 per day during 1-2 years) damage data dictionary and dramatically decrease performance? If yes how we can restore it? Thank you
Categories: DBA Blogs

Use materialized views instead of PL/SQL

Tom Kyte - 17 hours 15 min ago
Hi Masters, I have a question relating to materialized views. We have 3 tables: INVOICE_MAIN, INVOICE_BALANCE and INVOICE_LINE and one view INVOICE joining INVOICE_MAIN and INVOICE_BALANCE. In the table INVOICE_LINE there are the columns INVOICE_...
Categories: DBA Blogs

Oracle Instant Client 12.2 now has SQL*Loader and Data Pump

Christopher Jones - Mon, 2017-08-21 19:17

Oracle Database 12c iconThis is a guest post by Jim Stenoish, Senior Director of Software Development, whose products include all tools used for the high speed movement, transformation, and loading of data and metadata for Oracle Database.

Oracle Instant Client 12.2 now includes SQL*Loader as well as the Data Pump command line utilities expdp and impdp, and the traditional Export/Import utilities exp and imp. Previously, these tools were only available with a 'full' client installation, or in a database installation. Being in Instant Client allows users to access these tools with a smaller footprint on disk and with a much quicker install than for a full client. The OTN license is also more convenient for many users.

Now these tools are part of Instant Client, it's easy to load data from a file on a system the doesn't already have Oracle software installed.

Installing the Tools

You can install the tools by unzipping the Oracle Instant Client 'Basic' (or 'Basic Light') package and the 'Tools' package to the same location. See the Instant Client home page for links to download for each platform.

Follow the platform-specific instructions given on the download page. For example, on Linux set LD_LIBRARY_PATH and PATH to the Instant Client directory. On Windows set PATH to the Instant Client directory and also install the Microsoft Visual Studio 2013 Redistributable.

Using the Tools

SQL*Loader allows you to load data from files, such as comma-separated value files (CSV), into the tables.

The expdp and impdp utility allows you to move metadata and data between Oracle databases. The expdp utility unload metadata and data from the database into Data Pump files on the database server. The impdp utility recreates metadata defined in a Data Pump file and loads table data stored in the files on the database server. It also provides a way to extract metadata and data over a DB Link (no files involved) from one database to another database.

Documentation and examples for the tools are in the Database Utilities manual.

If you have questions about SQL*Load or Data Pump you can ask them on OTN.

Free Webinar by Craig Shallahamer on Oracle Performance

Gerger Consulting - Mon, 2017-08-21 14:28
Attend the free webinar presented by the Oracle ACE Director Craig Shallahamer and learn how to choose the best strategy when analyzing a Oracle Database performance problem.

About The Webinar. 
The Oracle Database provides amazing application performance opportunities. But sometimes there are still unhappy users. So, what is your best analysis strategy? As Oracle DBAs we have two fundamental strategies: time based and active session sample based (ASH). Knowing their differences and how to exploit them gives you the optimization edge. In this webinar, I introduce each strategy, highlight how they work, contrast their differences and demonstrate live each strategy. This webinar will teach you how to begin your analysis in the best direction.
Takeaways and value:
  • You will know the differences and advantages between an ASH and AWR (time-based) analysis strategy.
  • You will know which analysis is best in any given situation.
  • You will learn how to use an AWR report to analyze performance and derive multiple solutions.

Categories: Development

Oracle Code Returns to San Francisco - Oct 3, 2017

OTN TechBlog - Mon, 2017-08-21 11:43

Register now for Oracle Code San FranciscoThe Oracle Code event series began its journey around the globe in San Francisco on March, 1, 2017. On October 3, 2017 -- 7 months and 300,000 coders later -- Oracle Code returns to San Francisco to complete its circumnavigation.

This 21st event in the series will include the kind of developer-led keynotes, sessions, and labs that have made the series so successful. 

Even better, this very special event takes place at Moscone West during Oracle OpenWorld and JavaOne. But you can keep your credit card in your pocket. Registration for Oracle Code 21 is free, and does not require registration for OOW or JavaOne! 

Of course, those attending OOW or JavaOne are encouraged to attend Oracle Code.

Click here for registration information and a complete list of Oracle Code keynotes, sessions, and labs.

Register now for Oracle Code San Francisco

Get a Taste

Content from Previous Oracle Code Events

Video: JavaScript Toolkit for Enterprise Applications | Andreas Koop

OTN TechBlog - Mon, 2017-08-21 11:14

Modern web application development with JavaScript has become popular – even for enterprise applications. But when starting a new project developers can feel overwhelmed by the number of newly available JavaScript libraries and build tools from which to choose. In this technical session from the Oracle Code Online Full Stack Web Development track, Andreas Koop shows you how to build JavaScript applications with ease, using Oracle JET. He'll cover typical enterprise requirements like stable build tool chain, ready-to-use components, accessibility, built-in i18n, responsive features, and performance optimizations.

Also from the Oracle Code Online Full Stack Development Track Additional Resources


Change partition column

Tom Kyte - Mon, 2017-08-21 06:06
Hi, We have a existing table. And this table is partitioned by range interval. Now i would like to change the column its referring to. Can i do that? Eg: <code>CREATE TABLE partition_test ( PROD_ID NUMBER NOT NULL, DATE_SK ...
Categories: DBA Blogs

Adding a column with a default value to a table

Tom Kyte - Mon, 2017-08-21 06:06
Tom, I have a doubt about adding columns with default values to a table. Recently, I have stumble upon an Arup Nanda article on it where he states the following "When a user selects the column for an existing record, Oracle gets the fact about the...
Categories: DBA Blogs

Incorrect time in Database

Tom Kyte - Mon, 2017-08-21 06:06
We have 5 oracle 12C databases running on 2 nodes. on One of the Database on both nodes sysdate returns as below select sysdate from dual; SYSDATE -------------------- 18-AUG-2017 * on all other 4 database when sysdate was...
Categories: DBA Blogs

Data warehouse performance

Tom Kyte - Mon, 2017-08-21 06:06
Hi Tom! We have problem with database (warehouse) performance. Our DBA said that the main reason is some kind of company software create and delete about 20000 tables per day and it?s impacts on data dictionary. Can it be truth? And what we can do...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator