Answer Posted / chowdary
Buffer Cache Advice, Segment Level Statistics and Timed
Statistics
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the steps you will take to improve performance of a poor performing query?
what is the use of recording information about current session?
what is a crs resource?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What purpose does the model database server? : sql server DBA
how can you enable flashback feature?
What is replication? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how does an oracle clusterware manage crs resources?
what functionality does oracle provide to secure sensitive information?