Tips on determining shared_pool_size at the time of Oracle database creation

One of the parameters that you need to decide when creating a Oralce database is shared pool size. Here are some tips when deciding on the shared pool size.