Oracle Live SQL Tool

Oracle Extended Statistics

Introduced 11gR1 and based on virtual columns. Allows better selectivity.Condition has the be equality or IN-lists.We should use them when we have issues by an order of magnitude on the cardinality.Types: Column Group: Have to be from same table. Max 32 Expression: CBO does not know how an applied function impacts the cardinality of a ...

Oracle In-Memory Advisor

Oracle In-Memory Advisor availableFirst released in feb. 2015. Improved version released in July 2015: an updated version of the Database In-Memory Advisor is now available, more information My Oracle Support (MOS) note 1965343.1

SQL Developer Language Settings

Change Oracle SQL Developer language Occasionally, I have to work on Customer environments where the language is set to something non-ENGLISH. Here is how to quickly change that unwanted setting on SQL Developer setting: close SQL Developer edit the file sqldeveloper.conf found at location sqldeveloperbin by adding the option AddVMOption -Duser.language=en restart SQL Developer and ...

Change Account Status

How to change the account status of an EXPIRED account (without knowing the account's password)Requirement: SYSTEM or SYS access1. Identify the value of the passwordselect name,password from SYS.USER$ where name=‘USERNAME’;2. Change the account status by using same password:alter user USERNAME identified by values '< password retrieved above >';

Strange error when renaming a table

ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operationsWhen we try to rename a table or index name in Oracle, we use a simple command as followingALTER TABLE [SCHEMA_NAME].[OLD_TABLE_NAME] RENAME TO [NEW_TABLE_NAME];If we put into schema names to this command, we can deal with ORA-14047 error.This error raise when we put schema ...

The Best Terminal Emulator for Mac OS X

Mac OS X includes a great terminal editor, but among the handful of alternatives is one that easily rises above them all. iTerm2 is our pick for the best terminal emulator for Mac OS X thanks to its vast number of time-saving features and high level of customizability. Source: The Best Terminal Emulator for Mac ...

Browse Categories

%d bloggers like this: