Optimation of Your Oracle Server Services

When your oracle server get a high traffic, what can we do to increase the performance? I do this to solve the problem, maybe you can try it.

#1. Disable useless database services

Sometimes, we have some databases in on computer server. But, is it all used by client? You can check whether some database are not used by client. It means that the services is enabled but it is idle. Of course it makes your oracle server works harder. So, just disabled some useless services.

- Programs, enter your Control Panel
- Select Administrative Tools
- Choose Services

You will find some services that unused and just right click it and select Properties. You can disable it or starts manually.

#2. Uninstall unused software or tools on your server

When you install new tools on your server, it means you add registry, services, and spend harddisk capacity. What is that means? You will get harder work of oracle server. So, it's better if you uninstall some tools occasionally used. What kind of tools you can delete? Text editor or a image editor is rarely needed. Only one text editor need, isn't it? No image editor is not problem because it's oracle server, not image file server. One thing maybe you forget: you should use one sql editor.

#3. Use minimun GUI (Graphical User Interface) on operating system

Like in Windows XP, go to Properties of your computer. Select Advanced tab and choose Performance setting button. There are four radio button and just click the "Adjust for best performance". No wallpaper is also increase your memory performance.

Okey, we will discuss about this in another time. Have a nice troubleshoot click!

Knowing XML (eXtensible Markup Language)

Now we'll learn XML. Before continuing, let's see the overview of this article.

What is it?

XML (eXtensible Markup Language) is a language that allows the programmer to create their own tag. It is similar with HTML (HyperText Markup Language) but we need a parser to manage user defined tag if it's not default tag of XML. XML contains data or text that can be transfered through internet.

Feature

1. Create our own tag so flexible for both data or atribute
2. Multiplatform. You no need to write code anymore when migrating to another operating system.
3. Text based so the bug can be easily found

Node

Root node
node covering all document. In one document, there is only one node.
Element node
part of XML document that contains open tag and close tag.
Attribute node
name and value atribute written in open tag
Text node
contents of element
Comment node
code that won't be executed
Processing Instruction node
command to process XML document began with
Namespace node
namespace declaration

Sintaks

Now, let's make a simple XML file. Write this code and save as test.xml:


and write this to call your defined tag before:



You will find a XML page in browser.

XSLT

(eXtensible Stylesheet Language: Transformation) is development of the XSL. XSL is stylesheet for XML. It translates information from XML so we can see it in the monitor screen. The output can be teks, HTML, or other file type.

Oke, I think it's enough for introduction to XML. In next post, we'll learn about SVG (Scalable Vector Graphic).

Learning Search Engine Optimation

What is SEO?

It's Search Engine Optimation. It's the way to optimize your website to be read by search engine. If you can do this as well as possible, your site will appear in the first page of search result list when someone type keyword int the search engine. Here's some tips and tricks that will optimize your blog or your website:

1. Add your website to search engine. It makes your URL included to the index of searching. For example for Google, go to http://google.com/addurl and add your url here.
2. Add meta tag in your blog or website. Meta tag will be read when search engine like Google find the information through the world. For example:
   

   <meta content='Oracle Database, PHP Web Programming, 
   Open Source Software Tutorial' name='description'/>

3. Add link to your friends blogroll and of course you need to add his url to your blog. It will be increase your authority in the blog search engine like Technorati.

Okey, that's some tips I know. You can explore about search engine optimation further by asking internet too. Have a nice day!

Splitting Oracle Server

There are three four days to deadline for final project of database labwork. But, there're some problems here. One of critical problem is my Oracle Server down for a night. All of user complain to me and I don't know what should I do. I just restart the database service but it doesn't work. I don't sleep for a night again. I try to do another way but it's still failed. Asking some friends doesn't help too. What should I do?

In the next night, I decide to split my Oracle server in laboratory. I find the other Oracle server in other laboratory but I can't import user from my original database. Perhaps it uses Oracle 9g and my lab with 10g. I can't debug for a long time anymore. It's the three days counter down to deadline.

I choose on of the computer in lab although it's very hard to be a server because its RAM only 512MB. But, if I don't split my server, it will be going down with crazy traffic like this. First, I export user in the database. And then install Oracle and create database in new server. Second, create user and importing user from original database. There are 74 groups and I split it become two parts. In original server, there are 50 groups and 24 groups in the new server.

Oho, it's work for two days! Although there is a chaos an hour before deadline. I'm still finding out how to optimize Oracle server and Windows Server 2003 as its operating system. Can somebody help?

PHP to PDF with Oracle Database

I never think that PHP can do this. It's still about my database labwork. Yesterday, I've got a problem with creating a report from PHP. And then I asked my friend, Wima because I had to finish web engine for my application. We have the same project so we divided it into two parts. He made the report and I handled the PHP web engine.

First, a trying to create an excel document from PHP failed. We couldn't debug where is the error although didn't sleep for a long long night. In the next day, Wima tried to open sample application in XAMMP at localhost. We used XAMMP bundle where Apace, PHP, and MySQL integrated here. Wanna know the code? We still used Oracle as database. Here's the code:

       //connection to Oracle
        include ('koneksi.php');
   
        //query
        $query = "select no_kamar_inv , kamar_jenis_inv,kamar_kategori,
kamar_harga from kel65_inventaris_kamar order by no_kamar_inv";       
        $stmt = ociparse($c,$query);
        ociexecute($stmt,OCI_DEFAULT);

        //php class to create pdf
        include ('class.ezpdf.php');
        $pdf = new Cezpdf();
        $pdf->selectFont('../../php/extras/pdf-related/Helvetica.afm');

        $pdf->ezText('Laporan Data Kamar',14);
        $pdf->ezText('Sistem Informasi E-Inap',10);
        $pdf->ezText('',12);
       
        $i=0;
        while ($row=oci_fetch_array($stmt))
        {
            $data[$i]=array('NO KAMAR'=>$row[0],'JENIS KAMAR'=>$row[1], 
'KATEGORI KAMAR'=>$row[2], 'HARGA KAMAR'=>$row[2]);
            $i++;
        }

        $pdf->ezTable($data,"","",array('width'=>500));

        $pdf->ezStream();
        exit;

How to connect to Oracle is described in article PHP Connection to Oracle.
You will find some different things here if you use another version of XAMMP. But don't worry, it's just a little bit different. Have a nice try with PHP PDF report...

Special thanks for Wima