Oracle Database Developer Question:
Download Job Interview Questions and Answers PDF
What happened if you Set the SGA Too Low in Oracle?
Answer:
Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you try to connect to your server home page: http://localhost:8080/apex/, you will get no response. Why? Your server is running, but the default instance XE was not started.
If you go the Control Panel and Services, you will see service OracleServiceXE is listed not in the running status.
If you go the Control Panel and Services, you will see service OracleServiceXE is listed not in the running status.
Download Oracle Database Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How you change program Global Area (PGA) in Oracle? | What to do if StartBD.bat failed to start the XE Instance? |