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; ...
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
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 . ...
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.
What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?
Latest Answer : Is the meomory that is allocated to each connection to Oracle, this memory is not recliamed even if the session is inactiveit is recliamed if the session is disconnected onlyto see it:D:appadminproduct11.1.0db11gBINorastack oracle.exe to change it to ...
What is your datafile size? How long it can go? What is the max limit to which you can extend?
Latest Answer : v$datafile data dictionary view will tell us the size of a datafile.to check the number of datafile you can check db_files init parameter. you can also alter this parameter but it will reflect after restartthe database.you can also resize the datafile ...
