logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 14 / 1
bencc
in order to connect to a local oracle db with python I need cx_Oracle
do I need the instant client as well or will the cx_Oracle and the server be enough
hanswurst
got a 10 M row table and massive performance issues with joins
is denormalizing with star schema an option for me?
thecolor3
okay, I am REALLY fscking stumped, I setup 11g on a windows account, setup a db, did users and put a password for sys finished db, now went to port 1158, says sys password is wrong.
Junior
yello ;)
TheBonsai
y0
cofeineSunshine
hello
admin0
hi .. is there a command to get a list of all indexes on a tablespace
cofeineSunshine
admin0: try to look at this sql output: select * from all_objects
admin0
thanks
(Action) passes some pizza to cofeineSunshine
one more question .. i have a very high wait time on log file sync .. how would I find out what exactly the issue is
         

KeiKurono
morning
admin0
afternoon
how do i echo/print something in plsql
milan
dbmsoutput.put_line('something');
but you must set this sql+ command first: ser serveroutput on size 1000000
admin0
oh .. i found that set echo ON worked for me
thanks
i was trying to echo the liens i was passing from .sql file
milan
that's not plsql -_-
admin0
i have a insert into table statement that is giving TM: contention .. from what I read, its due to unindexed foreign keys .. this table does not use any foreign key at all
how do I find out why its coming
milan
what are you doing that locks the table?
admin0
i found out .. i was rebuilding indexes
back to the same log file sync issue now :)
is there any command which i can run and post stats here via which someone can say if the server setup is optimal or not and why i might be facing a slow db response due to log file sync event all the tiem
ygip
How much faster is a table stored in memory over one stored on the disk on average use where you do joins between them or just raw select a stream of data based on simple indexes? is it twice as fast, ten times as fast or 100 times as fast?
deebo
hmm how do i call a stored procedure with 3 params, 1 of them optional
call proc('1','2') fails
or optionally, how do i query for the definition of the stored procedure to get details
this stored procedure has 3 params, varchar,varchar and sys_refcursor, and it returns a sys_refcursor
how do i call it to get the row results in plain sql?
call theprocedure(varchar2(param1),varchar(param2), null) does nothing, says wrong param types
usn_work
good CEST afternoon
mgolisch
ocfs2 vs gfs which should i use for general data storage?
id need to have a shared filesystem between my rac nodes to place stuff there like files to be loaded qith sqlloader or output files to be written to from the db
RJarett
neither
usn_work
use ASM
ocfs2 is weak in concurrency
mgolisch
we use asm for the datafiles and index etc
RJarett
both were stopgap efforts to fix issues in OS clustering before something good was done with asm
usn_work
ACFS
mgolisch
but i would need something that i can write to using samba thats accessible on all nodes
usn_work
ACFS
RJarett
is this data outside the area of the DB?
why not nfs/direct nfs?
         

mgolisch
can my nfs server access asm?
RJarett
why would you want to?
what are you REALLY trying to accomplish?
realHans
hi. OT. Did someone ever connect to an Oracle database with VSExpress2010 Database Explorer ?
markl_
ok i am getting close with an oracle server spec file, anyone interested in making their own oracle server standalone rpm's?
obviously you won't want to put the rpmfiles anywhere public :)
but if you create lots of test or dev environments it may be useful
RJarett
no
why bother?
its called a tgz. done
or i have a base oracle VM image even easier
right click my template, clone from template, power on "you have a new database"
plus every test and dev system needs to be licenses. giving someone the ability to roll out multiple systems w/ oracle is begging for audit problems
TheBonsai
(with identical DBID)
:)
RJarett
dbnewid is part of my firstboot template script
TheBonsai
i assumed that, i just wanted to write at least one thing today
RJarett
but i would much rather just extract my $ORACLE_HOME tarball on a different system and copy my flash recovery area over to clone it anyway
hey youre at 3
TheBonsai
[4] hell, what a good day
zasz
rjarret how do you like those v$*advice perf views
RJarett
dont use them too often
which do you mean?
zasz
sga, cache, sga
they have some really good info
RJarett
ah like sga size
zasz
like hypotheticals on cache hits if you raised it by x
RJarett
im usually on target before i even turn it on
zasz
(reading the performance tuning manual)
RJarett
so they arent much use to me
markl_
RJarett: yeah i am looking for different ideas on how to do things too
i personally like everything to be in an RPM so newbs can use rpm -qf
RJarett
oracle xe does have an rpm
markl_
and i install with puppet classes typically
DiscordianUK
Indeed it does
RJarett
you arent oracle. you arent legally allowed to repackage and distribute it
markl_
i would use xe if our devs didn't have ridiculous test db's
RJarett
so whats the issue?
you have licenses for multiple systems?
markl_
dba wastes too much time installing by hand
yeah, we destroy & recreate our test environment often
RJarett
why not just image it?
markl_
dba is not a real systems guy
at this point, it is really just the challenge of automating it in puppet
and our vm infrastructure isn't so good yet either
i'm new here
RJarett
if its linux, use DD to image it
markl_
well tar is the best way to make images
openvz
RJarett
yeah you can go screw yourself with that
markl_
(yes, "best" is subjective) :)
hey calm down there tiger
RJarett
openvz sucks ass
markl_
i couldn't disagree more
but there are some applications that it isn't good for
e.g. desktops
RJarett
and servers
and anything needing security
or real thread based split
markl_
this is #oracle dude
RJarett
so why did you bring it up?
markl_
get your meds adjusted
i just mentioned tar instead of dd
RJarett
tar isnt bare metal
markl_
and then said it was subjective
i am really looking for what people consider best practice for deploying oracle quickly so our dba doesn't spend 1/2 his life clicking the installer gui
RJarett
most of the time required is reinstalling the OS
markl_
i'm using this as an opportuity to 09:45 -!- Junior [~Juni@79.119.108.131] has joined #oracle
oops cut & paste error
RJarett
of you do that, and you arent virtualized, use DD
markl_
one button macs, grr
RJarett
if you dont do an os reinstall, use tar of the oracle home and datafile loc, and then nid the instance on the other box
markl_
so a complete os image
what is a nid?
RJarett
newdbid
markl_
i am an oracle n00b
RJarett
changes the name and dbid internal to the DB
markl_
heh i read that as "newb id" at first :)
RJarett
or else when you connect 2 dbs with the same dbid to rman repository it gets the backups messed up
markl_
ok gotcha, is there a way to generate those?
or would that be considered a "crack"
RJarett
nid
markl_
ah ok cool
RJarett
its just a random # per DB
that is tagged to all the datafiles
and controlfiles
markl_
cool, good to know
RJarett
but be careful of your licensing
markl_
is there an oracle intro site out there that people consider to be the best one?
RJarett
no.
since most people dont down and up new dev or test environments
markl_
RJarett: yeah we are negotiation a renewal now
what are the licensing issues i should think about?
RJarett
or if they do, they use real cloning like a full instance clone in rman
you are licensing per socket with 2 cores
you arent free to use it anywhere
development must me licensed
markl_
e.g. if i want a prod cluster, a dev cluster, and a smattering of single server test instances
er prod & qa cluster
and smattering of dev instances
RJarett
yeah count every pair of cores on all those systems
thats how many sockets you need to buy
a quad core is 2 processors. 6 core is 3
markl_
how do they do hyperthreading?
RJarett
and oracle end of year is in about 45 days, so you may be able to push 35-40% disacounts
markl_
i think our new server uses that unfortunately
RJarett
HT doesnt matter
since ht is fake and BS
markl_
ok good
RJarett
marketing junk
markl_
yeah but it shows up in /proc/cpuinfo so it is possible to get hosed if you're not careful
RJarett
dont see any performance gain on a standard edition w/ it. little if on ent
markl_
yeah in my pure cpu test it was like 10% of a gain
worth enabling but just barely
does oracle charge differently for dev licenses or are they all the same?
maybe it would be better to put lots of sids on one box
(is sid the right term for that?)
RJarett
well you can usually push for a larger discount if you dedicate those sockets to just dev forever
markl_
do they offer any kind of site license?
i imagine it is ridiculous $$
RJarett
yeah you cant afford it
why do you feel you need multiple systems running it?
how system intensive is your app to the db?
thecolor3
Anyone by chance happen to know why the em spits out or even requires host cred's for .dmp imports
RJarett
because it needs to check space, directory existing, file existing, write a log file
thecolor3
Well I entered sysdba for the localhost I am working on but it keeps saying bad user/pass
RJarett
sysdba isnt an os user
it isnt even an oracleuser
its a role
thecolor3
So I should be entering the OS's u/p and not a oracle user?
RJarett
sysdba isnt even a database user
thecolor3
Well I know sys is and I tried that
RJarett
you should be using the oracle username, or a user on the os with access to read the dmp and access to the DIRECTORY object dir
sys isnt an OS account. plus you shouldnt use sys for anything
thecolor3
okay
jfroebe
has anyone modified the script files in $ORACLE_HOME/bin that have hard coded environments to access a central environment file? Just wondering what Oracle's reasoning is to hard code the env variables in every shell script (10g/11g)
thecolor3
RJarett: okay and thanks
RJarett
jfroebe: like which?
jfroebe
example: $ORACLE_HOME/bin/netca
RJarett
i see nothing hardcoded in there
ohh the JREDIR?
jfroebe
yes... but just as an example - there is quite a few files like that... changing where the $ORACLE_HOME directory is located turns into a major pain...
RJarett
why would you be changing your oracle home location?
jfroebe
Certain DR scenarios or if someone installed it in the wrong directory for an unknown reason.. but that's not the question though
:)
RJarett
ln -s
jfroebe
that would be a workaround ... Just wondering what Oracle's reasoning is to hard code the env variables in every shell script (10g/11g)
RJarett
because most times it calls to java or perl that it install with and for that database
because oracle makes changes to the normal perl and jdk/jre for their own liking
jfroebe
right but why hard code it into each file instead of a environment file?
seems rather like a shotgun approach imho
another scenario: you lost internet connectivity and don't have access to the oracle installation files (WAN issues)... you have a corrupt file system housing your oracle software installation. Assume that restoring from tape will take 6 hours (getting the tape, etc), you could copy the oracle software from another machine in 20 mins but you will need to modify the files to point to the correct oracle home
« prev 1 2 next »