Oracle - SGA Setting Is Too Low in Oracle

SGA Setting Is Too Low in Oracle

Q

What Happens If You Set the SGA Too Low in Oracle?

✍: FYIcenter.com

A

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.

⇒Introduction to Oracle Database 10g Express Edition

⇒⇒Oracle Database Tutorials

2016-10-16, 174👍, 0💬

Popular Posts:

"CREATE PROCEDURE" -...

How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...

Windows Applications...

How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

CONTINUE to Next Loo...

How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...