Some novice can ask themselves “can a role really be useful to me?” and often this object be ignored, but it is very useful. Surfing on web can be depressing, between system roles explanations and code constructs. Now we try to discover it in a easy way. Some words to describe Oracle Roles. Oracle…
Leggi tutto
Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialization parameter), space will be allocated in a temporary tablespace for doing the sort operation. Other SQL operations that might…
Leggi tutto
Oracle is the most comprehensive cloud provider on the planet…… Read the article http://www.oracle.com/us/corporate/features/complete-cloud/index.html
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.…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
In order to solve the above error the solutions are (considering database 10g and above.) 1.) Increase the free space where archiver archives the archivelog. The location where archiver archives the log is determined by parameter file pfile or spfile. This can be determined by loging into sqlplus and issuing SQL> show parameter log_archive_dest If…
Leggi tutto
Microsoft makes provisions of the tools to perform operations at the command line. The most famous are Robocopy.exe (copy / sync files and folders), Calcs.exe (management of permissions on files and folders), Dnscmd.exe (add / remove DNS records), etc. .. Unlike previous versions, if you need to use these tools on Windows Server 2008 R2…
Leggi tutto
Starting of 2005 version, was introduced the concept of table partitioning (as in Oracle.) At the time of choosing the type of partitioning, you have to be careful about the choice: LEFT or RIGHT. From my experience I would recommend to use the partitioning Left, or with values less than the value of partitioning. This…
Leggi tutto
The Server Control (SRVCTL) utility allows you to start and stop database and instances, manage configuration information, move or remove instances and services. Allows you to reallocate a service from one named instance to another named instance; the relocated service is temporary until you modify the configuration. An example: Problem: We need to redistribute…
Leggi tutto
Commenti recenti