How do you tell what your machine name is and what is its IP
address?
Answer Posted / amsu
for Machine uname -a, and IP address ipconfig
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
who owns the operating system files created by the utl_file package?
How would you go about verifying the network name that the local_listener is currently using?
what is the use of ocr?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Query processing is slow(eg select query)how will u solve that
What are statistics, under what circumstances they go out of date, how do you update them?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how to restore files with rman?
how can you initialize log miner?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the difference between dropping a database and taking a database offline? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what are the types of connection load-balancing?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?