What are some indications that you need to increase the shared_pool_size parameter?
No Answer is Posted For this Question
Be the First to Post Answer
What are the roles and responsibilities of oracle dba?
What do you mean by dba?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What are the different responsibilities of a dba?
What does dba stand for database?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
When should the default values for oracle initialization parameters be used as is?
What is pct free/pct used/pct increase parameter in segment?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
How would you find total size of database in os level?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?