Latest Answer: You can set primary key on table upto 16 columns of table in oracle 9i and 10g ...
Latest Answer: And.. I think, the question is about Data Migration - something related to migrating data between different databases.I have done using different tools like Data Junction, Informatica, even PL/SQL and SQL Loader. ...
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 . ...
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: Pfile1. text file2. changes take effect on the next startup3. initSID.oraSPfile1. binary file2. changes perisitent across startup and shutdown3. spfileSID.ora Only way to start db with spfile in non default location SPFILE = must beplaced in pfile ...
What is the difference between .ora and net file or .ora and .net or tnsnames.ora sqlnet.ora listener.ora what ever the differnence makes between ora and net.
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 ...
Latest Answer: question is not clear sturucture of database can be foud in dataflies redo log control files ...
Latest Answer: SCN changes for every 3 minutes in 10g and for each and every action in 9i. It resides in control files and data files. CKPT (checkpoint) background process updates the SCN numbers from control files to the datafiles. SMON (system monitor) background ...
View page << Previous 8 9 10 11 [12] 13 14 15 16 17 Next >>
Go Top
