Answer Posted / narmada kumari
1/3 of physical memory, can be 2/4k depending on bit of 32 or 64
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how can a session indicate its interest in receiving alerts?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the recovery models for a database? : sql server DBA
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
internal architecture
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How can you control the amount of free space in your index pages? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Explain materialized views and how they are used.
how does an oracle clusterware manage crs resources?
How do you open a cluster administrator? : sql server DBA