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
Does a dba have to file taxes?
What are the functions of administration?
What os user should be used for the first part of an oracle installation (on unix)?
What do you mean by oracle dba?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
If you see contention for library caches how you can fix it?
When should an artificial (or derived) primary key be used?
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?
What is dba software?
What are the different types of database users?
How do you install statspack?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?