 Related Questions Latest Answer : A tablespace in Oracle database is logical grouping of physical datafiles. ... Latest Answer : IN 10g, there are two system table spaces called system and sysaux(auxillary) tablespace. These system tablespaces are backbone of database, and data base will not function at all without these tablespaces. They created at the time of creation and contained ... Latest Answer : The database is actually a collection of objects, which are made up of tablespaces and each tablespace must have datafile associate with it. The tablespace cannot be created without datafile. The tablespaces are two kind physical and logical.The logical ... Latest Answer : It can be, the only required option is that your tablespace have quota assigned to any user that want to store objects in it. ... Latest Answer : The primary block size is defined by the Initiaization parameter DB_BLOCK_SIZE. ... 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; ... Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns Latest Answer : select * from v$parameter where name='spfile'; ... 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
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
