It’s not your businesses to know let decide database 🙂
There are a lot of options which can be used in database. Not all are available in your database. It depends which version of database you are using (standard/enterprise or else) or if a given option is active/tuned off/on. You can find details in V$OPTION.
select * from v$option; PARAMETER VALUE ----------------------------------------- ----- Active Data Guard FALSE Advanced Compression TRUE Backup Encryption TRUE Basic Compression TRUE ... Spatial TRUE Streams Capture TRUE Unused Block Compression TRUE XStream TRUE 64 rows selected
This article presents new features related to table compression in Oracle 11g. It’s not presenting compression related to Exadata.
Compression option is extended in 11g and have following features:
This article presents new features of 11g added to opatch.
It’s very nice feature of 11g for applying “online” bug fixes on live databases:
This functionality is provided with commonly know opatch command-line utility and new type of patches “online”.
UTL_MATCH is very interesting package which implements quite advanced algorithms to match two strings. You can use them to quickly match name like First Names or Last Names.
Two basic algorithms are implemented here:
“Edit Distance” – is a measure of Similarity between two strings, s1 and s2. The distance is the number of insertions, deletions or substitutions required to transform s1 to s2
“Jaro-Winkler algorithm” is another way of calculating Edit distance between two strings. It is a String Comparator measure that gives values of partial agreement between two strings. The string comparator accounts for length of strings and partially accounts for typical human errors made in alphanumeric strings
In this article I present how NLS_NUMERIC_CHARACTERS parameter works.
This parameter specifies the characters to use as group separator and decimal character. The group separator separates integer groups (that is, thousands, millions, billions, and so on). The decimal separates the integer portion of a number from the decimal portion.
NLS_NUMERIC_CHARACTERS = “decimal_character group_separator”
This article presents new feature of 11g Real time sql monitoring.
Real time sql monitoring introduced in Oracle 11G enables to monitor performance of SQL statements while they are running. Statistics about monitored queries are visible in new views.
This article presents installation of new Oracle Enterprise Manager 12C version 12.1.0.2 on OEL5, OEL6. You need at least 5GB of memory for this installation so check your VirtualBox settings before proceeding.
Read following article to find out how to install OEL5,6 and database 11G Linux. They are required for this installation:
This installation was done on OEL5 but it’s no different on OEL6(extra library must be installed)