 Related Questions Latest Answer : The primary block size is defined by the Initiaization parameter DB_BLOCK_SIZE. ... Latest Answer : It is the file where actual data are stored. It is the physical part of the database ... You can query dba_data_files and dba_temp_files Latest Answer : select substr(to_char(sum(bytes)/1024/1024, '999,999,999.99'), 1, 15) "TOTALMB", substr(to_char(sum(bytes)/1024/1024/1024, '999,999.99'), 1, 11) "TOTALGB" from dba_data_files; ... query v$log Latest Answer : select sum(bytes)/1024/1024 size_in_mb from v$log; ... Latest Answer : During the design phase of database, The tablesapce size is estimated by calculating the size of typical row of various tables that are going to reside in that tablespace multiplied by the number of expected rows inside the table. If any of the index ... Oracle DBA Questionswhat happen when we kill smon,what happen when we kill pmonwhat is fracture block and how to fix itwhat is corrupted block and how to fix itwhat are the oracle threads are going to start ,when we start the databasehow to check index is working properly ,what are the steps to be taken andon what basis we have to decide particular index has to rebuild not all indexeswhat steps to be taken if receive a call that performance has gone down as dba what steps has be takenWhat possible View Question | Asked by : Ibad Tags : Backup Latest Answer : select sum ( bytes) from dba_data_files ;select sum(bytes) from v$log;select sum ( bytes ) from dba_temp_files ;Total sum of all the three will give the database size . ... Read Answers (3) | Asked by : PARTHA SINHA Latest Answer : select file_name, tablespace_namefromdba_data_files; ... Read Answers (3) | Asked by : sushil k Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations Latest Answer : Changing VARCHAR2(255) to precise required width is good table design. Though it will not improve performance as such. ... Can we create as many tablespace as we require. What is the limit? What is the default size of tablespace? (System and User tablespace). Mention name of some tablespace. Latest Answer : Default size for tablespace: 51276 kb ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
