The lock analyses is one of important step in problem detection, also lock analyses can help to improve performance.
The standard views for analyses is: v$lock and v$session_wait
But Oracle Corp. suggest use additional views for more powerful and fast lock analyzes:
Читать далее Additional views for lock investigations
Some operations via web interface require a Host credentials.
You can use «oracle owner» user or create additional user, but you should give additional specific system privilege for this user: Log on as a batch job .
How you can it:
1. Go to Start > Control Panel > Administrative Tools > Local Security Policy
2. Open Security Settings > Local Security Policies > User Rights Assignment
3. Double-click on Log on as a batch job from the list of privileges in the right pane.
4. Click on Add User or Group … and enter the name of the OS user whose credentials are being used as the preferred credentials for the host.
5. Click ‘OK’ twice.
The non-interactive (silent) installation Oracle’s products are very usefully if you going to deploy on multiple servers or your server doesn’t have GUI.
You should complete following speps for install Oracle’s products in silent mode:
1) Prepare response file, this file consist answer on question which would answered in dialog mode.
You can choose on of two variant for this action:
a) Edit template for response file (folder response in your installation CD)
b) You can run test installation with recording all answers into file (this feature available from 9.2 version).
setup -record -destinationFile <response file>
2) Second step — it is running Universal Installer in silent mode:
setup -silent -destinationFile <response file>
Also, if you want deinstall product in silent mode — use following command:
setup -deinstall -silent -responseFile <response file>
This short instuction tested on Oracle RDBMS 10g release 2 and Oracle RDBMS 9i release 2 on windows-32 platform, but you can use this advice for any platform and for other version of products.
Oracle Official Documentation:
Article from OTN:
For determinate current patch version you should use following:
a) select * from v$version; ()
b) select * from dba_registry; ()
c) readme.html from patches (can be extract from patch bundle or downloaded from metalink)
Читать далее How-To: determinate oracle patch version