Server Fault Stack Exchange
Server Fault Stack Exchange

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/

850 questions
134
votes
11 answers

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 command prompt on completion of the script. My goal…
JoshL
  • 1,535
  • 3
  • 13
  • 11
66
votes
7 answers

What are the drawbacks of running a database inside a virtual machine? How do I overcome them?

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 some interesting benchmarks, but it was a limited…
Russ
  • 713
  • 1
  • 5
  • 7
41
votes
7 answers

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 keep it enabled? What anomalies have you experienced…
wzzrd
  • 10,269
  • 2
  • 32
  • 47
33
votes
7 answers

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 that RAM should be plentiful for a Database Server…
Josh Smeaton
  • 1,330
  • 2
  • 19
  • 31
23
votes
2 answers

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 (and all other users) permanently? I'm using Oracle…
Josh Kodroff
  • 551
  • 3
  • 7
  • 13
19
votes
10 answers

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 internet for security reasons. But the…
Ludwi
  • 293
  • 1
  • 7
16
votes
4 answers

Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name

Can someone explain to me what's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ? Thanks Michael
Michael Ellick Ang
  • 1,839
  • 3
  • 13
  • 15
15
votes
5 answers

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 new Oracle DBA, and he's given me a list of LUNs…
Chopper3
  • 100,240
  • 9
  • 106
  • 238
14
votes
8 answers

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 agree with him because I've set him a Oracle…
Dr I
  • 943
  • 16
  • 33
14
votes
2 answers

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 : expdp \"/ as sysdba\" However, I cannot find how to…
Denis R.
  • 293
  • 1
  • 2
  • 6
14
votes
6 answers

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…
Stuart Woodward
  • 1,343
  • 4
  • 14
  • 29
13
votes
2 answers

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 of new servers are Quad Core ones, and so the cost…
monomyth
  • 971
  • 1
  • 5
  • 9
13
votes
5 answers

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 32bit client seem to reference the 64bit client…
Brandon
  • 133
  • 1
  • 1
  • 6
13
votes
4 answers

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?
b.roth
  • 249
  • 1
  • 4
  • 12
12
votes
1 answer

Running SQL from memory faster than SSD?

Recently we have been having problems with our oracle database locking up on 1 query that we know so far. I will give a break down of what is happen however really doesn't have too much to do with my question but I am open to…
Anthony Fornito
  • 9,526
  • 1
  • 33
  • 122
1
2 3
…
56 57