Tag Info

Hot answers tagged

4

UPDATE In order to start the instance without interfering with an existing running instance (e.g ORCL), before starting anything: sqlplus / as sysdba create pfile='/tmp/initORCL2.ora' from spfile='?/dbs/spfileORCL.ora'; exit Edit /tmp/initORCL2.ora, and modify (add if doesn't exist) the instance_name: *.instance_name='ORCL2' Prevent listener ...


3

The short answer is that no, the same SQL doesn't automatically lead to the same execution plan. For example, one may have a small table and the optimizer may realise that there's no point in using an index since an FTS (Full Table Scan) would be cheaper than trawling through an index and then performing lookups. The "No" answer is the reason that Oracle ...


3

After a pretty good amount of digging, I found this blog post on doing this for date ranges, and it turns out to work equally well on numeric ranges, with a little modification for handling the 0 and 1 endpoints. Taking the query from there and renaming the columns to be a bit more clear, we have SELECT * FROM (SELECT MAX(T_END) OVER (ORDER BY T_START) ...


2

Usual rules apply. Code changes should not be required but something will break if code is more complex. Also there will be some SQL plans regressions. Official documentation about deprecated features is there: Deprecated and Desupported Features for Oracle Database 12c Also you can check Metalink note 567171.1 about _fix_control parameter. This parameter ...


2

The Solaris 11 (11.2) install uses groups of packages called: solaris-desktop solaris-large-server solaris-small-server solaris-minimal-server The group is defined in a install manifest during AI install Oracle also provides a x86 (64bit) desktop install iso A SPARC or x86 Text server install See the install documentation for the list of files if you really ...


1

These are the default values related to this: NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ os_authent_prefix string ops$ remote_os_authent boolean FALSE Set remote_os_authent to true: alter system set ...


1

The install/oraparam.ini contains the following lines (even in a fresh download): #MSVCREDIST_LOC flag will provide the name of the exe that is being shipped in stage/ext/bin MSVCREDIST_LOC=vcredist_x64.exe This is incorrect because you need the 32-bit version (x86). Now if you check stage/ext/bin, there is a file vcredist_x86.exe, and obviously no ...



Only top voted, non community-wiki answers of a minimum length are eligible