DB
Get flash to fully experience Pearltrees
© Michael H.G. Schmidt ( michael@schmidt2.de ) Wer schon mal eine Oracle Datenbank auf Linux installiert hat kennt das Problem: Es gibt eine Menge Linux Distributionen aber Oracle unterstützt im wesentlichen nur 2: RHEL (RedHat Enterprise Linux ©) und SLES (SuSE Linux Enterprise Server ©).
Oracle 11g Installation auf Ubuntu 10.04 LTS ohne X-Windows « Rootz.de
Deadlocks
If session 1 is locking row 1, session 2 locks row 2, then session 1 attempts to lock row 2 (which will block since session 2 has the lock on that row), and then session 2 attempts to lock row 1 (which will block since session 1 has the lock on that row), then session 1 is waiting for session 2, and session 2 is waiting on session 1, which of course will never be resolved. Here's an actual Oracle example. First of all, setup the environment :
We have recently configured shared server in some of our databases. Steps to follow to enable shared server are below. The following configuration is on Enterprise Edition 9.2.0.5. The numbers used in the settings shown are only examples. We are running an OLTP system with about 2000 concurrent users with these parameters without any problem.
Configuring Shared Server
OCP
ASM
rman
Installation
Licences
sql
tablespaces
DBMS FGA
DBMS_FGA is a PL/SQL package used to define FGA (Fine Grain Auditing) on objects. Define a simple policy called DUP_ACCESS: Another example: Define policy named FGA_EMP to audit the DBA's (oracle user) attempts to access to salary (emp.sal column) information:ORACLE HOME
ORACLE_HOME refers to either: a directory where the Oracle software is installed; or an environment variable pointing to the directory where the Oracle software is installed. [ edit ] Windows Check current value: echo The current ORACLE_HOME is %ORACLE_HOME%
Oracle Shell Scripting
This article presents some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN. Windows To run an SQL script using SQL*Plus, place the SQL along with any SQL*Plus commands in a file and save it on your operating system. For example, save the following script in a file called "C:\emp.sql". CONNECT scott/tiger SPOOL C:\emp.lst SET LINESIZE 100 SET PAGESIZE 50 SELECT * FROM emp; SPOOL OFF EXIT;Oracle Data Pump
expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo12.dmp EXCLUDE =constraint -- exclude referential integrity (foreign key) constraints expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo13.dmp EXCLUDE =ref_constraint -- exclude object grants on all object types and system priv grants expdp uwclass/uwclass SCHEMAS=uwclass DIRECTORY=data_pump_dir DUMPFILE=demo14.dmp EXCLUDE =grant
"For our server refresh and consolidation project we were looking for a solution that would significantly reduce our footprint without affecting performance. Oracle Database Appliance not only fit our needs for this project but also addressed our storage issues. We were able to get it up and running easily and started to see the benefits right away.
Database Appliance