Database Administrator

select name,value,isdefault,isses_modifiable,issys_modifiable, isinstance_modifiable,isdeprecated, from v$parameter; alter system reset...

alter system set SESSION_CACHED_CURSORS=500 scope=spfile; If an application repeatedly issues parse calls on the same set of SQL stateme...

CURSOR_SHARING The default value of parameter Cursor_sharing is Exact. Who changed it? CURSOR_SHARING is a parameter which decides whe...

SELECT n.ksppinm AS "name", v.ksppstvl AS "value", n.ksppdesc AS "description" FROM x$ksppi n, x$ksp...

Machine code is sometimes called native code when referring to platform-dependent parts of language features or libraries. Change...

Oracle LOG_ARCHIVE_MAX_PROCESSES parameter specifies the number of active ARCH processes (ARC0-ARCn) initially invoked by Oracle. The value ...