Strobe report shows that CLOSE CURSOR statement shows poor performance. What could cause this statement performance hit? Thanks.
1) What are the common questions asked in DBA interview? 2) Kindly give me important tips for attending DBA interviews.3) What size of database you handled? What should be the expected answer?4) Expectation of RMAN knowledge.5) What is the normal backup strategy use in your company & in market?6) On which OS you are working?7) How we should quote our salary?8) How many times you have done pl/sql coding while working as a DBA?9) What are the common DBA activities you do on daily basis?10) For @ 3
How do you find the total database size in the database, is there any command to see the database size or in os level?2.can we unload the data by using sql*loader?3.can we take incremental backup with out taking complete backup?
The ORACLE db is running with session audit and the audit table is full. What happens to new sessions? Nothing, They are not audited New Connections are Not Allowed Session allowed, with audit to alert.log
Latest Answer : What is this ? Please post individually ...
How to check that the three methods that can be used to determine wheather your database is up and running at OS level.
My database size is 80GB
Latest Answer : Setting of SGASGA 55% of Physical RAMShared_Pool_size 45% of SGADb_buffer_cahe 45% of SGALog_buffer 10% of SGA ...
Latest Answer : Yes, It can.create database link connect to XX identified by XX ;Database link created. ...