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: 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 ...
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 ...
Latest Answer: SQLNET.ora tells you what path to take in resolving the name of an instance (among other things). In the context of this question, the NAMES.DIRECTORY_PATH parameter specifys the order of the naming methods used for client name resolution lookups. (TNSNAMES, ...
Latest Answer: You can search Top ten sql.Top 10 Sql. SELECT *FROM (SELECT rownum,Substr(a.sql_text,1,200) sql_text, Trunc(a.disk_reads/Decode(a.executions,0,1,a.executions)) reads_per_execution, ...
Latest Answer: Only the LGWR will be triggered for every 3 seconds. CKPT will be happening based on the recovery settings we have given for the database. for ex. FAST_START_MTTR_TARGET, when ever Log switch happening, alter tablespace offline / readonly... ...
Latest Answer: When a select statement is executed first of all the statements hash code is genrated then that hash code is matched in library cache if the hash code matched then statement is directly executed and if the hash code is not present then hard parsing is ...
Latest Answer: ORA-1555 error can occur in Oracle 10g also even with UNDO RETENTION GUARANTEE enabled. ORA-1555 happens, when Oracle server process could not find the block-image in UNDO tablespace for the read-consistency.Usually this happens when there is not ...
View page << Previous 8 9 10 11 [12] 13 14 15 16 17 Next >>
Go Top
