Logo F2FInterview

Oracle Database Interview Questions

Q   |   QA

Your 10g XE Server is using about 180MB of memory even there is no users on the server. The server memory usage is displayed on your server home page, if you log in as SYSTEM.

You can start your 10g XE server from command line by:
    * Open a command line window.
    * Change directory to oraclexeapporacleproduct10.2.0serverBIN.
    * Run StartDB.bat.
The batch file StartDB.bat contains:
net start OracleXETNSListener
net start OracleServiceXE
@oradim -startup -sid XE -starttype inst > nul 2>&

Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it:
    * Log into the server home page as SYSTEM.
    * Click the Administration icon, and then click Database Users.
    * Click the HR schema icon to display the user information for HR.
    * Enter a new password (hr) for HR, and change the status to Unlocked.
    * Click Alter User to save the changes.
Now user account HR is ready to use.

Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your server. If you are running this server just for yourself to improve your DBA skill, you should change the SGA size to 32MB by
    * Log into the server home page as SYSTEM.
    * Go to Administration, then Memory.
    * Click Configure SGA.
    * Enter the new memory size: 32
    * Click Apply Changes to save the changes.
    * Re-start your server.

Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. If you think your session will be short with a small amount of data, you should change the PGA size to 16MB by:

* Log into the server home page as SYSTEM.
* Go to Administration, then Memory.
* Click Configure PGA.
* Enter the new memory size: 16
* Click Apply Changes to save the changes.
* Re-start your server.

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: