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
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 ...
66
votes
7
answers
19k
views
What are the drawbacks of running a database inside a virtual machine? How do I overcome them? [closed]
Running anything inside a virtual machine will have some level of performance hit, but how much does it really impact the performance of a database system?
I found this academic reference paper with ...
41
votes
7
answers
25k
views
Reasons to disable / enable SELinux
In the line of this question on StackOverflow and the completely different crowd we have here, I wonder: what are your reasons to disable SELinux (assuming most people still do)? Would you like to ...
33
votes
7
answers
4k
views
Database server: Small quick RAM or large slow RAM?
We are currently designing our new database servers, and have come up with a trade off I'm not entirely sure of how to answer.
These are our options: 48GB 1333MHz, or 96GB 1066MHz.
My thinking is ...
23
votes
2
answers
55k
views
How do I turn off Oracle password expiration?
I'm using Oracle for development on my local machine. The password for a bootstrap account that I always use to rebuild my database has expired.
How do I turn off password expiration for this user (...
19
votes
10
answers
2k
views
Should core system servers be able to connect to the internet for maintenance/support?
A couple of our servers have Oracle maintenance licenses. Our hardware vendor asked there was internet connection in the server room. Our policy is that all machines in that room is isolated from the ...
16
votes
4
answers
115k
views
Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name
What's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ?
15
votes
5
answers
1k
views
Is my new Oracle DBA talking sense
When we setup FC LUNs for our MSSQL boxes we rarely have to present them with more than about 8 distinct LUNs of various kinds (Quorum, MSDTC, TempDB, Data, Logs, Backup and a few others).
We have a ...
14
votes
4
answers
207k
views
Oracle: how to find out storage space used by a table?
How to find out (if possible via Enterprise Manager), the total in Mb that a certain table is using?
14
votes
6
answers
25k
views
How can I diff two Oracle 10g Schemas?
I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article (http://...
14
votes
8
answers
7k
views
Does my Oracle DBA need root access?
My Oracle DBA Colleague is requesting root access on our production servers.
He is arguing that he need it to perform some operations like rebooting the server and some other tasks.
I do not not ...
14
votes
2
answers
168k
views
How to execute datapump commands as sysdba from remote machine
I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine.
I know that when logged on the machine which runs the database, I can use :
...
13
votes
2
answers
27k
views
Disable CPU cores in bios?
Is it possible to disable CPU (Intel) cores in BIOS, and if yes what HP/DELL (others?) 1U/2U servers would allow this?
It is becoming difficult to find new server hardware with dual core CPUs, most ...
13
votes
5
answers
93k
views
Installing Oracle 32bit and 64bit client on the same machine
So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the ...
12
votes
5
answers
36k
views
How to install Oracle's exp / imp binaries
I was browsing the net to find a solution, but I had no luck. :(
How can I install Oracle's imp / exp binaries to my CentOS box without installing an Oracle Server? I'm accessing an existing Oracle ...