logs archiveIRC Archive / Freenode / #oracle / 2010 / June / 15 / 1
bndd
hi. where can i download oracle trace?
RJarett
cd $ORACLE_HOME/bin
bndd
RJarett: was that to me?
RJarett
yes
traces arent a product to download.
what exactly are you asking?
bndd
i'm looking for a tool so i can monitor queries etc on my database
RJarett
monitor how?
bndd
so i can view the queries executed, for example
RJarett
thats all in the data dictionary
sqlplus...
or oem
or sql developer
or toad
bndd
like real-time queries made by the users
         

RJarett
or enable auding
quest spotlight and foglight
wouldnt they be going so fast you couldnt keep up?
bndd
actually it's a ERP product, and i want to see the queries it executes on the db, so i can understand a little better what it's doing
it's on a test db
chemik
hello
i like to order my database to use my new indes via hint, but i dont know how: http://monka.hysteria.cz/~chemik/3.JPG
databaze still use different index
RJarett
did you put a tilde in the index name?
chemik
RJarett: yes,
RJarett
ugh
chemik
RJarett: i was created index on field rsnm and rspos
which i thing are optimal for join
but database use index RESB~0
maybe is problem in syntax for hint for join select
sytse
hi.. is there a way to use XSLT's document() for using multiple input documents at once with dbms_xslprocessor without having to store the additional input document(s) as files on the filesystem?
hrm, I suppose I'm going to have to look into the xml db repository.. sigh
sorry for answering my own question in 2 minutes /o\
stede
how i add NN to a col in my create table script in a way i can choose the name of the constraint -> works only with alter table X modify col constraint const-name NOT NULL; ??
or is there a syntax to use ist inside the create table section like it can be done for pk/fk?
ygip
I haz problems! I am using SQLLDR to load in some data. Apparently the data use the date 30/02/XXXX (they use this as workaround for some business logic) which isnt a real date and I get a problem when inserting into my DATE fields. Whats the easiest solution?
As far as i cqan see the only thing I can do is revert the field to varchar or number :S
hali
or you can stick a replace function or something on the column
replace 30/02 with 28/02 or whatever you want it as
or use mysql, it works in mysql :)
except for the 'logic' bit but that is a given with mysql
ygip
problem is I need to save the year part as it actually makes sense. Besides that I cant change it to 28/2 as I will lose the ability to distinguish them then
Maybe aolution is subtracting 200 years and putting date to 28/2
I dont assume there are anyone in the db from 200 years ago
stede
how i add NN to a col in my create table script in a way i can choose the name of the constraint -> works only with alter table X modify col constraint const-name NOT NULL; ??
how many bytes takes TIMESTAMP(3) in memory? (want to approx calc the data-size of one row)
mgolisch
hm
yay finaly found the culprit for my random host "reboots"
:)
o2net seems to have run into a timeout , seems like it just kills of the host using sysrq reset
probably thats why i never saw anything in the messages log
any hints on finding out why it times out?
we changed the switch for the heartbeat interface allready
but i allmost think somekind of io problem or load causes it to be so slow that it cant respond to in time or something
should i increase the default 30sec timeout?
ygip
can i copy all access to objects from one user to another?
usn_work
do you mean grants?
ygip
yes
i found a script
http://www.myoracleportal.net/blog1.php/2009/01/31/dbacopyuseraprivs2userb?page=2
i thnik this does what i need
mgolisch
are all those oracle memory things allocated from /dev/shm?
basicaly what iam unsure of is if setting the size of the /dev/shm tmpfs to 100gb realy was a good idea
ygip
Can i disable the expiration of system passwords, so I can maintain the same password forever?
nevermind, found the right google query for a solution
usn_work
http://www.usn-it.de/index.php/2009/12/04/oracle-11g-password-expired-account-locked-unwanted/
OT: PowerPoint is the enemy: http://www.nytimes.com/2010/04/27/world/27powerpoint.html?src=me&ref=homepage
         

prodcutnews
is possible to install oracle 10g database server ( .exe excutable ) to be installed on wine ? pls let me any changes are meant to made in wine config...
mator
I really wonder what a man on this planet Earth will install oracle in wine if there's a native version for linux
a macos user?
mgolisch
no idea
prodcutnews
thanks for honor
and postive acknowledment and genius recognisition
mgolisch
why not just install oracle for your platform?
prodcutnews
i could not get much of help on googling ..so im asking here
i tried install latest version of java virt m/c
before installing oracle 10g db ..it failed with some java.lang.null pointer error
uninstalled wine....and also manuall removed .wine directory
and reinstalled wine and trying fresh now
isp bandwidth to download of 2gb native linux oracle version is discouraging ...im not satisfied with oracle xe ( expess edition) ...as an alternative i got windows version oracle 10g db server
which im trying on wine .. if it works it will be very handy to me
mgolisch
that will never work out
gladier
wine was never designed to run something of this scale - it doesn't even have a SAM or the idea of services
mgolisch
it will fail horribly
just download the linux 10g version srsly
prodcutnews
i didnt even thought of services...i was carried away with disgust feeling to have ubuntu+oracle together
i got all oracle products with me which are windows based
ubuntu -->vbox --> winxp -->oracle products
help me be
ubuntu+oracle
Ramen
LOL oracle wine HAHA
avaia
rizzo has a nice writeup
Ramen
dude prodcutnews you made my day
mgolisch
yeah that realy amusing
why not install oracle on your ubuntu directly?
with some hacks you will get it installed
avaia
http://www.pythian.com/news/13291/installing-oracle-11gr2-enterprise-edition-on-ubuntu-10-04-lucid-lynx/
Ramen
no hacks needed
they have install just for linux
mgolisch
i remember i had to create stuff like /etc/redhat-release or something
prodcutnews
isp bandwidth to download of 2gb native linux oracle version is discouraging ...im not satisfied with linux based oracle xe ( expess edition) ...lower edition
mgolisch
to make the installer believe i run on some supported platform
2gb is nothing
avaia
running oracle on wine should be very discouraging for you
Ramen
vbox too
prodcutnews
anyways guys i will stick to my older method of having linux based oracle xe ONLY...
Ramen
you want to max performance....
i think oracle releases a rpm and a sh version now
the sh you don't need to fake redhat
mgolisch
or just use centos :)
if you dont have money for redhat, but srsly if you have money for a oracle license you can pay those few hundreds for a redhat subscription too
or sles or whatever
prodcutnews
i tried downloading 2gig manytimes, midway i got down the road drastically hit myself hard losing time,effort,energy and electricity too
Ramen
meh
avaia
you downloaded so hard you knocked out the power?
mgolisch
thats impressive
Ramen
if you don't wanna mess with linux... why do you have a linux box anyways? might as well go all xp
prodcutnews
i feel getting a GIRL much much earsier now than integrating or getting together Ubuntu+ORACLE into my laptop
shacks ..whatz oracle vm , incase i download its torrent is that enough i mean does it comes with oracle db server software
im done, nothing more from myside
Ramen
if I have a constraint ... unique in the create table... do i still need a create unique index ... out side of it for index?
if I grant something... then a grant any... then a revoke any... does the grant something get revoked too?
DiscordianUK
yep
Ramen
thanks DiscordianUK
« prev next »