tag:blogger.com,1999:blog-10229403199508104722024-03-05T10:33:17.708-08:00Students at OracleStudents at Oracle is a blog created by internal students from Oracle to help people introducing them to Oracle products with tutorials, viewlets and guides.Students at Oraclehttp://www.blogger.com/profile/04894488275697727793noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-1022940319950810472.post-65508721927180191562012-02-17T04:44:00.001-08:002012-03-06T03:06:48.371-08:00OVM: OEL 5.7 Kernel panic on OVM 3<div style="text-align: justify;"><span style="font-family: Georgia, serif; font-size: 100%; text-align: left; ">If you are trying to create a new virtual machine on </span><b style="font-family: Georgia, serif; font-size: 100%; text-align: left; ">Oracle VM Manager</b><span style="font-family: Georgia, serif; font-size: 100%; text-align: left; "> with a </span><b style="font-family: Georgia, serif; font-size: 100%; text-align: left; ">Oracle Enterprise Linux 5.7</b><span style="font-family: Georgia, serif; font-size: 100%; text-align: left; "> or a </span><b style="font-family: Georgia, serif; font-size: 100%; text-align: left; ">Red Hat E</b><b style="font-family: Georgia, serif; font-size: 100%; text-align: left; ">nterprise Linux 5.7</b><span style="font-family: Georgia, serif; font-size: 100%; text-align: left; "> as an O.S.; a </span><b style="font-family: Georgia, serif; font-size: 100%; text-align: left; ">kernel panic</b><span style="font-family: Georgia, serif; font-size: 100%; text-align: left; "> error may appear:</span></div><div style="font-family: Georgia, serif; font-size: 100%; font-variant: normal; line-height: normal; font-style: normal; font-weight: normal; text-align: center; "><span style="font-family: Georgia, serif; font-size: 100%; text-align: left; "><i>Kernel panic - not syncing: Attempted to kill init!</i></span></div><div style="font-family: Georgia, serif; font-size: 100%; font-variant: normal; line-height: normal; font-style: normal; font-weight: normal; text-align: center; "><span style="font-size: 100%; font-family: Georgia, serif; text-align: left; "><br /></span></div><div style="text-align: center; font-family: Georgia, serif; font-size: 100%; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; "><img style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; cursor: pointer; width: 400px; height: 252px; " src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPIMVJ4ooUTDnr32-kICVhTYtyJ_0G4lKygFyIdQumTRz0iEB_pKyjcUieX_qj9eVCHrjpT4V0-fey9EjYj9Hd0MCGxnBpni1S5lCdRvi6zsKlvUb6ZpsB6i0l36T3mVctf6swkreLcDk/s400/OEL57_kernel_panic.bmp" border="0" alt="" id="BLOGGER_PHOTO_ID_5710087869134955410" /><span ><u><br /></u></span><br /></div><div style="font-family: Georgia, serif; font-size: 100%; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; "><br /></div><div style="font-style: normal; font-weight: normal; text-align: justify; font-family: Georgia, serif; font-size: 100%; font-variant: normal; line-height: normal; "><span style="font-style: normal; ">You can <b>solve</b> this issue adding an option atribute on the grub loader. Enter the grub menu and press 'a' key to append a new attribute, type the option </span><i style="font-weight: normal; ">xen_emul_unplug=never</i> as shown below:</div><div style="text-align: justify; font-family: Georgia, serif; font-size: 100%; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; "><br /></div><div style="font-family: Georgia, serif; font-size: 100%; text-align: justify; font-variant: normal; line-height: normal; "><div style="font-style: normal; font-weight: normal; text-align: center; "><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuY46nOJBRihzYBB-UpjP82eOn-eAEctqe3lommo8b6r0v5kwvpuOADWffrGqvslmNEbiJNIcZwTFptxMIo6ZlBvXufDL4s5om4VqtWn_QxcY8RWA0LAVSssILQYKqpR_n0PBAMYS6EVk/s400/OEL57_kernel_panic2.bmp" border="0" alt="" id="BLOGGER_PHOTO_ID_5710088026288898610" style="font-family: Georgia, serif; font-size: 16px; display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; cursor: pointer; width: 400px; height: 332px; " /></div><div><br /></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; ">Now, your VM will boot normally!</div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><br /></div><div style="font-family: Georgia, serif; font-size: 100%; "><span style="font-weight: normal; ">Remember to edit the </span><b>/etc/grub.conf</b><span style="font-weight: normal; "> file, adding the <i>xen_emul_unplug=never</i> option for the </span><b style="font-style: normal; ">next boot</b>!</div><div style="font-family: Georgia, serif; font-size: 100%; "><div style="text-align: center; "><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFFbEcDRp1H_YZUN9gPrW-U0HnSYCUN_LdzvdI0IFFEK2xCWqlNNpvANgxSPRx18krvf_2cURF3W59ODM2aBHHq5xiQYg3JJgf_iuCL65-LOMQTsxc9Qns7jGPb9i-lOw8FDqwjSPyWcQ/s400/grub.conf.JPG" border="0" alt="" id="BLOGGER_PHOTO_ID_5716738739983726018" style="color: rgb(0, 0, 238); text-decoration: underline; display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; cursor: pointer; width: 400px; height: 278px; " /></div><div><br /></div></div><div style="text-align: center;font-family: Georgia, serif; font-size: 100%; "><br /></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><br /></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><b>Documentation:</b></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><a href="http://www.oracle.com/technetwork/documentation/vm-096300.html">Oracle's official documentation for Oracle VM</a></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><br /></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><b>Downloads:</b></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><a href="http://edelivery.oracle.com/linux">Oracle VM and VM Templates</a></div><div style="font-style: normal; font-weight: normal; font-family: Georgia, serif; font-size: 100%; "><br /></div></div>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com43tag:blogger.com,1999:blog-1022940319950810472.post-56162006887600125952011-07-04T02:31:00.000-07:002011-08-23T02:09:22.593-07:00ODC: How to scan and commit files to UCM<div>Oracle offers in its Enterprise Content Management (<b>ECM</b>) suite solutions for the capture and document recognition. Oracle Document Capture (<b>ODC</b>) 10g is a desktop application designed to <b>capture </b>documents for, later, <b>recognize </b>some areas and metadata and <b>index </b>them against a target repository which can be a file system, a database, <b>Content Server</b> UCM, etc.</div><div>
<br /></div><div>Oracle Document Capture incorporates other features such as indexing, recognition and import of documents in a customized and programmable <b>batch processes</b>. It also includes the Oracle Distributed Document Capture (<b>ODDC</b>) technology, an application based on a web interface to scan and index documents in a <b>distributed </b>environment.</div><div>
<br /></div><div>You can follow a guide to install and configure the software here: <a href="http://studentsatoracle.blogspot.com/2010/11/odc-install-and-configure-oracle.html">http://studentsatoracle.blogspot.com/2010/11/odc-install-and-configure-oracle.html</a></div><div>
<br /></div><div>In the viewlet below, you can follow a tutorial to prepare the software to scan invoices (in this example) and index it in a Oracle UCM Content Server. The viewlet shows all the needed steps to be able to scan and index and how to capture metadata automatically using OCR zones.</div><div>
<br /><b><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">Documentation:</span></span></b>
<br /><a href="http://download.oracle.com/docs/cd/E10316_01/capture.htm"><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">Oracle's oficial documentation for ECM 10g</span></span></a>
<br /><a href="http://download.oracle.com/docs/cd/E10316_01/capture/odc_install.pdf"><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">Installation guide for ODC</span></span></a>
<br /><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">
<br /></span></span>
<br /><b><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">Downloads:</span></span></b>
<br /><a href="http://www.oracle.com/technetwork/middleware/content-management/downloads/index-dc-096316.html"><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">Oracle ODC and ODDC</span></span></a>
<br /><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">
<br /></span></span>
<br /><b><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">Viewlet:</span></span></b>
<br /><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">(Duration: 8 min.)</span></span>
<br /><iframe src="http://www.youtube.com/embed/4PwfGLw44oo" allowfullscreen="" frameborder="0" height="345" width="560"></iframe>
<br /><span class="" id="result_box" lang="en"><span title="" style="background-color: rgb(235, 239, 249); ">
<br /></span></span></div>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com11tag:blogger.com,1999:blog-1022940319950810472.post-30204297830195658092011-05-17T12:42:00.000-07:002011-05-20T02:52:28.962-07:00Webcenter: Build and use Taskflows from Data Controls<div>In <b>Enterprise 2.0</b> applications is important to have a flexible and customizable screens that make easy the navigation and the interaction for users. So with Oracle <b>Webcenter Suite 11g</b> you are able to create new <b>Business Mashups</b> easily and will help you to show graphical information, interact with a database, ...</div><div><br /></div><div>In the example below, we are adding the two kinds of <b>mashups </b>to a Webcenter Spaces page. The first one is a <b>SQL </b>Data Control that will <b>fetch </b>data from a database table and the second one is a <b>webservice </b>deployed on the Weblogic application server that will <b>insert </b>data from the Webcenter page to the same database table.</div><div><br /></div><div><i>Note: You can follow this guide to deploy a new Webservice</i></div><div><a href="http://studentsatoracle.blogspot.com/2011/05/jdeveloper-create-and-deploy-java.html">http://studentsatoracle.blogspot.com/2011/05/jdeveloper-create-and-deploy-java.html</a></div><div><b><br /></b></div><div>Once the <b>mashups </b>are added, the video is showing how to <b>test </b>it and checking it by connecting to the database through sqlplus.</div><div><span style="font-weight: bold; "><br /></span></div><div><span style="font-weight: bold; ">Documentation:</span><br /><a href="http://www.oracle.com/technetwork/middleware/webcenter/documentation/index.html">Oracle's official documentation for Webcenter Suite 11g</a><br /><br /><span style="font-weight: bold; ">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/middleware/webcenter/downloads/index.html">Oracle Webcenter Suite 11g</a><br /><br /><span style="font-weight: bold; ">Viewlet:</span><br />(Duration: 6 min.)</div><iframe width="425" height="344" src="http://www.youtube.com/embed/4iKQpR_EC-E?fs=1" frameborder="0" allowfullscreen=""></iframe>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com2tag:blogger.com,1999:blog-1022940319950810472.post-34330097329090130272011-05-02T03:49:00.000-07:002011-07-04T03:09:40.651-07:00jDeveloper: Create and deploy a Java WebserviceThis tutorial shows how to create a simple Java <span style="font-weight:bold;">Webservice</span><span style="font-weight: bold;"> </span>using the Oracle jDeveloper 11g IDE.<span style="font-weight: bold;"><span style="font-weight: bold;"> </span></span>The attached code for the example connects to a database through <span style="font-weight: bold;">JDBC </span>and executes a <span style="font-weight: bold;">SQL </span>statement to insert a new row in a specific table.<span style="font-weight: bold;"><br /><span style="font-weight: bold;"><span style="font-weight: bold;"><br /></span></span></span>Once the application has been configured, it will be <span style="font-weight: bold;">deployed </span>and <span style="font-weight: bold;">tested </span>in a Oracle <span style="font-weight: bold;">Weblogic</span> Server. We will execute the webservice through a web browser and check it by connecting<span style="font-weight: bold;"> </span>to the database with a sqlplus console.<span style="font-weight: bold;"><br /><br /><span style="font-weight: bold;">Step-by-step:<br /></span> </span>1) Create a generic java <span style="font-weight: bold;">application </span>and add the webservice component<br /><br />2) Create a new java class and add some <span style="font-weight: bold;">methods </span>to publish. Here you have an example:<br />NOTE: Remember to adapt this code to your requirements.<br /><br /><code> public void InsertValue(String user, String value){<br /> try{<br />//Example from http://studentsatoracle.blogspot.com<br /> Connection con=null;<br /> Class.forName("oracle.jdbc.driver.OracleDriver");<br /><br />//Configure the jdbc connection: jdbc:oracle:thin:@host:port:SID,username,passwd<br />con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:owcdb01", "DEV_WEBCENTER","welcome1");<br /> Statement s = con.createStatement();<br />//Configure the SQL query as you want, the table must exists <br />s.execute("INSERT INTO DEV_WEBCENTER.uservalues (ID,USERNAME,INSERTDATE,VALUE) VALUES (DEV_WEBCENTER.uservalues_seq.nextval,'"+user+"',To_char(SYSDATE),"+value+")");<br /> s.close();<br /> con.close();<br /> }catch(Exception e){<br /> System.out.println("ERROR: "+e.getMessage());<br /> }<br />}</code><br /><br />3) Configure the <span style="font-weight: bold;">webservice </span>and publish the desired methods<br /><br />4) <span style="font-weight: bold;">Deploy </span>the application. You can follow this guide to create a deployment profile: <a href="http://studentsatoracle.blogspot.com/2011/02/jdeveloper-how-to-deploy-application-to.html">http://studentsatoracle.blogspot.com/2011/02/jdeveloper-how-to-deploy-application-to.html</a><br /><br />5) Open a Weblogic Server console and <span style="font-weight: bold;">test </span>the application<br /><br /><span style="font-weight: bold;">Documentation:</span><br /><a href="http://www.oracle.com/technetwork/developer-tools/jdev/documentation/index.html">Oracle's official documentation for jDeveloper 11g</a><br /><br /><span style="font-weight: bold;">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html">Oracle jDeveloper 11g</a><br /><br /><span style="font-weight: bold;">Viewlet:</span><br />(Duration: 3 min.)<br /><iframe src="http://www.youtube.com/embed/9Nv5JuiP3Aw?fs=1" allowfullscreen="" width="480" frameborder="0" height="295"></iframe>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com8tag:blogger.com,1999:blog-1022940319950810472.post-28853301122195973062011-03-28T04:01:00.000-07:002011-03-29T01:36:09.339-07:00Combine Partitioning, Advanced Compression and TotalRecall features in Oracle Database 11g<div style="font-family: Arial,Helvetica,sans-serif;"><style type="text/css">
<!--
@page { margin: 2cm }
PRE.cjk { font-family: "MS PGothic", monospace }
P { margin-bottom: 0.21cm }
A:link { so-language: zxx }
TT.cjk { font-family: "NSimSun", monospace }
CODE.cjk { font-family: "MS PGothic", monospace }
-->
</style> </div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">Using Partitioning together, Advanced Compression and TotalRecall features can reduce the workload and, thus, work more efficiently. </span> </div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">Partitioning provides several ways of partitioning a table into multiple subtables and define multiple criteria partition from a Partition Key.</span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">Advanced Compression provides multiple compression features, including OLTP compression. This feature is widely explained and tested in this same blog. Follow this link if you want to explore it deeper: <a href="http://studentsatoracle.blogspot.com/2010/12/advanced-compression-in-oracle-database_03.html">http://studentsatoracle.blogspot.com/2010/12/advanced-compression-in-oracle-database_03.html</a>.</span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">Last, but no least, TotalRecall creates a flashback file to record activity on the table, so the user can see the value that had a record of that table on a certain day and time. In addition, the user can define the time of data retention and the quota of disk space used for it.</span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">We'll test a "worst-case" scenario using all three features on a test table. We will create a table partitioned in two subtables, each one of them having a different compression type. Also, we'll set a flashback file so we can query the values of the table for a year.</span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">But, we'll just focus on the most efficient way of combining the three features, we won't check any metrics like execution times or compression rate.</span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">First we must do some thinking. Partitions of a table must be defined at the <i>create table</i> command while compression can be either defined at the creation of the table or later with the <i>alter table</i> command. We can alter a partitioned table, but due to limitations of partitioning, we can't alter the compression type of a subtable. So, we'll have to define the partitions and the compression type when we create the table.</span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">So, let's create our test table:</span><br />
<br />
<br />
<div style="text-align: left;"><span class="western"><span style="color: black;"><span style="font-size: small;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">create table atest ( c1 number(5), c2 varchar2(5), c3 varchar2(5), primary key (c1) validate)</span></span></i></span></span></span></div></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><div style="text-align: left;"><span style="color: black;"><span style="font-size: small;"><i>partition by range(c1) (</i></span></span></div><div style="margin-bottom: 0cm; text-align: left;"><div style="text-align: left;"><span style="color: black;"><span style="font-size: small;"><i>partition atest_p1 values less than(6) <span style="text-decoration: none;">compress</span>,</i></span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="color: black;"><i><span style="font-weight: normal;">partition atest_p2 values less than(maxvalue) </span></i></span><span style="color: black;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">compress for oltp</span></span></i></span></span></div><div style="text-align: left;"><span style="font-size: small;"><i>);</i></span></div><br />
<br />
<span class="western"><span style="color: black;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;">With this setting, we split the newly created table test in two subtables and the criteria for the partition is the range of values at the column </span></span></span></span></span><span class="western"><span style="color: black;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">c1</span></span></i></span></span><span class="western"><span style="color: black;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;">. Any item with </span></span></span></span></span><span class="western"><span style="color: black;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">c1</span></span></i></span></span><span class="western"><span style="color: black;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;"> lower than 6 will go to the subtable </span></span></span></span></span><span class="western"><span style="color: black;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">atest_p1</span></span></i></span></span><span class="western"><span style="color: black;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;">, while the rest will go to </span></span></span></span></span><span class="western"><span style="color: black;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">atest_p2</span></span></i></span></span><span class="western"><span style="color: black;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;">. In addition, we define the compression type for the subtables. Subtable </span></span></span></span></span><span class="western"><span style="color: black;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">atest_p1</span></span></i></span></span><span class="western"><span style="color: black;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;"> has a basic compression, while </span></span></span></span></span><span class="western"><span style="color: black;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">atest_p2</span></span></i></span></span><span class="western"><span style="color: black;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;"> has OLTP compression.</span></span></span></span></span><br />
<br />
<span style="font-size: x-small;"><span class="western"><span style="color: black;"><span style="font-size: small;"><span style="font-style: normal;"><span style="text-decoration: none;"><span style="font-weight: normal;">Then we fill it a little with some silly loop:</span></span></span></span></span></span></span></div></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: x-small;"><span class="western"><span style="color: black;"><span style="font-size: small;"><i><span style="text-decoration: none;"><span style="font-weight: normal;"> insert into atest</span></span></i></span></span></span></span><br />
<span style="font-size: x-small;"><span class="western"><span style="color: black;"><span style="font-size: small;"><i><span style="text-decoration: none;"><span style="font-weight: normal;">select rownum, (rownum*2)+2, (rownum*3)+3</span></span></i></span></span></span></span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: x-small;"><span class="western"><span style="color: black;"><span style="font-size: small;"><i><span style="text-decoration: none;"><span style="font-weight: normal;"> from dual connect by rownum <= 10;</span></span></i></span></span></span></span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">Here comes the funny part. Once partitions, compression types and data are set, it's time to test the TotalRecall feature. First of all, we will need to create a new Tablespace:</span><code class="western" style="font-family: Arial,Helvetica,sans-serif;"></code><code class="western"></code> </div><div style="font-family: Arial,Helvetica,sans-serif;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif;"><i>create tablespace flasharch;</i></div><span style="font-size: small;"><i></i></span><br />
<div style="font-family: Arial,Helvetica,sans-serif;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">Now, we'll create and set the flashback file:</span></div><span style="font-size: small;"><br />
</span><br />
<br />
<span style="font-size: small;"><i>create flashback archive atest_fla tablespace flasharch quota 1M retention 1 year;</i></span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;">Once we create the flashback, we have to alter our test table to "link" them:</span></div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;"><i> alter table atest flashback archive atest_fla;</i></span></div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><span style="font-size: small;">And that's all there is to it. Now, let's give it a shot.</span><br />
<br />
<span style="font-size: small;">Make a simple update, changing the values inside our test table:</span></div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;"><i> update atest set c2=c2+c3+12;</i></span></div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><span style="font-size: small;">Then, execute a query refering to a moment before the update. To make things more difficult, let's ask only for the values of subtable atest_p2 (change the value inside the brackets for the time before the update if testing):</span></div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
<span style="font-size: small;"><i>select * from atest partition (atest_p2) as of timestamp to_timestamp('DD-MMM-YY hh.mm.ss');</i></span></div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;"><span style="font-size: small;"><span style="font-style: normal;">Keep in mind that once we alter the table to the flashback, we won't be able to perform some operations on that table, mostly </span><i>alter table</i><span style="font-style: normal;">. We'll have to drop the flashback if we want to perform major changes to the "flashbacked" table. So, while this method gives all the benefits of the three features, also has the disadvantage of making the table somewhat static and unalterable. This means there must be some previous planning, because dismantling the settings may end in loss of information. Knowing all that, the advantages of using various powerful features integrated in the database are obvious.</span></span></div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><br />
</div><div style="font-family: Arial,Helvetica,sans-serif; font-style: normal; margin-bottom: 0cm;"><span style="font-size: small;">Thanks for reading and feel free to leave any comments or questions.</span></div>Guillem Vivóhttp://www.blogger.com/profile/15806845704633647629noreply@blogger.com2tag:blogger.com,1999:blog-1022940319950810472.post-44202901712843689902011-03-16T04:05:00.000-07:002011-03-16T04:24:25.925-07:00Setting listener.ora and tnsnames.ora on Amazon EC2Every time you start your Amazon EC2 instance, your public and private DNS change. This is a problem because we have to modify the files listener.ora and tnsnames.ora many times. If not, your listener (among other things) will not work.<br /><br />The following bash script creates the two files with the private ip that you pass as argument and starts the listener. The old files are renamed in the same folder (just in case you want to recover them).<br /><br />Check that the LISTENER_DIR variable is correct in your system.<br /><br /><blockquote style="font-style: italic;"><span style="font-size:85%;">#!/bin/bash<br /><br />EXPECTED_ARGS=1<br />LISTENER_DIR=/u01/app/oracle/product/11.2.0/db_1/network/admin<br /><br />if [ $# -ne $EXPECTED_ARGS ]<br />then<br /> echo "Usage: `basename $0` {private_ip}"<br /> exit 0<br />fi<br /><br />cp ${LISTENER_DIR}/listener.ora ${LISTENER_DIR}/listener.ora.old<br /><br />echo "LISTENER =" > ${LISTENER_DIR}/listener.ora<br />echo " (DESCRIPTION_LIST =" >> ${LISTENER_DIR}/listener.ora<br />echo " (DESCRIPTION =" >> ${LISTENER_DIR}/listener.ora<br />echo " (ADDRESS = (PROTOCOL = TCP)(HOST = "${1}")(PORT = 1521))" >> ${LISTENER_DIR}/listener.ora<br />echo " )" >> ${LISTENER_DIR}/listener.ora<br />echo " )" >> ${LISTENER_DIR}/listener.ora<br /><br />lsnrctl start<br /><br />cp ${LISTENER_DIR}/tnsnames.ora ${LISTENER_DIR}/tnsnames.ora.old<br /><br />echo "ORCL =" > ${LISTENER_DIR}/tnsnames.ora<br />echo " (DESCRIPTION =" >> ${LISTENER_DIR}/tnsnames.ora<br />echo " (ADDRESS = (PROTOCOL = TCP)(HOST = "${1}")(PORT = 1521))" >> ${LISTENER_DIR}/tnsnames.ora<br />echo " (CONNECT_DATA =" >> ${LISTENER_DIR}/tnsnames.ora<br />echo " (SERVER = DEDICATED)" >> ${LISTENER_DIR}/tnsnames.ora<br />echo " (SERVICE_NAME = orcl)" >> ${LISTENER_DIR}/tnsnames.ora<br />echo " )" >> ${LISTENER_DIR}/tnsnames.ora<br />echo " )" >> ${LISTENER_DIR}/tnsnames.ora<br /><br /></span></blockquote>Carlos Molinahttp://www.blogger.com/profile/17627289867407495390noreply@blogger.com7tag:blogger.com,1999:blog-1022940319950810472.post-60369881097742860722011-02-18T03:35:00.000-08:002011-02-21T02:37:18.552-08:00Oracle Webcenter 11g Developer's TutorialOracle Fusion Middleware has released a new <span style="font-weight: bold;">tutorial </span>for the new version of <span style="font-weight: bold;">Oracle Webcenter</span> (11.1.1.4) which introduce users to the Webcenter Portal Framework for <span style="font-weight: bold;">developers</span>.<br /><br />The tutorial covers the <span style="font-weight: bold;">main features</span>:<br />1) Create a <span style="font-weight: bold;">web application</span> through jDeveloper 11g<br />2) Modify <span style="font-weight: bold;">Page Templates</span> and <span style="font-weight: bold;">Skins</span><br />3) Changing the<span style="font-weight: bold;"> look & feel</span> of the application<br />4) Consume content from an external <span style="font-weight: bold;">repository </span>(Oracle UCM)<br />5) Pages <span style="font-weight: bold;">permissions </span>and <span style="font-weight: bold;">runtime content editing</span> with <span style="font-weight: bold;">Oracle Composer</span><br /><br /><span style="font-weight: bold;">Tips and troubleshoot:</span><br /><a href="http://studentsatoracle.blogspot.com/2011/02/jdeveloper-how-to-deploy-application-to.html">jDeveloper: How to deploy an application to an external WebLogic Server</a><br /><a href="http://studentsatoracle.blogspot.com/2011/02/jdeveloper-connecting-ucm-as-repository.html">jDeveloper: Connecting UCM as a repository</a><br /><a href="http://studentsatoracle.blogspot.com/2011/02/setting-permissions-between-oracle-ucm.html">Setting permissions between Oracle UCM and Webcenter Spaces</a><br /><br /><span style="font-weight: bold;">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/middleware/webcenter/owcs-r11ps3-devtutsetup-254761.zip">Tutorial Content Materials</a><br /><br /><span style="font-weight: bold;">Tutorial:</span><br /><a href="http://download.oracle.com/docs/cd/E17904_01/webcenter.1111/e10273/toc.htm"></a><a href="http://download.oracle.com/docs/cd/E17904_01/webcenter.1111/e10273/toc.htm">Go Green, Eat Fresh</a>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com5tag:blogger.com,1999:blog-1022940319950810472.post-63579052280333144112011-02-14T03:11:00.000-08:002011-02-18T03:33:20.460-08:00Setting permissions between Oracle UCM and Webcenter Spaces<span>Web applications usually consume dynamic content from the <span style="font-weight: bold;">Content Server</span> to enrich the website. In a <span style="font-weight: bold;">Webcenter </span>application, the task flow <span style="font-weight: bold;">Content Presenter</span> allows your web application to display documents from Oracle <span style="font-weight: bold;">UCM </span>(or other repositories) using the advantages that UCM provides: document conversions, workflow revisions or <span style="font-weight: bold;">security </span>layer.<br /></span><br /><span>This last one is a important point to take care because the web application's security <span style="font-weight: bold;">permissions</span> will be based on the configuration between the Content Server and Webcenter. For this reason, a summary of how to <span style="font-weight: bold;">check </span>and <span style="font-weight: bold;">troubleshoot </span>your configuration is explained in the section below:<br /><br />In the example, you are going to grant write permission to user Bob who is a contributor in the web application and has the role PersonalSpacesRole. This role is defined for users who will interact with the Content Server. You are going to grant permissions to any folder created with security group "public".<br /><br />You can follow the official documentation to create these users, roles and security groups: <a href="http://download.oracle.com/docs/cd/E17904_01/webcenter.1111/e12405/wcadm_documents.htm#CIHFHAAD">http://download.oracle.com/docs/cd/E17904_01/webcenter.1111/e12405/wcadm_documents.htm#CIHFHAAD</a><br /><br /><span style="font-weight: bold;">Step-by-step:</span></span><span><br />1) <span style="font-weight: bold;">Login </span>to the Content Server as an administrator user<br />2) In the administration tab, open <span style="font-weight: bold;">Admin Applets</span><br />3) Click on <span style="font-weight: bold;">User Admin</span><br />4) Click on Security menu and select <span style="font-weight: bold;">Permissions by Role</span> option<br />5) Select the webcenter user <span style="font-weight: bold;">role </span>(in the example PersonalSpacesRole) and select the security <span style="font-weight: bold;">group </span>you want to grant permissions (in the example Public)<br />6) Click on <span style="font-weight: bold;">Edit Permissions</span> </span><span>button and update the values.<br />7) Now, all the users with the PersonalSpacesRole should be able to edit documents in any Public folder<br /><br /><br /></span><div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBsZRJSwQBAn9_bAU6TgOdvYvPhggcvALatHqk9yXPonmnNIWqqkAhcXqZvpwB3K211C_C987G4lXSIpdUpBEOIbZ61ryjiqip7yzS5NaaenqzDehSDe9fwYNDwADfvj6BW1h96cPKH9g/s1600/1.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer; width: 374px; height: 135px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBsZRJSwQBAn9_bAU6TgOdvYvPhggcvALatHqk9yXPonmnNIWqqkAhcXqZvpwB3K211C_C987G4lXSIpdUpBEOIbZ61ryjiqip7yzS5NaaenqzDehSDe9fwYNDwADfvj6BW1h96cPKH9g/s320/1.JPG" alt="" id="BLOGGER_PHOTO_ID_5574989574000144130" border="0" /></a><br /></div><span style="font-weight: bold;"><br /><br /><br /><br /><br /><br /><br /><br />Documentation:</span><br /><a href="http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/index.html">Oracle's official documentation for UCM 11g</a><br /><a href="http://www.oracle.com/technetwork/middleware/webcenter/documentation/index.html">Oracle's official documentation for Webcenter Spaces</a><br /><br /><span style="font-weight: bold;">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/middleware/content-management/downloads/index-085241.html">Oracle UCM 11g</a><br /><a href="http://www.oracle.com/technetwork/middleware/webcenter/downloads/index.html">Oracle Webcenter 11g</a><br /><span style="font-weight: bold;"><br /></span>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com1tag:blogger.com,1999:blog-1022940319950810472.post-15049300791071700112011-02-14T02:45:00.000-08:002011-02-14T03:13:08.781-08:00jDeveloper: Connecting UCM as a repository<span>During the development of a web application is important to provide <span style="font-weight: bold;">contents </span>to enrich the portal. Using Oracle <span style="font-weight: bold;">jDeveloper </span>11g you can easily create a connection to any content repository which will allow you to <span style="font-weight: bold;">navigate </span>it and <span style="font-weight: bold;">contribute </span>the application with information stored in it.<br /><br />In this example, you are going to create a connection with Oracle <span style="font-weight: bold;">UCM </span>as a main repository and the video will show how to <span style="font-weight: bold;">troubleshoot </span>some connection errors by checking the connection <span style="font-weight: bold;">parameters </span>like the RIDC socket type, hostname or listening port...<br /></span><span style="font-weight: bold;"><br />Documentation:</span><br /><a href="http://www.oracle.com/technetwork/developer-tools/jdev/documentation/index.html">Oracle's official documentation for jDeveloper 11g</a><br /><br /><span style="font-weight: bold;">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html">Oracle jDeveloper 11g</a><br /><br /><span style="font-weight: bold;">Viewlet:</span><br />(Duration: 2 min.)<br /><iframe src="http://www.youtube.com/embed/RXv3-AUWaZY?fs=1" allowfullscreen="" width="480" frameborder="0" height="295"></iframe>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-23152228644330331052011-02-10T03:36:00.000-08:002011-02-14T03:13:18.561-08:00jDeveloper: How to deploy an application to an external WebLogic Server<span style="font-weight: bold;"><span style="font-weight: bold;"></span></span><span>Oracle <span style="font-weight: bold;">jDeveloper </span>has an integrated <span style="font-weight: bold;">WebLogic Server</span> to test and debug applications locally, but you can also <span style="font-weight: bold;">deploy </span>it to an <span style="font-weight: bold;">external </span>server. <span style="font-weight: bold;"></span></span><span style="font-weight: bold;"><span style="font-weight: bold;"></span></span><span>To do this, you must create a connection with a WebLogic domain and a deployment profile as the <span style="font-weight: bold;">viewlet </span>shows below.<br /></span><span style="font-weight: bold;"><br />Documentation:</span><br /><a href="http://www.oracle.com/technetwork/developer-tools/jdev/documentation/index.html">Oracle's official documentation for jDeveloper 11g</a><br /><br /><span style="font-weight: bold;">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html">Oracle jDeveloper 11g</a><br /><br /><span style="font-weight: bold;">Viewlet:</span><br />(Duration: 2 min.)<br /><iframe src="http://www.youtube.com/embed/8C0nJgs6s7M?fs=1" allowfullscreen="" width="480" frameborder="0" height="295"></iframe>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com2tag:blogger.com,1999:blog-1022940319950810472.post-90789958683039639242011-02-09T01:16:00.000-08:002011-02-14T03:13:30.391-08:00UCM: Managing video conversions and filters with FlipFactory<span style="font-weight: bold;"><span style="font-weight: bold;"><span style="font-weight: bold;"><span style="font-weight: bold;"></span></span></span></span>As you know, Oracle Universal Content Management (<span style="font-weight: bold;">UCM</span>) allows you to store video files and transform them into other video file with different format and resolution. Through the <span style="font-weight: bold;">FlipFactory </span>admin console, a 3rd party conversion module, you can configure <span style="font-weight: bold;">new conversion</span> types where you can choose the output extension, resolution,... or apply <span style="font-weight: bold;">filters </span>like text overlay, saturation, noise reduction...<br /><br />At the end of this post, you can follow a <span style="font-weight: bold;">viewlet </span>explaining the needed steps to configure the Content Server to provide a new conversion type, in this example, a new conversion with .avi output file with a <span style="font-weight: bold;">watermark </span>filter.<br /><span style="font-weight: bold;"><br />Documentation:</span><br /><a href="http://download.oracle.com/docs/cd/E14571_01/ecm.htm">Oracle's official documentation for UCM 11g</a><br /><br /><span style="font-weight: bold;">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/middleware/content-management/downloads/index-085241.html">Oracle ECM suite 11g</a><br /><br /><span style="font-weight: bold;">Viewlet:</span><br />(Duration: 4 min.)<br /><iframe src="http://www.youtube.com/embed/Jd2WjNjhcJ8?fs=1" allowfullscreen="" width="480" frameborder="0" height="295"></iframe>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com2tag:blogger.com,1999:blog-1022940319950810472.post-23386058858574980292011-02-04T02:44:00.000-08:002011-02-04T02:50:08.800-08:00How to delete files older than X days in Windows Batch<span style="font-family: courier new;">In this entry I will explain how to delete files in a Windows environment depending on its age.</span><br /><br /><span style="font-family: courier new;">This task is rather easy in Unix but in Windows (DOS) it gets quite more complicated.</span><br /><br /><span style="font-family: courier new;">Now imagine you have some folders storing all the backups the system does, and now you would like to clean those folders so they just have the last ones.</span><br /><br /><span style="font-family: courier new;">I searched a lot and seems that with normal Batch is almost impossible to do it, and after trying like 3 or 4 different options I found this one to be the best overall.</span><br /><br /><span style="font-family: courier new;">First off, as I already said, with normal batch this task is so complicated, that is why we will use and extra tool called </span><span style="font-weight: bold; font-family: courier new;">Robocopy</span><span style="font-family: courier new;">. This tool is included in the Windows Server 2003 Resource Kit Tools which you can download from here:</span><br /><br /><span style="font-family: courier new;">http://download.microsoft.com/download/8/e/c/8ec3a7d8-05b4-440a-a71e-ca3ee25fe057/rktools.exe</span><br /><br /><span style="font-family: courier new;">Robocopy is a powerful copy command with lots of useful options.</span><br /><br /><span style="font-family: courier new;">Then idea is quite simple: </span><br /><br /><span style="font-family: courier new;">- We will create a temporal folder.</span><br /><span style="font-family: courier new;">- We will move the files we want to delete to that folder.</span><br /><span style="font-family: courier new;">- Finally we will delete the folder created with the files in it.</span><br /><br /><span style="font-family: courier new;">Now on to the code.</span><br /><br /><span style="font-family: courier new;">I will just put the code commenting each line, instead of writing what it does in a not-so-easy-to-understand paragraph.</span><br /><br /><span style="font-weight: bold; font-family: courier new;">* * * * *</span><br /><br /><span style="font-family: courier new;">@ECHO OFF</span><br /><span style="font-family: courier new;">ECHO # Starting...</span><br /><span style="font-family: courier new;">ECHO.</span><br /><br /><span style="font-family: courier new;">REM Setting the log file name</span><br /><span style="font-family: courier new;">SET day=%date:~0,2%</span><br /><span style="font-family: courier new;">SET mon=%date:~3,2%</span><br /><span style="font-family: courier new;">SET year=%date:~6,4%</span><br /><span style="font-family: courier new;">SET logfile_name=clearing_log_%day%-%mon%-%year%</span><br /><br /><span style="font-family: courier new;">REM Writing the first line in the log including the time</span><br /><span style="font-family: courier new;">SET time=%time:~0,5%</span><br /><span style="font-family: courier new;">ECHO # Clearing.bat launched at %time% > %logfile_name%.txt</span><br /><span style="font-family: courier new;">ECHO. >> %logfile_name%.txt</span><br /><br /><span style="font-family: courier new;">REM Program Start</span><br /><br /><span style="font-family: courier new;">REM variables - here just write the paths of the folders you want to clear</span><br /><span style="font-family: courier new;">SET folder_1_path="C:\Documents and Settings\user\Desktop\Folder_1"</span><br /><span style="font-family: courier new;">SET folder_2_path="C:\Documents and Settings\user\Desktop\Folder_2"</span><br /><br /><span style="font-family: courier new;">REM this next variable will be the path of the temporal folder (you can write whatever path you want as it will be deleted)</span><br /><span style="font-family: courier new;">SET path_temp_folder="C:\Documents and Settings\user\Desktop\Justin Bieber"</span><br /><br /><span style="font-family: courier new;">REM first we will check if the folders specified in the path variables exists</span><br /><span style="font-family: courier new;">IF EXIST %folder_1_path% (</span><br /><span style="font-family: courier new;"> GOTO folder_1_exists</span><br /><span style="font-family: courier new;">) ELSE (</span><br /><span style="font-family: courier new;"> ECHO [ERROR] The folder 1 does not exist.</span><br /><span style="font-family: courier new;"> ECHO [ERROR] The folder 1 does not exist. >> %logfile_name%.txt</span><br /><span style="font-family: courier new;"> GOTO final</span><br /><span style="font-family: courier new;">)</span><br /><br /><span style="font-family: courier new;">:folder_1_exists</span><br /><span style="font-family: courier new;">REM now we check if the second folder exists</span><br /><span style="font-family: courier new;">IF EXIST %folder_2_path% (</span><br /><span style="font-family: courier new;"> GOTO folder_2_exists</span><br /><span style="font-family: courier new;">) ELSE (</span><br /><span style="font-family: courier new;"> ECHO [ERROR] The folder 2 does not exist.</span><br /><span style="font-family: courier new;"> ECHO [ERROR] The folder 2 does not exist. >> %logfile_name%.txt</span><br /><span style="font-family: courier new;"> GOTO final</span><br /><span style="font-family: courier new;">)</span><br /><br /><span style="font-family: courier new;">:folder_2_exists</span><br /><span style="font-family: courier new;">REM now we will delete the files in the first folder</span><br /><br /><span style="font-family: courier new;">REM first we create the temporal folder</span><br /><span style="font-family: courier new;">MKDIR %path_temp_folder%</span><br /><br /><span style="font-family: courier new;">REM now we move the files older than X (in this case 7) days to that folder</span><br /><span style="font-family: courier new;">ROBOCOPY %folder_1_path% %path_temp_folder% /move /minage:7 >nul</span><br /><span style="font-family: courier new;">REM ROBOCOPY syntax = source destination [file [file]…] [options]</span><br /><br /><span style="font-family: courier new;">REM and finally as stated we delete the temporal folder</span><br /><span style="font-family: courier new;">RMDIR %path_temp_folder% /s /q</span><br /><br /><span style="font-family: courier new;">ECHO Folder 1 cleaned.</span><br /><span style="font-family: courier new;">ECHO Folder 1 cleaned. >> %logfile_name%.txt</span><br /><br /><span style="font-family: courier new;">GOTO clear_1_done</span><br /><br /><span style="font-family: courier new;">:clear_1_done</span><br /><span style="font-family: courier new;">REM now we will delete the files in the second folder</span><br /><br /><span style="font-family: courier new;">REM first we create the temporal folder</span><br /><span style="font-family: courier new;">MKDIR %path_temp_folder%</span><br /><br /><span style="font-family: courier new;">REM now we move the files older than X (in this second case 3) days to that folder</span><br /><span style="font-family: courier new;">ROBOCOPY %folder_2_path% %path_temp_folder% /move /minage:3 >nul</span><br /><span style="font-family: courier new;">REM ROBOCOPY syntax = source destination [file [file]…] [options]</span><br /><br /><span style="font-family: courier new;">REM and finally as stated we delete the temporal folder</span><br /><span style="font-family: courier new;">RMDIR %path_temp_folder% /s /q</span><br /><br /><span style="font-family: courier new;">ECHO Folder 2 cleaned.</span><br /><span style="font-family: courier new;">ECHO Folder 2 cleaned. >> %logfile_name%.txt</span><br /><br /><span style="font-family: courier new;">GOTO final</span><br /><br /><span style="font-family: courier new;">:final</span><br /><span style="font-family: courier new;">ECHO.</span><br /><span style="font-family: courier new;">ECHO # Done.</span><br /><span style="font-family: courier new;">ECHO. >> %logfile_name%.txt</span><br /><span style="font-family: courier new;">ECHO # Done. >> %logfile_name%.txt</span><br /><span style="font-family: courier new;">ECHO # Log file = %logfile_name%.txt</span><br /><span style="font-family: courier new;">ECHO # Press any key to exit.</span><br /><span style="font-family: courier new;">PAUSE>NUL</span><br /><br /><span style="font-style: italic; font-family: courier new;">* * * * *</span><br /><br /><span style="font-family: courier new;">That's it. </span><br /><span style="font-family: courier new;">Just create and new .bat file, copy the code above, modify it (paths, older days...etc) to match your goals and </span><span style="font-style: italic; font-family: courier new;">voilà</span><span style="font-family: courier new;"> ;)</span><br /><br /><span style="font-family: courier new;">Hope it helps.</span>Marc Campshttp://www.blogger.com/profile/11294720781311196336noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-48492653581639306562011-01-18T03:45:00.000-08:002011-02-01T05:14:54.963-08:00How to get traces in apex automatically (in all the pages)We know that adding ?p_trace=YES to the APEX URL generates SQL Trace information for the page for the current session.. This is very useful when the problem is located in few places. However, sometimes the performance problem seems to be random, it happens in different website pages or it may be difficult to reproduce. For these cases, the above solution is not valid.<br /><br />What we need is to generate traces automatically for the entire website (like adding ?p_trace=YES in all the url pages but automatically).<br /><br />Our solution is to create a new process (on load - before header) in the home of our website. This process executes:<span style="font-style: italic;"></span><br /><blockquote></blockquote> <span style="font-style: italic;">execute immediate 'alter session set sql_trace=true';</span><blockquote></blockquote>To create the process the steps are:<br /><ol><li> In apex, go to the Edit page of the page that will execute the process</li><li> In the Processes section, click the Create new Process icon.</li><li> Select PL/SQL and click next</li><li> Type the name of the process and select "On Load - Before Header" in the Point LOV and click next.</li><li> Type: execute immediate 'alter session set sql_trace=true';</li><li> Click Create Process</li></ol>Once it is done, every time the user loads a web page the trace is generated automatically. Not only in the home but in all the pages that the user visits. When the problem is reproduced we are sure that the trace has been generated in the directory pointed by the <span style="font-style: italic;">user_demp_dest</span> parameter. Remember to delete the process when you solve the problem.<br /><br />We need to grant to the parsing schema of our application the privilege to alter the session with the following command:<br /><br /> <span style="font-style: italic;">grant alter session to parsing_schema</span><br /> <br />You can find the parsing schema your application is using in apex:<br /><br /> <span style="font-style: italic;">Home > Application Builder > Application number > Shared Components > Edit Security Attributes<br /><br /><br /></span>Carlos Molinahttp://www.blogger.com/profile/17627289867407495390noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-13931465208084326412010-12-03T03:41:00.000-08:002010-12-10T02:57:35.439-08:00Advanced Compression in Oracle Database 11g<meta equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 12"><meta name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cmcamps%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5Cmcamps%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5Cmcamps%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><!--[if gte mso 9]><xml> <w:worddocument> <w:view>Normal</w:View> <w:zoom>0</w:Zoom> <w:trackmoves/> <w:trackformatting/> <w:hyphenationzone>21</w:HyphenationZone> <w:punctuationkerning/> <w:validateagainstschemas/> <w:saveifxmlinvalid>false</w:SaveIfXMLInvalid> <w:ignoremixedcontent>false</w:IgnoreMixedContent> <w:alwaysshowplaceholdertext>false</w:AlwaysShowPlaceholderText> <w:donotpromoteqf/> <w:lidthemeother>ES</w:LidThemeOther> <w:lidthemeasian>X-NONE</w:LidThemeAsian> <w:lidthemecomplexscript>X-NONE</w:LidThemeComplexScript> <w:compatibility> <w:breakwrappedtables/> <w:snaptogridincell/> <w:wraptextwithpunct/> <w:useasianbreakrules/> <w:dontgrowautofit/> <w:splitpgbreakandparamark/> <w:dontvertaligncellwithsp/> <w:dontbreakconstrainedforcedtables/> <w:dontvertalignintxbx/> <w:word11kerningpairs/> <w:cachedcolbalance/> <w:usefelayout/> </w:Compatibility> <w:donotoptimizeforbrowser/> <m:mathpr> <m:mathfont val="Cambria Math"> <m:brkbin val="before"> <m:brkbinsub val="--"> <m:smallfrac val="off"> <m:dispdef/> <m:lmargin val="0"> <m:rmargin val="0"> <m:defjc val="centerGroup"> <m:wrapindent val="1440"> <m:intlim val="subSup"> <m:narylim val="undOvr"> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:latentstyles deflockedstate="false" defunhidewhenused="true" defsemihidden="true" defqformat="false" defpriority="99" latentstylecount="267"> <w:lsdexception locked="false" priority="0" semihidden="false" unhidewhenused="false" qformat="true" name="Normal"> <w:lsdexception locked="false" priority="9" semihidden="false" unhidewhenused="false" qformat="true" name="heading 1"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 2"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 3"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 4"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 5"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 6"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 7"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 8"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 9"> <w:lsdexception locked="false" priority="39" name="toc 1"> <w:lsdexception locked="false" priority="39" name="toc 2"> <w:lsdexception locked="false" priority="39" name="toc 3"> <w:lsdexception locked="false" priority="39" name="toc 4"> <w:lsdexception locked="false" priority="39" name="toc 5"> <w:lsdexception locked="false" priority="39" name="toc 6"> <w:lsdexception locked="false" priority="39" name="toc 7"> <w:lsdexception locked="false" priority="39" name="toc 8"> <w:lsdexception locked="false" priority="39" name="toc 9"> <w:lsdexception locked="false" priority="35" qformat="true" name="caption"> <w:lsdexception locked="false" priority="10" semihidden="false" unhidewhenused="false" qformat="true" name="Title"> <w:lsdexception locked="false" priority="1" name="Default Paragraph Font"> <w:lsdexception locked="false" priority="11" semihidden="false" unhidewhenused="false" qformat="true" name="Subtitle"> <w:lsdexception locked="false" priority="22" semihidden="false" unhidewhenused="false" qformat="true" name="Strong"> <w:lsdexception locked="false" priority="20" semihidden="false" unhidewhenused="false" qformat="true" name="Emphasis"> <w:lsdexception locked="false" priority="59" semihidden="false" unhidewhenused="false" name="Table Grid"> <w:lsdexception locked="false" unhidewhenused="false" name="Placeholder Text"> <w:lsdexception locked="false" priority="1" semihidden="false" unhidewhenused="false" qformat="true" name="No Spacing"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 1"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 1"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 1"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 1"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 1"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 1"> <w:lsdexception locked="false" unhidewhenused="false" name="Revision"> <w:lsdexception locked="false" priority="34" semihidden="false" unhidewhenused="false" qformat="true" name="List Paragraph"> <w:lsdexception locked="false" priority="29" semihidden="false" unhidewhenused="false" qformat="true" name="Quote"> <w:lsdexception locked="false" priority="30" semihidden="false" unhidewhenused="false" qformat="true" name="Intense Quote"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 1"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 1"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 1"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 1"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 1"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 1"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 1"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 1"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 2"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 2"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 2"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 2"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 2"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 2"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 2"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 2"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 2"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 2"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 2"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 2"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 2"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 2"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 3"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 3"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 3"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 3"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 3"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 3"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 3"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 3"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 3"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 3"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 3"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 3"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 3"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 3"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 4"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 4"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 4"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 4"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 4"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 4"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 4"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 4"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 4"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 4"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 4"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 4"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 4"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 4"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 5"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 5"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 5"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 5"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 5"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 5"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 5"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 5"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 5"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 5"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 5"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 5"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 5"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 5"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 6"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 6"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 6"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 6"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 6"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 6"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 6"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 6"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 6"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 6"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 6"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 6"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 6"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 6"> <w:lsdexception locked="false" priority="19" semihidden="false" unhidewhenused="false" qformat="true" name="Subtle Emphasis"> <w:lsdexception locked="false" priority="21" semihidden="false" unhidewhenused="false" qformat="true" name="Intense Emphasis"> <w:lsdexception locked="false" priority="31" semihidden="false" unhidewhenused="false" qformat="true" name="Subtle Reference"> <w:lsdexception locked="false" priority="32" semihidden="false" unhidewhenused="false" qformat="true" name="Intense Reference"> <w:lsdexception locked="false" priority="33" semihidden="false" unhidewhenused="false" qformat="true" name="Book Title"> <w:lsdexception locked="false" priority="37" name="Bibliography"> <w:lsdexception locked="false" priority="39" qformat="true" name="TOC Heading"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:SimSun; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:宋体; mso-font-charset:134; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:1 135135232 16 0 262144 0;} @font-face {font-family:Mangal; panose-1:0 0 4 0 0 0 0 0 0 0; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:32771 0 0 0 1 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:"\@SimSun"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-hyphenate:none; text-autospace:ideograph-other; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:SimSun; mso-bidi-font-family:Mangal; mso-font-kerning:1.5pt; mso-fareast-language:ZH-CN; mso-bidi-language:HI;} p.Standard, li.Standard, div.Standard {mso-style-name:Standard; mso-style-unhide:no; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-hyphenate:none; text-autospace:ideograph-other; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:SimSun; mso-bidi-font-family:Mangal; mso-font-kerning:1.5pt; mso-fareast-language:ZH-CN; mso-bidi-language:HI;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:12.0pt; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; mso-fareast-font-family:SimSun; mso-bidi-font-family:Mangal; mso-font-kerning:1.5pt; mso-fareast-language:ZH-CN; mso-bidi-language:HI;} .MsoPapDefault {mso-style-type:export-only; mso-pagination:none; text-autospace:ideograph-other;} @page WordSection1 {size:595.3pt 841.9pt; margin:2.0cm 2.0cm 2.0cm 2.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:none; text-autospace:ideograph-other; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Oracle database release 11g introduced a new type of compression called ”Advanced Compression”. </span><span style="" lang="EN-US">This option provides multiple features including OLTP table compression.</span></p><p class="Standard" style="font-family:verdana;">
<br /><span style="" lang="EN-US"> <o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">So, let’s test out this new feature.<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">First of all, we are going to create 3 new tables: <o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">nocomp – table without compression<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">basiccomp – basic compression<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><span>oltpcomp – advanced compression</span><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /><span style=""> </span><span style="font-size:100%;"><i><code>create table nocomp (a int, b char(30), c date);
<br />
<br /><span style=""> </span>create table basiccomp (a int, b char(30), c date) compress;
<br />
<br /><span style=""> </span>create table oltpcomp (a int, b char(30), c date) compress for oltp;</code></i></span>
<br /><!--[if !supportLineBreakNewLine]-->
<br /><!--[endif]--><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Now we check its creation.
<br /><!--[if !supportLineBreakNewLine]-->
<br /><!--[endif]--><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><span style=""> </span><span style="font-size:100%;"><i><code>select table_name,compression,compress_for from user_tables where table_name in <span style=""> </span>('NOCOMP','BASICCOMP', 'OLTPCOMP');</code></i></span><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><u><span style="" lang="EN-US">
<br /></span></u></p><p class="Standard" style="font-family:verdana;"><u><span style="" lang="EN-US">TABLE_NAME<span style=""> </span>COMPRESS <span style=""> </span>COMPRESS_FOR<o:p></o:p></span></u></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">NOCOMP<span style=""> </span>DISABLED<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">BASICCOMP<span style=""> </span>ENABLED <span style=""> </span>BASIC<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">OLTPCOMP<span style=""> </span>ENABLED<span style=""> </span>OLTP</span></p><p class="Standard" style="font-family:verdana;">
<br /><span style="" lang="EN-US"><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Next we add 500.000 rows with some kind of repetition so we can use the compression.</span><span style="" lang="EN-US"><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Previously to the inserts, we execute the followings commands so we can start checking the times for each operation plus some other execution information:<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><span style=""> </span><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><span style=""> </span></span></b><i><span style="" lang="EN-US">
<br /></span></i></p><p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>set timing on</code></span></i></span><span lang="EN-US" style="font-size:100%;"><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><span style="font-size:100%;"> </span><span style="font-size:100%;"><code>set autotr on</code></span><o:p></o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Now the insertions:<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><span style=""> </span></span></b><i><span style="" lang="EN-US">
<br /></span></i></p><p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><code></code></span></i><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>insert into nocomp select rownum , chr(64+trunc(dbms_random.value(1,3))), <span style=""> </span>trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 500000;</code></span></i></span><span style="" lang="EN-US"><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><span style=""> </span><o:p></o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><span style=""> </span>
<br /></span></i></p><p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><span style="font-size:100%;"><code>insert into basiccomp select rownum , chr(64+trunc(dbms_random.value(1,3))), <span style=""> </span>trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 500000;</code></span><o:p></o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US">
<br /><span style=""> </span><span style="font-size:100%;"><code>insert into oltpcomp select rownum , chr(64+trunc(dbms_random.value(1,3))), <span style=""> </span>trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 500000;</code></span></span></i></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><u><span style="" lang="EN-US">
<br /></span></u></p><p class="Standard" style="text-indent: 35.45pt;font-family:verdana;"><u>Result Times</u>:
<br /></p> <p class="Standard" style="text-indent: 35.45pt;font-family:verdana;">nocomp = 11.29 s
<br /></p> <p class="Standard" style="text-indent: 35.45pt;font-family:verdana;">basiccomp = 13.57 s</p> <p class="Standard" style="text-indent: 35.45pt;font-family:verdana;">oltpcomp = 22.36 s</p><p class="Standard" style="font-family:verdana;">
<br /><span style="" lang="EN-US"><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">As we can see, insertions with OLTP compression are slower. <o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></p> <p class="Standard" style="font-family:verdana;">
<br /></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Also, we can see that the table with OLTP compression uses a lot more redo than the other two.<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><span><u>Redo size</u></span><u></u> = 28M8 / 28M7 / 95M1<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US">
<br /></span></b></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">But, let’s see how the pure data compression go.</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><span style=""> </span><o:p></o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US">
<br /></span></i><i><span style="" lang="EN-US"><code></code></span></i><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>select segment_name,round(bytes/1024/1024,2) Mb from user_segments where segment_name in (‘NOCOMP’,’BASICCOMP’,’OLTPCOMP’);</code></span></i></span><span style="" lang="EN-US"><o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US">
<br /></span></b></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">SEGMENT_NAME<span style=""> </span>MB<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">----------------------------------<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">NOCOMP<span style=""> </span>27<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">BASICCOMP<span style=""> </span>24<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">OLTPCOMP<span style=""> </span>8</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">As we can see the OLTP compression almost compressed the data by 1/3.<o:p></o:p></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US">
<br /></span></b></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">OLTP Compression is slower and uses more redo but its compression is quite impressive.</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US">
<br /></span></b></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Next we are going to do the same experiments but this time with direct inserts.</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p><p class="Standard" style="margin-left: 35.45pt;font-family:verdana;"><i><span style="" lang="EN-US">
<br /></span></i></p><p class="Standard" style="margin-left: 35.45pt;font-family:verdana;"><i><span style="" lang="EN-US"><code></code></span></i><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>insert /*+ APPEND */ into nocomp select rownum , chr(64+trunc(dbms_random.value(1,3))),trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 500000;</code><o:p></o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><span style=""> </span>
<br /></span></i></span></p><p class="Standard" style="text-indent: 35.45pt;font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>insert /*+ APPEND */ into basiccomp select rownum, chr(64+trunc(dbms_random.value(1,3))),trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 500000;</code><o:p></o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><span style=""> </span>
<br /></span></i></span></p> <p class="Standard" style="text-indent: 35.45pt;font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>insert /*+ APPEND */ into oltpcomp select rownum ,chr(64+trunc(dbms_random.value(1,3))),<o:p></o:p>trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 500000;</code><o:p></o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><span style=""> </span>
<br /></span></i></span></p><p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>select segment_name,blocks,round(bytes/1024/1024,2) Mb from user_segments where <span style=""> </span>segment_name in (‘NOCOMP’,’BASICCOMP’,’OLTPCOMP’);</code></span></i></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;"></p><p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;">
<br /></p><p class="Standard" style="text-indent: 35.45pt;font-family:verdana;"><u>Results for Time and Space</u>:
<br /></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;">nocomp = 11.23 s / 24 MB
<br /></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;">basiccomp = 11.40 s / 7 MB
<br /></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;">oltpcomp = 11.32 s / 7 MB
<br /></p><p class="Standard" face="verdana" style="text-indent: 35.45pt;">
<br /></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">With direct inserts, the times for the insertions are almost the same, but the two tables with some kind of compression use equally 1/3 of the space.</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US">
<br /></span></b></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Finally, we are going to test how the different tables behave respect update and select operations.</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US">
<br /></span></b></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">First though, we increase the number of inserted rows from 500.000 to 2 milions.</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;"><b><span style="" lang="EN-US">
<br /></span></b></p><p class="Standard" face="verdana" style="text-indent: 35.45pt;"><span style="" lang="EN-US">(delete the tables and create new ones)</span><b><span style="" lang="EN-US"><o:p></o:p></span></b></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;"><i><span style="" lang="EN-US"><o:p> </o:p></span></i>
<br /></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;"><i><span style="" lang="EN-US"><code></code></span></i><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>insert into nocomp select rownum , chr(64+trunc(dbms_random.value(1,3))),trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 2000000;</code><o:p></o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><b><span style="" lang="EN-US"><span style=""> </span><o:p></o:p></span></b></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><span style=""> </span>
<br /></span></i></span></p><p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>insert into basiccomp select rownum , chr(64+trunc(dbms_random.value(1,3))), <span style=""> </span>trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 2000000;</code><o:p></o:p></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><span style="" lang="EN-US">
<br /><span style=""> </span><code>insert into oltpcomp select rownum , chr(64+trunc(dbms_random.value(1,3))), <span style=""> </span>trunc(sysdate)+trunc(dbms_random.value(1,10)) from dual connect by rownum <= 2000000;</code></span></i></span></p> <p class="Standard" style="font-family:verdana;"><b><span style="" lang="EN-US"><o:p> </o:p></span></b></p> <p class="Standard" style="font-family:verdana;">
<br /></p><p class="Standard" face="verdana" style="text-indent: 35.45pt;"><u>Times for the insertions</u>:
<br /></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;">nocomp = 48 s
<br /></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;">basiccomp = 51s</p> <p class="Standard" face="verdana" style="text-indent: 35.45pt;">oltpcomp = 1 m 25 s</p><span lang="EN-US" style="font-family:verdana;"><o:p></o:p></span> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US">
<br /></span></i></p><p class="Standard" style="font-family:verdana;"><i><span style="" lang="EN-US"><code></code></span></i><span style="font-size:100%;"><i><span style="" lang="EN-US"><code>select segment_name,blocks,round(bytes/1024/1024,2) Mb from user_segments where segment_name in (‘NOCOMP’,’BASICCOMP’,’OLTPCOMP’);</code></span></i></span></p> <p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p> </o:p></span></p> <p class="Standard" style="font-family:verdana;">
<br /></p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;font-family:verdana;"><u>Space used per table</u>:
<br /></p> <p class="Standard" style="text-indent: 35.45pt; font-family: verdana;font-family:verdana;">nocomp = 112 MB</p> <p class="Standard" face="verdana" style="text-indent: 35.45pt; font-family: verdana;">basiccomp = 104 MB</p> <p class="Standard" face="verdana" style="text-indent: 35.45pt; font-family: verdana;">oltpcomp = 31 MB</p><span lang="EN-US" style="font-family:verdana;"><u><o:p></o:p></u></span><u style="font-family: verdana;"> </u><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><span style=""><u> </u></span><o:p></o:p></span></p><u style="font-family: verdana;"> </u><p class="Standard" style="font-family:verdana;">
<br /></p><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US">Once checek the time and space, we focus on the selects and updates:
<br /></span></p><u style="font-family: verdana;"> </u><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><span style=""><u> </u></span><o:p></o:p></span></p><u style="font-family: verdana;"> </u><p class="Standard" style="font-family:verdana;">
<br /><span style="" lang="EN-US"><span style=""><u> </u></span></span></p><p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><code>select a from nocomp where b='A' and a>200000 and a<300000;</code></i></span></p><p class="Standard" style="font-family:verdana;"><span style="font-size:100%;"><i><code>select a from basiccomp where b='A' and a>200000 and a<300000;</code></i></span></p><p face="verdana" class="Standard"><span style="font-size:100%;"><i><code>select a from oltpcomp where b='A' and a>200000 and a<300000;</code></i></span></p><u style="font-family: verdana;"><i></i></u><u style="font-family: verdana;"><i><code></code></i></u><u style="font-family: verdana;"> </u><p face="verdana" class="Standard"><u><i><span style="" lang="EN-US"><o:p> </o:p></span></i></u></p><u style="font-family: verdana;"> </u><p class="Standard" face="verdana" style="text-indent: 35.45pt; font-family: verdana;"><span style="text-decoration: underline;">
<br /></span></p><p class="Standard" face="verdana" style="text-indent: 35.45pt; font-family: verdana;"><span style="font-size:100%;"><u>Times</u>:</span></p> <p class="Standard" face="verdana" style="text-indent: 35.45pt; font-family: verdana;">nocomp = 22.28 s</p> <p class="Standard" style="text-indent: 35.45pt; font-family: verdana;">basiccomp = 22.67 s</p> <p class="Standard" style="text-indent: 35.45pt; font-family: verdana;">oltpcomp = 21.64 s</p><u style="font-family: verdana;"> </u><p class="Standard" style="font-family:verdana;"><span style="" lang="EN-US"><o:p><u> </u></o:p></span></p><u style="font-family: verdana;"> </u><p class="Standard" face="verdana"><span style="" lang="EN-US"><span style=""></span><i>
<br /></i></span></p><p class="Standard" face="verdana"><span style="" lang="EN-US"><o:p></o:p></span></p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;"><i><span style="" lang="EN-US"><code></code></span></i><span style="font-size:100%;"><i><code>update nocomp set b='C' where b='B' and rownum <= 200000;</code></i></span></p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;"><span style="font-size:100%;"><i><code>update basiccomp set b='C' where b='B' and rownum <= 200000;</code></i></span></p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;"><span style="font-size:100%;"><i><code>update oltpcomp set b='C' where b='B' and rownum <= 200000;</code></i></span></p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;"><span style="" lang="EN-US"><u>
<br /></u></span></p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;"><span style="font-size:100%;"><u>Times</u>:</span>
<br /></p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;">nocomp = 5 s</p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;">basiccomp = 10 s</p><p class="Standard" style="text-indent: 35.45pt; font-family: verdana;">oltpcomp = 1 m 10 s
<br /><span style="" lang="EN-US"><u><o:p></o:p></u></span></p><p class="Standard" style="font-family: verdana;"><span style="" lang="EN-US"><span style=""> </span><o:p></o:p></span></p><p class="Standard" style="font-family: verdana;"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" style="font-family: verdana;"><span style="" lang="EN-US">As we can see, both the inserts and especially the updates are slower with oltp compression but on the other hand, the selects take the same time and it uses much less space.<o:p></o:p></span></p> <p class="Standard" style="font-family: verdana;"><span style="" lang="EN-US"><o:p><u> </u></o:p></span></p> <p class="Standard" style="font-family: verdana;">
<br /></p><p class="Standard" style="font-family: verdana;">That's it. Thanks for reading.
<br /></p><p class="Standard" face="verdana"><span style="" lang="EN-US">
<br /></span></p><p class="Standard" face="verdana"><span style="" lang="EN-US"></span></p><p class="Standard"><span style=";font-family:";" lang="EN-US"><span style="font-family:verdana;">(We might test LOBs compression in the near future.)</span><o:p></o:p></span></p>Marc Campshttp://www.blogger.com/profile/11294720781311196336noreply@blogger.com1tag:blogger.com,1999:blog-1022940319950810472.post-56711845718217598722010-11-26T01:10:00.000-08:002011-02-14T03:13:46.020-08:00UCM: Creating search and check-in profiles with custom metadataTo enhance the experience with Oracle Universal Content Management (<span style="font-weight: bold;">UCM</span>), users and clients create <span style="font-weight: bold;">search </span>and <span style="font-weight: bold;">check-in</span> profiles and, this way, they can adapt the Content Server to their business requirements.<br />To take full advantage of content management is essential to define what type of documents will be searched or checked-in on the system, defining and creating, in turn, new associated <span style="font-weight: bold;">metadata</span>.<br /><br />Then, you can see a <span style="font-weight: bold;">viewlet </span>showing how to create new profiles and new metadata in Oracle <span style="font-weight: bold;">UCM</span>. The example shows how to add the new <span style="font-weight: bold;">category </span>"Training Documents" which has two new metadata fields, a simple type that contains the name of the instructor and other drop-down list with the type of training (presencial, online, self-study...).<br /><br /><span style="font-weight: bold;">Documentation:</span><br /><a href="http://download.oracle.com/docs/cd/E14571_01/ecm.htm">Oracle's official documentation for UCM 11g</a><br /><br /><span style="font-weight: bold;">Downloads:</span><br /><a href="http://www.oracle.com/technetwork/middleware/content-management/downloads/index-085241.html">Oracle ECM suite 11g</a><br /><br /><span style="font-weight: bold;">Viewlet:</span><br />(Duration: 6 min.)<br /><object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/OFJWykOuv3o?fs=1&hl=es_ES&hd=1"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/OFJWykOuv3o?fs=1&hl=es_ES&hd=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed></object>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com3tag:blogger.com,1999:blog-1022940319950810472.post-49922612312488795262010-11-12T01:31:00.000-08:002010-11-16T02:53:12.515-08:00WCM: Deploy new site with Site Studio for External Applications<span class="" id="result_box" lang="en"><span title="">In the latest version of Universal Content Management (<b>UCM</b>) 11g, Oracle improved its solution to web content management (<b>WCM</b>) using the new component Site Studio for External Applications (<b>SSXA</b>), which facilitates the development cost</span><span title=""> connecting it with IDE development tools such as <b>JDeveloper 11g</b> giving the possibility to use the JSP web format.<br />
</span><span title="">On the other hand, it continues keeping the tools <b>Site Studio Designer</b> and <b>Site Studio Contributor</b> of the 10g version.<br />
</span><span title="">In this post, to introduce the product a basic <b>example </b>of a website will be deployed on Weblogic Server 11g. </span><span style="background-color: #ebeff9;" title="">Continue reading this blog for more posts about <b>WCM </b>and how to add contribution areas, navigation menu, breadcrumbs, etc.</span></span><br />
<br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Documentation:</span></span></b><br />
<a href="http://download.oracle.com/docs/cd/E14571_01/ecm.htm"><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Oracle's oficial documentation for ECM 11g</span></span></a><br />
<a href="http://download.oracle.com/docs/cd/E14571_01/doc.1111/e13650/toc.htm"><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Developer's guide for SSXA</span></span></a><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Downloads:</span></span></b><br />
<a href="http://www.oracle.com/technetwork/middleware/content-management/downloads/index-085241.html"><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Oracle ECM 11g suite</span></span></a><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Viewlet:</span></span></b><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">(Duration: 6 min.)</span></span><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<object height="295" style="background-image: url(http://i3.ytimg.com/vi/6QY_C17hSRY/hqdefault.jpg);" width="480"><param name="movie" value="http://www.youtube.com/v/6QY_C17hSRY?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/6QY_C17hSRY?fs=1&hl=es_ES" width="480" height="295" allowScriptAccess="never" allowFullScreen="true" wmode="transparent" type="application/x-shockwave-flash"></embed></object>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com1tag:blogger.com,1999:blog-1022940319950810472.post-90972972652915457792010-11-12T01:30:00.000-08:002010-11-16T02:53:05.623-08:00ODC: Install and configure Oracle Document Capture<span class="" id="result_box" lang="en"><span title="">Oracle offers in its Enterprise Content Management (<b>ECM</b>) suite solutions for the capture and document recognition. </span><span title="">Oracle Document Capture (<b>ODC</b>) 10g is a desktop application designed to <b>capture </b>documents for, later, <b>recognize </b>some areas and metadata and <b>index </b>them against a target repository, which can be a file system, database, <b>Content Server</b> UCM, </span><span title="">etc.<br />
</span><span title="">Oracle Document Capture incorporates other features such as indexing, recognition and import of documents in a customized and programmable <b>batch processes</b>. </span><span title="">It also includes the Oracle Distributed Document Capture (<b>ODDC</b>) technology, an application based on a web interface to scan and index documents in a <b>distributed </b>environment.<br />
</span><span title="">The following summarizes the steps in a Viewlet to <b>install </b>and <b>configure </b>Oracle Document Capture. </span><span title="">This example shows the installation in a single-user, which stores all the configuration information in a local database (Microsoft Access file). </span><span style="background-color: #ebeff9;" title="">Once you followed these steps, the system should be ready to define the scanning and indexing <b>profiles</b>.</span></span><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Documentation:</span></span></b><br />
<a href="http://download.oracle.com/docs/cd/E10316_01/capture.htm"><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Oracle's oficial documentation for ECM 10g</span></span></a><br />
<a href="http://download.oracle.com/docs/cd/E10316_01/capture/odc_install.pdf"><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Installation guide for ODC</span></span></a><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Downloads:</span></span></b><br />
<a href="http://www.oracle.com/technetwork/middleware/content-management/downloads/index-dc-096316.html"><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Oracle ODC and ODDC</span></span></a><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Viewlet:</span></span></b><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">(Duration: 3 min.)</span></span><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<object height="344" width="425"><param name="movie" value="http://www.youtube.com/v/uYC-O0t30gc?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/uYC-O0t30gc?fs=1&hl=es_ES" allowscriptaccess="never" allowfullscreen="true" wmode="transparent" type="application/x-shockwave-flash" width="425" height="344"></embed></object>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com8tag:blogger.com,1999:blog-1022940319950810472.post-48239575970948310252010-11-12T01:29:00.001-08:002010-11-16T02:52:57.715-08:00UCM: Creating advanced folios<span class="" id="result_box" lang="en"><span title="">Through using advanced folios,Oracle Universal Content Management (<b>UCM</b>) is able to organize documents of the Content Server into more complex structures using a <b>hierarchy </b>of folders such as a filesystem.</span><span title="">To create <b>advanced folios</b>, previously must have created a <b>template </b>or use a predefined template into the system. </span><span title="">(See UCM: Creating templates for advanced folios)<br />
</span><span title="">Once the advanced folio is created and the <b>documents </b>are attached, you can apply different <b>retention policies</b> and <b>lock </b>the folio to prevent changes on it, you can continue <b>adding </b>more documents or <b>download</b> the folio in a specific format, as </span><span title="">shown in the following <b>tutorial</b>.</span></span><br />
<br />
<b><span class="" id="result_box" lang="en"><span title="">Links:</span></span></b><br />
<span class="" id="result_box" lang="en"><span title="">UCM: Creating simple folios</span></span><br />
<span class="" id="result_box" lang="en"><span title="">UCM: Creating templates for advanced folios</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span title="">Viewlet:</span></span></b><br />
<span class="" id="result_box" lang="en"><span title="">(Duration: 2.5 min.)</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><br />
<object height="344" style="background-image: url(http://i3.ytimg.com/vi/NGFqflH77H8/hqdefault.jpg);" width="425"><param name="movie" value="http://www.youtube.com/v/NGFqflH77H8?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/NGFqflH77H8?fs=1&hl=es_ES" allowscriptaccess="never" allowfullscreen="true" wmode="transparent" type="application/x-shockwave-flash" width="425" height="344"></embed></object>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-76515593814963700732010-11-12T01:28:00.000-08:002010-11-16T02:52:51.220-08:00UCM: Creating templates for advanced folios<span class="" id="result_box" lang="en"><span title="">The folio feature that Oracle Universal Content Management (<b>UCM</b>) provides, allows you to group content under one structure. </span><span title="">This <b>structure </b>can be a simple structure (a table) then you should use a simple folio or it may be a more complex structure (including a <b>hierarchy tree</b>) using an advanced folio.</span><span title="">Before use an <b>advanced folio</b>, you must create a basic <b>template </b>which can be extended and modified. </span><span style="background-color: #ebeff9;" title="">Here is a tutorial that shows how to create a template for advanced folios.</span></span><br />
<br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Links:</span></span></b><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">UCM: Creating simple folios</span></span><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">UCM: Creating advanced folios</span></span><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">Viewlet:</span></span></b><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title="">(Duration 2 min.)</span></span><br />
<span class="" id="result_box" lang="en"><span style="background-color: #ebeff9;" title=""><br />
</span></span><br />
<object height="344" style="background-image: url(http://i2.ytimg.com/vi/9ZswhfZ0uaU/hqdefault.jpg);" width="425"><param name="movie" value="http://www.youtube.com/v/9ZswhfZ0uaU?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/9ZswhfZ0uaU?fs=1&hl=es_ES" allowscriptaccess="never" allowfullscreen="true" wmode="transparent" type="application/x-shockwave-flash" width="425" height="344"></embed></object>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-71662088238803682002010-11-12T01:27:00.000-08:002010-11-16T02:52:43.021-08:00UCM: Creating simple folios<span class="" id="result_box" lang="en"><span title="">One of the tools offered by Oracle Universal Content Management (<b>UCM</b>) to organize the documents in the Content Server are the <b>folio </b>features. </span><span title="">This tool allows you to group multiple documents into more complex structures and view them as a <b>single document</b>.</span></span><br />
<span class="" id="result_box" lang="en"><span title="">This tutorial shows, through a viewlet, how simple folios work and which operation can be done on it.</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span><span title="">In the case of simple folios, they are organized in a <b>flat structure</b>, such as a table so that all documents are in the same <b>hierarchy level</b>. </span><span title="">It may be noted that once created, you can apply some operations like <b>freezing </b>the folio and its documents, <b>extend </b>to an advanced folio, etc.</span></span><br />
<br />
<b><span class="" id="result_box" lang="en"><span title="">Links:</span></span></b><br />
<span class="" id="result_box" lang="en"><span title="">UCM: Creating advanced folios</span></span><br />
<span class="" id="result_box" lang="en"><span title="">UCM: Creating templates for advanced folios</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span title="">Viewlet:</span></span></b><br />
<span class="" id="result_box" lang="en"><span title="">(Duration: 2 min.)</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><object height="344" width="425"><param name="movie" value="http://www.youtube.com/v/CWBc81lG-88?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/CWBc81lG-88?fs=1&hl=es_ES" allowscriptaccess="never" allowfullscreen="true" wmode="transparent" type="application/x-shockwave-flash" width="425" height="344"></embed></object>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com1tag:blogger.com,1999:blog-1022940319950810472.post-28440115609580712332010-11-12T01:23:00.000-08:002010-11-16T02:52:33.212-08:00HOWTO: Resize or create a new partition in a virtual machine<span class="" id="result_box" lang="en"><span title="">A bad forecast when <b>partitioning </b>a virtual machine can make it useless. </span><span title="">To avoid to install again the operating system, you can use <b>tools </b>to increase the <b>size </b>of partitions or create new ones.</span></span><br />
<br />
<b><span class="" id="result_box" lang="en"><span title="">Prerequisites:</span></span></b><br />
<span class="" id="result_box" lang="en"><span title="">VMware Server or VMware Workstation</span></span><br />
<span class="" id="result_box" lang="en"><span title="">gParted liveCD or liveCD linux distribution with gParted</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span title="">Downloads:</span></span></b><br />
<a href="http://www.vmware.com/"><span class="" id="result_box" lang="en"><span title="">VMware downloads</span></span></a><br />
<a href="http://sourceforge.net/projects/gparted/files/gparted-live-stable/"><span class="" id="result_box" lang="en"><span title="">gParted downloads</span></span></a><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span title="">Step-by-step:</span></span></b><br />
<span class="" id="result_box" lang="en"><span title="">1) Edit the virtual machine in the configuration interface of VMware</span></span><br />
<span class="" id="result_box" lang="en"><span title="">2) In the hardware section, edit the <b>Hard Disk</b> configuration</span></span><br />
<span class="" id="result_box" lang="en"><span title="">3) Click on <b>increase capacity</b> and introduce the new size</span></span><br />
<span class="" id="result_box" lang="en"><span title="">4) In the hardware section, edit the <b>CD/DVD drive</b> configuration </span></span><br />
<span class="" id="result_box" lang="en"><span title="">5) Configure the drive to load the gParted LiveCD <b>image </b>(.iso)</span></span><br />
<span class="" id="result_box" lang="en"><span title="">6) Click on Configure VM to load the BIOS on the next start</span></span><br />
<span class="" id="result_box" lang="en"><span title="">7) Ensure DVD drive is the first <b>boot </b>option. If not, use "+" and "-" keys to change the boot order</span></span><br />
<span class="" id="result_box" lang="en"><span title="">8) Save and exit. gParted LiveCD is going to boot</span></span><br />
<span class="" id="result_box" lang="en"><span title="">9) Use the default configuration or change it if necessary</span></span><br />
<span class="" id="result_box" lang="en"><span title="">10) Once in the graphical mode, you must be able to <b>change </b>an existing partition or <b>create </b>a new. Click the <i>Apply </i>button to commit changes.</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><br />
<b><span class="" id="result_box" lang="en"><span title="">Viewlet:</span></span></b><br />
<span class="" id="result_box" lang="en"><span title="">(Duration: 2 min.)</span></span><br />
<span class="" id="result_box" lang="en"><span title=""><br />
</span></span><object height="344" style="background-image: url(http://i2.ytimg.com/vi/5KP6J6hIl78/hqdefault.jpg);" width="425"><param name="movie" value="http://www.youtube.com/v/5KP6J6hIl78?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/5KP6J6hIl78?fs=1&hl=es_ES" allowscriptaccess="never" allowfullscreen="true" wmode="transparent" type="application/x-shockwave-flash" width="425" height="344"></embed></object>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-85290397008809151322010-11-12T01:22:00.000-08:002010-11-16T02:31:55.860-08:00UCM: Installation of UCM 11g<span class="" id="result_box" lang="en"><span title="">The effectiveness and benefits of <span style="font-weight: bold;">UCM </span>are shown daily in the interest of customers and partners who choose to implement records management in their information systems. </span><span title="">Oracle understands this and for this reason continues promoting its product Oracle Universal Content Management (UCM) and the entire Enterprise Content Management (<span style="font-weight: bold;">ECM</span>) suite to provide solutions.<br />
</span><span title="">Since April 2010, the new version <span style="font-weight: bold;">11g </span>has been released offering more potential than the previous version and has made improvements such as running on the upper layers of the <span style="font-weight: bold;">WebLogic </span>application server.<br />
<br />
</span><span title="">To introduce in the new version, you can see the <span style="font-weight: bold;">installation </span>tutorial of UCM 11g:<br />
<br />
<span style="font-weight: bold;">Downloads:</span><br />
<a href="http://www.oracle.com/technology/software/products/content-management/index.html">ECM Suite and RCU utility</a><br />
<a href="http://www.oracle.com/technology/software/products/middleware/index.html">Weblogic Server</a><br />
<br />
<span style="font-weight: bold;">Documentation:</span><br />
<a href="http://download.oracle.com/docs/cd/E14571_01/ecm.htm">Oracle's oficial documentation for ECM 11g</a><br />
<a href="http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14538/qiecm.htm#sthref10">Quick installation guide for UCM 11g</a><br />
<br />
<span style="font-weight: bold;">Step-by-step:</span><br />
<span style="font-style: italic;">Note: This guide has been installed in a Oracle Enterprise Linux operating system. It can change some step if you are installing on a Windows operating system.</span><br />
<br />
<span style="font-style: italic;">Note: This tutorial assumes that there is an installed Database running on the system. It would be necessary of any supported database to continue with the tutorial.</span><br />
<br />
<span style="font-weight: bold;">1) Preparing the Database</span><br />
1.1) Download and extract the <span style="font-weight: bold;">Repository Creation Utility</span> from the <span style="font-style: italic;">downloads </span>section<br />
1.2) <span style="font-weight: bold;">Execute </span>.../rcuHome/bin/rcu<br />
1.3) An assistant guide will appear and will create the required schemas on the database depending of the selected installation product<br />
<br />
<span style="font-weight: bold;">2) Installation of the Weblogic Application Server</span><br />
2.1) Once the shcema is created, download and extract the <span style="font-weight: bold;">Weblogic Server</span> installer<br />
2.2) <span style="font-weight: bold;">Launch </span>the installer .../wls1033_linux32.bin<br />
2.3) Follow the installation assistant<br />
<br />
<span style="font-weight: bold;">3) Installation of the Fusion Middleware ECM Suite</span><br />
3.1) With the prepared database and the Weblogic Server installed, the next step is the installation of <span style="font-weight: bold;">ECM Suite 11g</span> where, in this case, this tutorial will install only Oracle UCM 11g. Download and extract the ECM Suite<br />
3.2) <span style="font-weight: bold;">Execute </span>.../Disk1/runInstaller<br />
3.3) Follow the installation assistant<br />
<br />
<span style="font-weight: bold;">4) Creating a Weblogic domain</span><br />
4.1) Once all the software is ready, now you must create a <span style="font-weight: bold;">Weblogic domain</span> for UCM<br />
4.2) <span style="font-weight: bold;">Execute </span>./"ECM_ORACLE_HOME"/common/bin/config.sh<br />
4.3) Follow the installer assistant<br />
4.4) <span style="font-weight: bold;">Optimize </span>the JAVA configuration using the command: </span></span><br />
<span style="font-weight: bold;">export USER_MEM_ARGS="-Xms256m -Xmx1024m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=1024m"</span><br />
<br />
<span class="" id="result_box" lang="en"><span title=""><span style="font-weight: bold;">5) Start UCM 11g</span><br />
5.1) Finally UCM 11g is ready to <span style="font-weight: bold;">run</span>!<br />
<br />
<span style="font-weight: bold;">Viewlet:</span><br />
(Duration: 2 min.)<br />
<object height="344" width="425"><param name="movie" value="http://www.youtube.com/v/5hse67bN-Xg?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/5hse67bN-Xg?fs=1&hl=es_ES" allowscriptaccess="never" allowfullscreen="true" wmode="transparent" type="application/x-shockwave-flash" height="344" width="425"></object><br />
<br />
</span></span>Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com9tag:blogger.com,1999:blog-1022940319950810472.post-82953397227972420552010-11-12T01:21:00.000-08:002010-11-16T02:31:55.861-08:00URM: Adding the catalan languageFrom <span style="font-weight: bold;">Oracle </span>Barcelona we continue working to facilitate the implantation of our products to our clients and, given that a lot of them needs it, we offer them the translation to the <span style="font-weight: bold;">catalan</span> language as Oracle does not offers it by default. In this case, an package is attached with all the content translated for Oracle Universal Records Management (<span style="font-weight: bold;">URM</span>) and the necessary steps to enable this language:<br /><br /><span style="font-weight: bold;">Prerequisites</span>:<br />Given that Oracle <span style="font-weight: bold;">URM </span>is based on the Oracle UCM technology, is also required to have it translated. You can follow the catalan <span style="font-weight: bold;">installation guide</span> for UCM 10g in this post:<br /><a href="http://hfolguera.blogspot.com/2010/05/ucm-traduccion-del-producto-al-catalan_26.html">http://hfolguera.blogspot.com/2010/05/ucm-traduccion-del-producto-al-catalan_26.html</a><br /><br /><span style="font-weight: bold;">Downloads</span>:<br /><a href="http://sites.google.com/site/hfolguerasblog/URM_CAT.zip">Catalan translation pack for URM</a><br /><br /><span style="font-weight: bold;">Step-by-step:</span><br />1) <span style="font-weight: bold;">Download </span>the translation pack from the <span style="font-style: italic;">Downloads</span> section. This package already has all the content translated, so no modifications are required<br />2) Make the <span style="font-weight: bold;">ca </span>folder in the directory:<br />"Installation Path"/custom/RM10gR3UiLanguagePack/lang and copy the content of <span style="font-weight: bold;">RMProductStrings </span>in the new folder<br />3) <span style="font-weight: bold;">Restart </span>the Content Server<br />Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-39325154951138312422010-11-12T01:20:00.000-08:002010-11-16T02:31:55.861-08:00UCM: Adding the catalan languageThe philosophy and internationalization of Oracle makes that all of its products have, from the installation, the <font style="font-weight: bold;">most extended languages</font> in the world which is not included the <font style="font-weight: bold;">catalan language</font>.<br />You can read the internationalization capabilities (<font style="font-weight: bold;">I18N</font>) and localization (<font style="font-weight: bold;">L10N</font>) of <font style="font-weight: bold;">UCM</font> in the links below:<br /><a class="moz-txt-link-freetext" href="http://blogs.oracle.com/ecmalerts/2009/11/oracle_content_server_10gr3_lo.html">http://blogs.oracle.com/ecmalerts/2009/11/oracle_content_server_10gr3_lo.html</a><a href="http://blogs.oracle.com/ecmalerts/2009/11/oracle_content_server_10gr3_lo.html"></a><br /><a class="moz-txt-link-freetext" href="http://download.oracle.com/docs/cd/E10316_01/cs/cs_doc_10/documentation/integrator/internat_environments_10en.pdf">http://download.oracle.com/docs/cd/E10316_01/cs/cs_doc_10/documentation/integrator/internat_environments_10en.pdf</a><br /><br />From Oracle Barcelona, we cover the Mediterranean zone where the user interface in catalan if an often petition, specially in the Public Administration sector.<br />This fact, makes that we think that is important to explain the way to <font style="font-weight: bold;">add the catalan language</font> to the Universal Content Management (<font style="font-weight: bold;">UCM</font>) or other languages:<br /><br /><font style="font-weight: bold;">Downloads:</font><br /><a href="http://sites.google.com/site/hfolguerasblog/UCM_CAT.zip">Catalan translation pack for UCM</a><br /><font style="text-decoration: underline;"></font><br /><font style="font-weight: bold;">Step-by-step:</font><br />1) <font style="font-weight: bold;">Download </font>the package with the required files in the Downloads section. This pack already contains all the content translated, then no modification is required.<br />2) Modify the <font style="font-weight: bold;">std_locale.htm</font> file from the directory:<br /> <font style="font-weight: bold;">"Installation Path"/custom/CS10gR3/CoreUpdate/core/resources</font><br /><br /><font style="font-style: italic;">Note: If the UCM installation has some update patch, you must modify the path for the new version, i.e.: CS10gR34CoreUpdate</font><br /><br />Option 1: <font style="font-weight: bold;">Overwrite </font>the std_locale file with the attached in the translation pack.<br />Option 2: <font style="font-weight: bold;">Add </font>the new lines in the configuration tables (The attached std_locale.htm file can help you as a guide)<br /><br />3) Copy the <font style="font-weight: bold;">ca</font> folder in the directory: <font style="font-weight: bold;">"Installation Path"/custom/Localization/lang</font><br />4) Make the folder <font style="font-weight: bold;">ca</font> in the directory: <font style="font-weight: bold;">"Installation Path"/weblayout/resources/lang</font><br />5) <font style="font-weight: bold;">Restart </font>the Content Server<br /><br />Note: You can verify the process through the <font style="font-weight: bold;">System Properties</font> application, in Windows: Start > Programs > Oracle > Oracle Content Server > idc > utilities > System Properties<br />In the <font style="font-weight: bold;">Localization </font>tab should appear the new language as enabled.<br />Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com0tag:blogger.com,1999:blog-1022940319950810472.post-20180380110272978642010-11-12T01:16:00.000-08:002010-11-16T02:31:55.862-08:00UCM: How to create a new skin and layoutThere is the possibility to change the <font style="font-weight: bold;">look & feel</font> in <font style="font-weight: bold;">UCM </font>and, this way, adapt the user interface to any organization that works with this product: changing the logo for its own, modify colors and CSS style, ...<br /><br />Below, you can see a <font style="font-weight: bold;">viewlet </font>showing the necessary steps to create a <font style="font-weight: bold;">new layout</font>. In this example, it copies an <font style="font-weight: bold;">existing template</font> and it modifies some selected elements.<br /><br /><font style="font-style: italic;">Note: This viewlet is based in UCM 10g version</font><br /><br /><font style="font-weight: bold;">Step-by-step:</font><br />1) <font style="font-weight: bold;">Copy </font>any existing layout of the system in <font style="font-weight: bold;">"Installation Path"/weblayout/resources/layouts</font><br />2) <font style="font-weight: bold;">Modify </font>images, CSS style or layout<br />3) Copy the modified layout to the system in <font style="font-weight: bold;">"Installation Path"/weblayout/resources/layouts</font><br />4) <font style="font-weight: bold;">Log-in</font> into the Content Server with an user with administration rights<br />5) Open the <font style="font-weight: bold;">Admin Server</font> (Administration > Admin Server)<br />6) Add the Additional Configuration Variables:<br /> <font style="font-weight: bold;">LegacyScanLayoutsDirForAdditionalLayouts=true</font><br /><font style="font-weight: bold;"> LegacyScanLayoutsDirForAdditionalSkins=true</font><br />7) <font style="font-weight: bold;">Restart </font>the Content Server<br />8) Publish the <font style="font-weight: bold;">static layout</font> (Administration > Actions > Publish static layout files)<br />9) Publish <font style="font-weight: bold;">schema and configuration data</font> (Administration > Actions > Publish schema and configuration data)<br />10) <font style="font-weight: bold;">Done</font>. Log-in with any user and configure the new look & fell in his <font style="font-weight: bold;">profile</font>.<br /><br /><font style="font-weight: bold;">Related Links:</font><br /><a class="moz-txt-link-freetext" href="http://blogs.oracle.com/kyle/2009/08/ucm_custom_skins_and_layouts_a.html">http://blogs.oracle.com/kyle/2009/08/ucm_custom_skins_and_layouts_a.html</a><br /><a class="moz-txt-link-freetext" href="http://www.oracle.com/technology/products/content-management/ucm/samples/CreateLayout.zip">http://www.oracle.com/technology/products/content-management/ucm/samples/CreateLayout.zip</a><br /><a class="moz-txt-link-freetext" href="http://download.oracle.com/docs/cd/E10316_01/cs/cs_doc_10/sdk/modifying_interface/wwhelp/wwhimpl/js/html/wwhelp.htm">http://download.oracle.com/docs/cd/E10316_01/cs/cs_doc_10/sdk/modifying_interface/wwhelp/wwhimpl/js/html/wwhelp.htm<img class="gl_link" alt="Enlace" src="img/blank.gif" border="0"></a><br /><br /><font style="font-weight: bold;">Documentation:</font><br /><a href="http://download.oracle.com/docs/cd/E10316_01/ouc.htm">Oracle's oficial documentation for UCM 10g</a><br /><br /><font style="font-weight: bold;">Viewlet:</font><br />(Duration: 6min - Video comments in spanish)<br /><object style="background-image: url(http://i2.ytimg.com/vi/yL4QCWNOUAg/hqdefault.jpg);" height="344" width="425"><param name="movie" value="http://www.youtube.com/v/yL4QCWNOUAg?fs=1&hl=es_ES"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/yL4QCWNOUAg?fs=1&hl=es_ES" allowscriptaccess="never" allowfullscreen="true" wmode="transparent" type="application/x-shockwave-flash" height="344" width="425"></object><br /><br />Hug Folguerahttp://www.blogger.com/profile/16891561870334884195noreply@blogger.com3