Hot answers tagged oracle-se
12
In general, yes. Once you have an application in production, every environment (dev, test, staging, production, etc.) needed to support that application needs to be licensed. As with all licensing advice, however, you need to get it in writing from Oracle Sales. Advice from some guy on the internet holds up about as well as you might expect if there is ...
6
The Oracle Software Investment Guide says the following:
Test/Staging - Test/staging
environments are used to verify that
new or customized code runs properly.
This can be staged on separate servers
or on the same servers used to run a
development or production environment.
Any Oracle software used in
test/staging environment must be
...
3
I got following results
SELECT SYS_CONTEXT('USERENV','SID') FROM DUAL;
-- 5276
SELECT * FROM gv$session where SID = SYS_CONTEXT('USERENV','SID');
-- No result
SELECT * FROM gv$session where SID =5276;
-- 4 results for 4 node RAC
-- 1 result matches my USERNAME,OSUSER, MACHINE and PROGRAM
-- 3 results are different from my USERNAME,OSUSER, MACHINE and ...
2
Foglight Perf.Analysis for Oracle is a great performance workload tool which digs very deep into Oracle via Stealthcollect technologie direct from server memory areas, so no much overhead load in the database, also possible to review historical data, change tracking, advisories and much more...
StealthCollect – Delivers deep SQL-level collection and ...
Only top voted, non community-wiki answers of a minimum length are eligible