Latest Answer : Oracle Stores logically data in tablespaces, every database atleast one tablespace accumulated with it, tablespace is two types System Tablespaces:- created automatically when database is created by oracle server, to hold system objects, data dictionary ...
Latest Answer : System tablespace is a tablespace that stores all the data dictionary tables in database and it is created at the time of database creation. This tablespace is always and must be online for database to be open. ...
Latest Answer : Table Space : The table space is useful for storing the data in the
database. When a database is created two table spaces are created.
a) System Table Space : This data file stores
all the tables related to the system and ...
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 : At oracle level query data files + tempfilesAt OS level use df -k or du -h ...
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 : Go to OEM => Databases => ... => Instance => Configuration, in "Database and Instance Information" section, the last row shows spfile ...
Latest Answer : it depends on how many .dbf files u r going to store ,it will be ur size of data oracle recommends if one .dbf file size exceeds size of 2gb then we have to create a new .dbf etension file . it is the physical file while ...
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
