http://gerardnico.com/wiki/ 2012-02-03T22:59:33+01:00 http://gerardnico.com/wiki/ http://gerardnico.com/wiki//gerardnico.com/wiki/lib/tpl/gerardnico/images/favicon.ico text/html 2012-02-03T22:52:55+01:00 gerardnico http://gerardnico.com/wiki/language/java/servlet About A Java servlet is: * a J2ee web component that responds to HTTP requests. * a HTTP-specific servlet class in Java EE that conforms to the Java Servlet technology API, a protocol by which a Java class may respond to requests. Servlets are the Java counterpart to non-Java dynamic Web content technologies such as: text/html 2012-02-03T22:51:18+01:00 gerardnico http://gerardnico.com/wiki/language/java/dependency_injection Articles Related text/html 2012-02-03T17:19:12+01:00 gerardnico http://gerardnico.com/wiki/oracle/mos About MOS is an acronym for My Oracle Support. It's the single entry for the Oracle Support. You can touch it on this URL: * <http://support.oracle.com> Articles Related History Before the end of 2009, Oracle had two support web site that are fusionned in one. text/html 2012-02-03T11:10:41+01:00 gerardnico http://gerardnico.com/wiki/database/oracle/sql_plan_management Em Em Console > Server > Query Optimization > SQL Plan Management Documentation * White Paper * Live Webcast text/html 2012-02-03T11:00:02+01:00 gerardnico http://gerardnico.com/wiki/database/oracle/statspack Statspack must be installed when connected as sysdba (Connect / as sysdba). You'll need to know three pieces of information before running the script spcreate.sql (spdrop.sql to drop it) : * the password you would like to use for the PERFSTAT schema that will be created * the default tablespace you would like to use for PERFSTAT * the temporary tablespace you would like to use for PERFSTAT text/html 2012-02-03T10:58:05+01:00 gerardnico http://gerardnico.com/wiki/database/oracle/statistics Type of Statistics * Dictionary by Table, Column * System (of the operating System) during a regular workload (otherwise non appropriate values for the CPU costing for instance) Articles Related * Oracle Database - Table and columns - Optimizer Statistics text/html 2012-02-03T09:12:20+01:00 gerardnico http://gerardnico.com/wiki/database/oracle/profile About A profile is a collection of parameters that sets limits on database resources. When you change the profile to a user, you assign a profile but you apply also a set of parameters. If you assign the profile to a user, then that user cannot exceed these limits parameters. text/html 2012-02-03T09:11:12+01:00 gerardnico http://gerardnico.com/wiki/apex/installation_4 About Installation steps of Apex 4.0 with Oracle Application Express Listener as HTTP Listener. Oracle Application Express Listener is a Java-based Web server. It features file system caching, support for FOP transformations to PDF, offers improved file upload capability, and is certified against Web Logic, Tomcat, OC4J, and Oracle Glassfish Server. text/html 2012-02-01T21:16:52+01:00 gerardnico http://gerardnico.com/wiki/ide/sqldeveloper/sqldeveloper About Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. text/html 2012-02-01T21:16:25+01:00 gerardnico http://gerardnico.com/wiki/ide/sqldeveloper/my_sql About How to make a connection with a mySQL Server in SQL Developer ? Articles Related Steps * Install the jdbc mySQL third party by performing a check for update. In the menu : Help > Check for Update * Add a mySQL Server Connection text/html 2012-01-31T21:36:19+01:00 gerardnico http://gerardnico.com/wiki/glassfish/installation About To install J2EE, you must download it. Java EE 6 SDK Update 3: A free integrated development kit used to build, test, and deploy Java EE 6 applications. Includes: * GlassFish Open Source Edition 3.1.1 * Java EE 6 Code Samples * Java EE 6 API Documentation * Java EE 6 Tutorial * Your First Cup: An Introduction to the Java EE Platform text/html 2012-01-31T21:11:41+01:00 gerardnico http://gerardnico.com/wiki/language/java/archive About For deployment purpose, J2EE applications are delivered and reside in Archive files (or unit). A RAR, WAR or EAR file is a standard JAR (.jar) file with a .war or .ear extension. Each archive extension file denotes its purpose. J2EE Archive Type File Extension Module Type Enterprise Archive EAR All modules together Java Archive JAR , Web Archive WAR Resource Adapter RAR A J2EE archive is composed of: text/html 2012-01-30T10:02:32+01:00 gerardnico http://gerardnico.com/wiki/dat/obiee/patch About When you install patch, it's often asked to “Create and Deploy a new analytics.war (or .ear) file”. This article go to the steps to perform this tasks. Articles Related Steps Creating a war file * Shut down the Oracle BI Presentation Service * Creating a WAR File for Oracle BI Presentation Services text/html 2012-01-30T10:00:46+01:00 gerardnico http://gerardnico.com/wiki/dat/obiee/query_cache_purging About How to purge the Query Cache Articles Related Disabling For the entire application To disable completly the query cache, you must set to the ENABLE cache parameter the value NO in the file nqsconfig. [CACHE] ENABLE = NO; For one session For one session, you have to set the session system variable with the value 1: text/html 2012-01-30T09:59:39+01:00 gerardnico http://gerardnico.com/wiki/dat/obiee/query_cache About Query caching is a persistent cache mechanism The query cache consists of : * cache storage space, * cache metadata. The data are retrieved from the cache metadata instead to ask again the data source. * and cache detection in query compilation. text/html 2012-01-30T09:55:08+01:00 gerardnico http://gerardnico.com/wiki/dat/obiee/nqcmd About nqcmd is an ODBC client tools for BI Server that is named: * nqcmd.exe (under UNIX) * nQCmd.exe (under Windows) and a version can be found in the following Oracle BI installation folder: [installdrivepath]:\OracleBI\server\Bin. Articles Related How to run NqCmd ? You can run nQCmd.exe from: text/html 2012-01-29T15:54:26+01:00 gerardnico http://gerardnico.com/wiki/language/java/deployment_descriptor About Deployment descriptors are XML documents included in the JARs that describes: * component's configuration, * deployment settings of an application, a module, or a component * of and instructions to the J2EE container. An enterprise bean module deployment descriptor, for example, declares transaction attributes and security authorizations for an enterprise bean. text/html 2012-01-29T15:31:48+01:00 gerardnico http://gerardnico.com/wiki/language/java/application About Type of Application in a J2EE environment. A Java EE application is packaged into one or more standard units for deployment to any Java EE platform-compliant system. Each unit contains: * A functional component or components, such as an enterprise bean, web page, servlet, or applet * An optional deployment descriptor that describes its content text/html 2012-01-29T15:31:10+01:00 gerardnico http://gerardnico.com/wiki/language/java/deploy About In j2ee terminology the installation process is called deployment. Once a Java EE unit has been produced, it is ready to be deployed. Deployment typically involves using a platform’s deployment tool to specify location-specific information, such as a list of local users who can access it and the name of the local database. text/html 2012-01-29T13:05:02+01:00 gerardnico http://gerardnico.com/wiki/language/java/build Articles Related