Monthly Archives: agosto 2013

Oracle Cloud Social. Mobile. Complete.
  • 27
    Ago

Oracle Cloud Social. Mobile. Complete.

Oracle is the most comprehensive cloud provider on the planet...... Read the article http://www.oracle.com/us/corporate/features/complete-cloud/index.html

Read More
Pluggable database
  • 22
    Ago

Pluggable database

Pluggable database is the new database concept from Oracle 12c. Below we consider some basis case in order to understand some functionality about flexible and multitenant database. Create a new pluggable database in root container With pluggable database concept , it is possible to create an empty database in one container in just few minutes. SET SERVEROUTPUT ON...

Read More
Loading SQL Plans into SPM using AWR
  • 14
    Ago

Loading SQL Plans into SPM using AWR

Often you may need to load SQL Plans into SPM but isn’t possibile because query is out of cache. There is a simple procedure for loading SQL plans into SPM using AWR data. The first step, if not exists, is to create a SQL Tuning Set (STS). exec dbms_sqltune.create_sqlset(sqlset_name => '1ffbnq9wwkhtz_sqlset_test',                                 description => 'query test'); Name and...

Read More
Can I customize my client session when I use sqlplus ?
  • 8
    Ago

Can I customize my client session when I use sqlplus ?

Of course, you can do that using glogin.sql and login.sql. What's the differences between glogin.sql and login.sql? glogin.sql is used for any user, and login.sql is used for you only. In fact, login.sql is called after glogin.sql where you start a sqlplus session. glogin.sql is usually located in $ORACLE_HOME/sqlplus/admin, login.sql can be located where you launch sqlplus (or...

Read More