Questions and answers (if exist) -------------------------------- RDBMS ----- -- what does non-blocking SQL mean (7.2) and multitheded client for three-tier TP architectures (7.3). Does threading support [SANKAR95a, p.47] provide asynchronous processing? -- What does ALTER SESSION SET CLOSE_CACHED_OPEN_CURSORS = {TRUE|FALSE} do? -- What does "call bundling" mean in 7.3? [SANKAR95a] p. 39 -- Server concepts says that "Archiving to tape is not supported any platform". Why? Does 7.1 or 7.2 support archiving to tape? -- Alter system kill session in network environment. If an active session cannot be interrupted (due to network I/O or rolling back a transaction) the session can't be killed until the operation completes. If the session can't be killed in 60 seconds it marked as "KILLED" in V$SESSION. When the server process is really disappeared? Why does SQLNET.EXPIRE_TIME parameter not work properly??? What should be done to switch this parameter on? -- What are the pre-conditions for using the same extent of a given rollback segment by more then one transactions? -- What does SET TRANSACTION ISOLATION LEVEL SERIALIZABLE mean in SQL standard? -- Nigel Noble in OEUGM 12.95,p84 mentions "there has been as undocumented/unsuported way of turning off redo logging at database level...". What is INIT.ORA parameters to do this? Answer: _disable_logging=TRUE -- What is the difference between SQL Area and Library Cache? -- What does DB_BLOCK_HASH_BUCKETS mean? N E T W O R K I N G - - - - - - - - - - -- will SQL*Net 2.3 in Oracle 7.3 support SQL*Net v1 to work from DOS workstations? -- Let's suppose we have the following INIT.ORA parameters: DB_NAME = loc DB_DOMAIN = hq.mycorp.com GLOBAL_NAMES = true If we create database link on other server: CREATE PUBLIC DATABASE LINK loc.hq.mycorp.com without connect string, then the database link will point to server loc.hq.mycorp.com. Question: What if loc.hq.mycorp.com is a cluster with several instances? Which instance will be connected to through the database link? (Fully Qualified Object name is incomplete in this case.) How is fully qualified object name related with SQL*Net addressing? N L S ----- -- Is it possible to get a character set programmatically from ORACLE.INI or TWO_TASK on client side using PRO*C or OCI? -- How to get charset number by charset name and otherwise? Below is the answers from Kevin Wharton: Dmitry, some answers (more to come!): 1. Forms 4 itself now provides a way of knowing the client NLS setting with USER_NLS_LANG (entire NLS_LANG variable) and individually with USER_NLS_LANGUAGE, USER_NLS_TERRITORY and USER_NLS_CHARACTER_SET. There is no equivalent way of doing so from Proc*C and OCI, but the suggestion is a good one, and I will pass it on to Development as an enhancement request for these interfaces. 2. There is currently no 'external' way of getting char set number from char set name, only 'internally' via NLSRTL function calls. 3. To get NLSRTL version on UNIX you can do: strings libnlsrtl.a | grep NLSRTL (libnlsrtl.a will be in $ORACLE_HOME/lib) I am not sure if there is a way on Windows, but will enquire. Dmitry, more answers: 3b. I am told that to get NLSRTL version on Windows you can do: exehdr nls23win.dll | more BUT, this utility, exehdr, comes with the windows development kit. Without installing the kit, there won't be such a utility under windows. Regards Kevin ------------------------------------------------------- Kevin Wharton Director, Product Planning Development Services National Language Support Oracle Corporation Phone : 31-3406-94634 Rijnzathe 6 Fax : 31-3406-65041 NL-3454 PV DeMeern Internet : kwharton@nl.oracle.com The Netherlands ------------------------------------------------------- -- Does any parameter in ORACLE.INI exist to allow re-set built-in charset in FMX file? Developer/2000 -------------- -- How to catch keyboard push during continuous display of database table, for example, in KEY-STARTUP trigger through ALERTS (DBMS_ALERT.WAITONE or WAITANY function)? -- What is ORACLE FORMS master-detail behavior (which triggers are generated) when constraint radio button is used and DELETE CASCADE is specified on database side? Does ORACLE FORMS duplicate database behavior in it's own master-detail triggers? -- Is it possible to create a form continuously displaying some rows from a table? I mean using DMS_ALERT package (WAITONE, WAITANY). If yes which trigger should be used and how to exit from forms on external event (for example, push CTRL/C button)? Enhancements ------------ RDBMS ----- 1. Algorithm for shrinking rollback segments with OPTIMAL clause should be changed. "If a transaction needs to continue writing rollback information from one extent to another extent in the rollback segment, ORACLE compares the current size of the rollback segment to the segment's optimal size. If the rollback segment is larger then its optimal size and the extents IMMEDIATELY FOLLOWING the extent just filled are inactive, ORACLE deallocates consecutive non-active extents from the rollback segment until the total size of the rollback segment is equal to or as close to but not less then its optimal size." (System Concepts Manual). Is it possible to change "IMMEDIATELY FOLLOWING" extent by the "LAST EXTENT" of this rollback segment. 2. To provide features do not write UNDO and REDO info for temporary non-shared tables. A table should considered to be temporary if it located in TEMP (or specially marked) tablespace) or CREATE TABLE operatior should have UNRECOVERABLE option. CREATE TABLE AS SELECT ... UNRECOVERABLE is NOT COMPLETE solution. 3. Separate privilege allowing user to alter the password of other privileged users should be provided. Current ALTER USER privilege is too general and allows too wide class of things to do.