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: System Change Number (SCN) This is a sequential counter, identifying precisely a moment in the database.This is the most accurate way to identify a moment in time.You can query SELECT CURRENT_SCN FROM V$DATABASE;orSELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER ...
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 ...
Latest Answer: Exatly upto 512 peta bytes ( refer to Oracle Database Concenpts manual). ...
Why in 10G, when you use real time apply feature in conjunction with Maximum Protection, you can achive zero data loss, but not zero database downtime??
You have taken import of a table in a database. you have got the Integrity constraint violation error. How you are going to resolve it.
Latest Answer: I'm sceptical about the .mdb.The simple, answer is Fixed width or Delimited TEXT files. ...
Latest Answer: 1. Check the oratab file to get the list of databases on a server.Caveat: If the database is created manually, then the oratab won't updated automatically which should be done manually as oratab is updated only when the database is created using DBCA.2. ...
View page << Previous 9 10 11 12 [13] 14 15 16 17 18 Next >>
Go Top
