Questions tagged [oracle]
Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Most questions about Oracle are better placed at the sister site https://dba.stackexchange.com/
866
questions
1
vote
4
answers
182
views
Can anyone recommend a text messaging service for sending alerts and notices from an Oracle database on Linux? [closed]
We're investigating ways to alert users of application errors out-of-hours. Has anyone used a Linux-based text messaging (phone) service for sending out alerts?
10
votes
1
answer
85k
views
Differences between classes12.jar, ojdbc14.jar, ojdbc5.jar and ojdbc6.jar
We are planning to upgrade our application servers to a new version of JRun which is carrying with it an upgrade from Java 1.4 to Java 1.6. As part of that, we have been testing various pieces of our ...
2
votes
5
answers
7k
views
Solaris Unix systems swapping & blocked processes
Some users are complaining of poor performance on a brand new server. The only running on this machine is Oracle 10.2.
At first glance everything looks ok: load is minimal, nothing in logs. The only ...
1
vote
2
answers
5k
views
Best practices for SQL Server to Oracle data synchronization
I have some tables in a SQL Server database that I want to make available to an Oracle database.
Keeping in mind that data integrity is the top priority, what are some best practices for keeping the ...
0
votes
1
answer
791
views
How to handle oracle installations with same SID on same subnet?
I have two Oracle RAC clusters on the same subnet. For this discussion, let's assume one is a QA cluster and one is a DEV cluster. They are both running on RedHat Enterprise Linux 5, 64-bit.
They are ...
0
votes
1
answer
1k
views
Best practices in customizing Oracle E-Business Suite and Oracle Applications in general [closed]
I am looking for some best practices in customizing Oracle E-Business Suite, especially in terms of version control of concurrent programs (like Oracle Reports), Oracle Forms tracking/rolling back ...
3
votes
5
answers
1k
views
Hidden features of Oracle Database
As my daily job circles around an Oracle DB I wonder are there any hidden features that could come in handy in day to day work with the DB, both as a developer and as a DBA?
6
votes
7
answers
5k
views
Things every Oracle DBA should know
This could include:
Books worth reading;
Tools worth having;
etc.
2
votes
4
answers
4k
views
How to best optimize an Oracle database for writes?
How can I maximize the write performance without impacting reads?
0
votes
2
answers
323
views
Oracle disaster recovery on Linux
My Oracle database is stored on a Linux system. That Linux system is down. So I want to restore my Oracle database as soon as I set up the Linux system. I don't know how to restore it. Can anyone help ...
144
votes
11
answers
531k
views
Run Oracle SQL script and exit from sqlplus.exe via command prompt
I would like to run an Oracle script through SQL Plus via a Windows command prompt. The script does not contain an "exit" command, but I would still like SQL Plus to exit, returning control to the ...