How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
No Answer is Posted For this Question
Be the First to Post Answer
Give one method for transferring a table from one schema to another?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What is the purpose of the import option ignore? What is its default setting?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
What is a dba?
If you see contention for library caches how you can fix it?
What is da in database?
What are the various ingredients of sga?
Discuss row chaining, how does it happen? How can you reduce it?
What is explain plan and how is it used?
How can you tell if a tablespace has excessive fragmentation?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?