locutoriorama

Chuleta Consultas Utiles by locuto

This section provides sizing recommendations based on the active Oracle E-Business Suite user counts. The following table should be used to size the relevant parameters: Parameter Name Development or Test Instance 11-100 Users 101-500 Users 501-1000 Users 1001-2000 Users processes 200 200 800 1200 2500 sessions 400 400 1600 2400 5000 sga_target Footnote 1 1G 1G 2G 3G 14G shared_pool_size (csp) N/A N/A N/A 1800M 3000M shared_pool_reserved_size (csp) N/A N/A N/A 180M 300M shared_pool_size (no csp) 400M 600M 800M 1000M 2000M shared_pool_reserved_size (no csp) 40M 60M 80M 100M 100M pga_aggregate_target 1G 2G 4G 10G 20G Total Memory Required Footnote 2 ~ 2 GB ~ 3 GB ~ 6 GB ~ 13 GB ~ 34 GB Footnote 1 The parameter sga_target should be used for Oracle 10g or 11g based environments such as Release 12. This replaces the parameter db_cache_size , which was used in Oracle 9 i based environments. Also, it is not necessary to set the parameter undo_retention for 10g or 11g-base

Chuleta Comandos RPM by locuto

*********************** INSTALACION JDK 1.7.0_21 ************************ 1º Instala el JDK. download here rpm -ivh 2º Comprobar la ruta donde se ha instalado /usr/java/jdk1.7.0_21/bin 3º Utilizar "alternatives" para establecer el JDK por defecto del sistema: /usr/sbin/alternatives --install /usr/bin/java java /usr/java/jdk1.7.0_21/bin/java 16026 /usr/sbin/alternatives --display java /usr/sbin/alternatives --config java There are 3 programs which provide 'java'.   Selection    Command -----------------------------------------------    1           /usr/lib/jvm/jre-1.5.0-gcj/bin/java *  2           /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java  + 3           /usr/java/jdk1.7.0_21/bin/java Enter to keep the current selection[+], or type selection number: ^C [root@oel6 bin]# java -version java version "1.7.0_21" Java(TM) SE Runtime Environment (build 1.7.0_21-b11) Java HotSpot(TM) 64-Bit Server VM (build 23.21-b01, mixed mode) [root

*Get the software here *Check if JDK is installed (JDK 1.6.0_11 or above): java -version - if not, download here (or get details from your hardware vendor)      (click 'Download JDK 6.0 Update ', where is the latest update) *Unzip software in a directory. *Run sqldeveloper.sh: sh  sqldeveloper.sh * JDK configuration is in sqldeveloper.conf file. SetJavaHome /usr/java/jdk1.7.0_21/bin SetSkipJ2SDKCheck true

Teniendo una Biblioteca con dos ubicaciones distintas para Mis Documentos, si queremos establecer una ubicación distinta a la actual como ubicación predeterminada:

---------------------------------------------------------- SQL Prompt With Time ---------------------------------------------------------- SQL> set time on 09:50:16 SQL> 09:50:19 SQL> select sysdate from dual; SYSDATE --------- 20-APR-11 09:50:34 SQL> ---------------------------------------------------------- SQL Prompt With USER ---------------------------------------------------------- SQL> set sqlprompt "_USER> " SCOTT> SCOTT> SCOTT> select sysdate from dual; SYSDATE --------- 20-APR-11 SCOTT> ---------------------------------------------------------- SQL Prompt With SID ---------------------------------------------------------- SQL> set sqlprompt "_CONNECT_IDENTIFIER> " mydb> mydb> mydb> select sysdate from dual; SYSDATE --------- 20-APR-11 mydb> ---------------------------------------------------------- SQL Prompt With USER@SID -------------------------------------------