How can you determine the number of sqlnet users logged in to the unix system?
Answer / Shudhanshu Kumar Pandey
You can use the 'sqlnet stat -p' command. This command provides information about SQL*Net connections, including the number of users logged in.
| Is This Answer Correct ? | 0 Yes | 0 No |
When should an artificial (or derived) primary key be used?
What is the main function of database?
What skills should a dba have?
How do you analyze table partition using oracle provided package?
What is the difference between a database and instance? What is the relation between them?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What are the types of schemas?
What are the important tasks of common oracle dba?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
When should the default values for oracle initialization parameters be used as is?