Latest Answer: Part of the SGA contains general information about the state of the database and the instance, which the background processes need to access; this is called the fixed SGA. No user data is stored here. The SGA also includes information communicated between ...
How to assign an index tablespace for a database permanently, so that whatever indexes we are creating in the database, should automatically goes to that tablespace i.e. we neednot supply the tablespace
Latest Answer: There is no such provision in oracle to have default index tablespace. Workaround is- you can have a job which will scan for indexes in other tablespaces and rebuild into desired one. ...
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. ...
What is the most important action a DBA must perform after changing the database from NOARCHIVELOG TO ARCHIVELOG ?
Latest Answer: It depends on your requirement, if you want no of users around 300 then you can still achieve that by keeping PGA parameters low. If you are looking for number of users 1000 or even more, you need to go for shared server mode. ...
Latest Answer: select file_name, tablespace_namefromdba_data_files; ...
Latest Answer: HiBase tables are made when the database is created and these tables are stored in data dictionary. these base tables contains the information related to the database. these tables are own by sys.the information in these tables is crypted and cannot ...
Latest Answer: Export is one of taking backup. In export backup you can specify many parameters in par file or at command line. One of the parameter is statistics=y or n. If you specify y it is going to export statistics generated in the database placed ...
Latest Answer: Oracle Net Services use a centralized directory server as one of the primary methods for storage of connect identifiers. Clients configured directory usage can use the connect identifiers in their connect string. The directory server resolves the ...
Latest Answer: Consider 8K block size. The total bytes 8 x 1024 = 8196 bytesEach block requires approximately 117 bytes for the header. Please note that the header size varies depending upon the block size. The total available bytes for data = ( 8196 – 117) = ...
View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>
Go Top
