How can you find out how many users are currently logged into the database? How can you find their operating system id?
No Answer is Posted For this Question
Be the First to Post Answer
What are the main benefits of using spfile over pfile?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What is the purpose of the import option ignore? What is its default setting?
What does database administrator do?
What are the different responsibilities of a dba?
When using oracle export/import what character set concerns might come up? How do you handle them?
You see multiple fragments in the system tablespace, what should you check first?
What database block size should I use?
How can you tell if a tablespace has excessive fragmentation?
What is a database instance?
How many dba can you have?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?