logs archiveIRC Archive / Freenode / #oracle / 2010 / May / 21 / 1
{aaron}
hi guys, if i am using data pump to import data, the destination db needs to have filesystem access to the source datapump export DIRECTORY right?
i.e. either it needs to be on the same machine or mounted remotely
gws
ok how dumb is it to run 10 databases in 1 running oracle vs 10 running oracles with 1 db each?
from sahred memory point fo view id this 1 instance with 10 db in it be better
boss decided other way
the idiot
RJarett
oracle is 1 db per instance
thinking otherwise is nor understanding how oracle works
do you mean multiple schemas in the 1 db?
oracle isnt like mysql or sqlserver. you cant use the same concept of database/instance
additional instances have wasted overhead and resources
{aaron}
note there are some settings that are database-wide, so in certain circumstances you may need separate dbs/instances
gws
ok yeah
s/db/schema
{aaron}
yeah, 1 schema per db seems foolish to me tbh
gws
so boss says with 10 running oracle its more fault tolerant and can shtu down 1 schema
RJarett
if you are using oracle, most time if you use it only for 1 schema/db, you have your head shoved far up your ass
gws
instad of 1 oracle with 10 schema
         

RJarett
why would you need to shut it down?
{aaron}
gws, but "oracle is unbreakable"...
gws
which from soalris shared mem standpoint seems the way to go
lol
they said what if have to restart oracle, have to take down all 10 schema if all in 1 oracle
I am like why need restart oracle
RJarett
and?
gws
WTF
{aaron}
patching...
RJarett
if you need to restart, they need to come down anyway
{aaron}
which is why you typically have RAC or some sort of failover/loadbalancing
RJarett
less to monitor and worry about
gws
well if run 10 oralce and #9 need restart jsut restart #9
eh
1-8 and 10 stay up
{aaron}
meh
gws
but I said then you running all oracle program 10x
RJarett
it should only really be a question based on resources and workload types
gws
we got old sun 8 core 64g ram
RJarett
solaris 10?
which CPUs?
gws
sol8
900mhz uiii+
RJarett
ahh
you know how much faster and better that would run on a new linux box w/ amd 64?
gws
so they plan to run 10 oracles
1 schema each
we got no money
RJarett
and cheaper to
gws
corporate wants to shutter our office
         

RJarett
are you on UPU licenses?
{aaron}
if you have no money...why do you have oracle
gws
we have until recently been unlicensed
{aaron}
isn't that sh*t like $$$
RJarett
or socket
gws
now getting I think 14 cpu
{aaron}
ah
gws
I said move to linux/oracle
RJarett
im thinking you are seriously getting suckered on that license
gws
dba said he doesnt know how
{aaron}
!
gws
well we have 2 cpu box and 480r with 4 cpu
2 cpu box is 450mhz cpu lol
4 cpu is 1200
with 8 gram
RJarett
14 socket even on an old risc based would be like 300k for ent
gws
8g ram
lol
yep
I said lets buy hardware and use 8cpu
RJarett
i replaced out 2 dozen sparc based DB servers with 1 linux box
gws
but oracel rush rush they already submitted it
RJarett
yep
youre fu*ked
gws
boss maybe playing games trying to keep our crap where it is
grrr
lol
RJarett
youre paying hundreds of thousands
{aaron}
oracle buys him nice dinners
RJarett
you could have used 10k for a nice server
gws
boss said sparc 2x as fast as dell cpu
RJarett
what disk array are you using?
gws
I am like naaaa
RJarett
d1000?
gws
dell 2400mhz xeon
RJarett
lol
gws
boss said im sun certified 1994
lol
RJarett
well your boss deserves to have the office closed
you should work to get him fired
do a little proof of concept with a spare desktop against the sparc boxes
and show that the desktop is faster
and would have cost 1/10 to license
show it to the cto
oracle sales people and VAR care nothing about how it works
only about how much they can oversell
gws
yep
the cocks
boss so damn brain dead n arrogant
RJarett
yep
and wasting money
plus, planning on running on servers that have been off official support for about 6 years
gws
using hitachi
RJarett
HDS ?
gws
and they overrode me using raid10
RJarett
like a 9520 or what
gws
to riad5
cuz want more space
bardbags
RJarett
eh that doesnt matter
your sh*t cant push enough iops to overrun a HDS if its from the last 5 years
gws
:)
RJarett
which hds?
gws
dba cant tell me if oracle is cpu or ram or disk bound
duno
RJarett
whats your position in the company?
if youre just a desktop support guy or something, or a developer, dont worry about it
gws
I created software raid with 3 dell arary and a dell and hdparm -t shows 187MB/s on it
RJarett
its not like developers do anything to tune their code to help out anyway
gws
i offered to use that and boss said less relaible than SAN
RJarett
hdparm cant be trusted
gws
ok
I am unix consultant
RJarett
plus max bandwidth means nothing in a transactional system
i have 100+ disks on a system pushing lik 70k transactions a second and im only pushing 300MB/sec
but maxxing iops
gws
how measure iops?
RJarett
via the san
gws
I looked up something called iozone and it looke like it barfs a crazy spreadsheet I couldnt read
RJarett
but you can measure ghetto iops via the db
gws
hm
should dba know how?
SAN should tell me?
RJarett
you dont know how to use iozone or bonnie++ or iometer as a "unix consultant"?
gws
nope
never asked
lol
not dba or etl guy
etl
yet
RJarett
just what do you do as a unix guy?
gws
web
network
RJarett
youre a web developer?
gws
vmware
RJarett
hmmm
gws
scriptign
RJarett
interesting
gws
bsd linux soaris
its not like I don't know what iozone is
i just never happened to install it
RJarett
or used iostat
gws
iostat yes
vmstat
dstat
so you are saying that the cpu will be the bottleneck before the disk?
RJarett
when the hell did i say that?
it depends on yoru workload
but using 11 year old servers, probably
i dont know which san you have
gws
RJarett: your sh*t cant push enough iops to overrun a HDS if its from the last 5 years
RJarett
or which HBA
since you provided no details
gws
san is hitachi 550
RJarett
you need to learn your workload
gws
and hba is the other vendor not qlogic
I forget offhand
RJarett
old what ever it is
gws
its gheto no san switch direct
RJarett
that san is using like 9 or 18gb scsi disks isnt it?
gws
its 2T and has 2 disk arrays
san isnt that old
RJarett
550?
gws
3-4 yaers
RJarett
9550 you mean?
gws
crap not sure
RJarett
you realize the hds thunder 9550 goes off support next month right?
only 2gb interconnects too
its not bad
just old
and a pain in the ass to get parts for soon
but hell the servers are 2x older than the san so i bet they will go first
gws
aw crap
well we go an assload of dual core dell that hyperthread
RJarett
im suprised the company would let production systems be ran on off support hardware
gws
3.0ghz xeon
and about 6 dell 1T arrays with 14g 10k scsi in em
146g
I could software raid
RJarett
big ol bunch of old crap
gws
this company had no money
dying whale
RJarett
of course, wasted all on systems
gws
well techincally a company bought by a dying whale and the managers at corporate wana not spend on non central office stuff
RJarett
why doesnt the corp office just give you guys VMs and ditch all these systems ?
gws
I personally think a port to oracle on linux or postgresql woul rock since we have low volume
cuz they haven't bothered to pay oracle in 3 years
and now oracle is auditing
RJarett
ahh
well if you guys havent upgraded it should be fine
if you havent added new systems it runs on
gws
and boss so dumb he slapped in first offer they had of 14cpu license since hes scared if we show we can mvoe the boxes corporate will move em outa our office n shutter us
« prev 1 2 3 4 next »