view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Oracle OpenWorld 2014 – New Data Formats and Integration

Especially on this Monday it seems all about new database data intern ration technologies and support for more data formats. Now adding in 12.1.0.2 native...
class="readmore"> class="more-btn" href="http://www.liberidu.com/blog/2014/09/30/oracle-openworld-2014-new-data-formats-and-integration/">Read More

OCP 12C – Basics of Multitenant Container Database (CDB)

The multitenant architecture Needs enterprise edition and the multitenant option. Consists of a CDB (Container database) and zero, one or up to 252 PDBs (pluggable databases). Has a root container (the CDB itself) and a seed container (template to create PDBs) There is only one instance per CDB. A PDB doesn’t have : background processes [...]

OOW14 Session: Cache Fusion Demystified

Thank you all those who attended my session Cache Fusion Demystified.

As I mentioned, it was impossible to fit in a demo within that compressed 45 minute timeline. I put the details of the demo in a separate file with all the scripts and instructions that allows you to execute the demos at your own site.Download the slide deck as well as the scripts. In addition I have also written a whitepaper to explain the concepts clearer.

OPTIMIZER_MODE = FIRST_ROWS_N

I have known about the first_rows optimizer mode for some time. This tells Oracle to use an execution path which will return the first few rows as quickly as possible. However, I recently read about the first_rows_n optimizer mode, which apparently appeared first in Oracle 9. This tells Oracle to use an execution path which will return the first n rows quickly, where n can be 1, 10, 100 or 1000. I decided to try it out in an Oracle 11.2 database.

OCP 12C – Enterprise Manager and Other Tools

EM Database Express The old Enterprise Manager database control is replaced by Enterprise Manager database express in Oracle 12c. It contains only basic administration capabilities as the advanced ones are included in Enterprise Manager cloud control With EM database Express you can manage Security (Users, roles, profiles), Configuration (Instance Parameters, memory, database features), Storage (tablespaces, [...]

SQLSaturday Pittsburgh Script [VIDEO]

Transcript

Database administrators are responsible for keeping data safe and available, and continuing their education is vital for them to stay current on the best practices and features of the database platforms they support.

Hi, welcome back to RDX. One way SQL Server DBAs can learn new skills is by registering for a SQLSaturday, an all-day SQL Server training event, near them.

12c Fixed Subquery

It’s been about 8 months since I posted a little note about a “notable change in behaviour” of the optimizer when dealing with subqueries in the where clause that could be used to return a constant, e.g.:

Time for an Oracle Apex feature request - single sign-on authentication

I've just submitted a feature request because I believe that the current Application Group concept is a fairly weak one if it doesn't bring about some advantage in terms of features for the developer.

Basically what I am asking for is that one can easily implement a single sign-on authentication method across multiple applications within the same application group, pretty much like the existing

What to Expect at Oracle OpenWorld this Year [VIDEO]

Transcript

Oracle OpenWorld 2014 is just around the corner, but what can IT professionals gain from attending?

Hi – welcome back to RDX. From September 28 to October 2, representatives from across the globe will travel to the Moscone Center in San Francisco to learn more about Oracle products and current IT trends.

Documentum upgrade project: D2-Client and missing icons

The new D2-Client does not correctly display the icon for some formats. This usually happens when the icon.css is not up to date based on the content format in the repository. The solution is to find these formats and update the icon.css.
Here is the solution in three simple steps:
 
1) Find all formats described in icon.css
 
grep -B1 formats icon.css | cut -f1 -d"{" | grep SPAN | cut -f2 -d. > format.txt
 

view counter