mzh

Follow the below steps to setup IP address in SOLARIS 10.9 OS: Provide IP address to the file: /etc/hosts Format: 172.17.1.30      database3        loghost Provide masking info to the file: /etc/netmasks Format: 172.17.1.0       255.255.255.0 If not already created, create file “/etc/defaultrouter” and enter your routers IP address Restart the network by issuing the following command: #svcadm restart /network/physical Check the routing table and confirm the network is using the new sttings: #netstat -r Thats it. Now ping any node of your network to make sure its working. Have a good day.

Solution of problem: Resultset Exceeds the Maximum Size (100 MB) I was running a select statement in PL/SQL Developer. it was a short query but the data volume that the query was fetching was huge. But when ever i Click the button Fetch Last Page or press 'ALT+End' button a message box comes after a while saying: Then I started looking for the exact reason of this sort of problem in Google. When I realized there was no direct solution in the web, I started looking the PL/SQL Developer Software menu and found the ultimate solution. The reason of this problem is there is a parameter of maximum result set size in PL/SQL Developer Software which is by default set to 100 MB. To change this parameter you have to go to the following location: 1. Goto Edit Menu and click ' PL/SQL Beautifier Options '. A new window will open. 2. Click SQL Window of " Window Types ". 3. Now Change the value of "Maximum Result Set Size( 0 is unlimited)"