 Related Questions 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 View Question | Asked by : Andy Tags : Backup 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? Read Answers (3) | Asked by : IMDAD Tags : 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 ... Read Answers (1) | Asked by : KUMAR 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 ... Read Answers (1) | Asked by : sunitha View Question | Asked by : ravichandiran How to estimate the size of a tablespace according to the size of the database size Latest Answer : select sum(bytes/1024/1024) mb from dba_data_files where tablespace_name='XXXXXX' ... Explain what are system tablespace and default tablespace? How do they differ from one another? Latest Answer : System for oracle oracle metadata and default for when you create any user without providing any default tablespace clause will use this tablespace for objects ... Can we create tablespace without segments if yes then how? Latest Answer : For what reason you want to create tablespace without segments. Answer is no ... How to convert dictionary managed tablespace to locally managed tablespace? Latest Answer : You can use DBMS_SPACE_ADMIN package to convert DMT to LMT. exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts_dm');where ts_dm is the name of tablespace that need to be converted to locally managed tablespace. ... Where will the transactions be stored during Hot Backup?
During hot backup we specify the tablespace during beginning backup mode and now if a user perform some transactions then where such transactions
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
