logs archiveIRC Archive / Freenode / #oracle / 2010 / February / 2 / 1
KWhat_Work
how do you specify a table name for nested column that also has a nested table column
maybe this will help explain http://pastebin.com/d2a48ea3a
Reign1
hi, my delete is active for few hours now, i mean theres a large table and so on, ok, but still, what could cause a slow delete? indexes seems to be allrigh
t
xiaoshen
hello^
urm.. is there any free software that similar witnh toad?
DiscordianUK
There's Tora on linux
xiaoshen
in windows
^^"
DiscordianUK
No idea sorry . Isn't there a free version of Toad?
xiaoshen
oh
i don't know
i just c that it is trial version
DiscordianUK
There is a freeware version
Reign1
can i move tablespace datafiles?
         

xiaoshen
oh i just found it , yea it has a free version
hali
yes
Reign1
hali: that was for me? if so: any link? or just a simple tell? :)
DiscordianUK
You asked a yes/no question
Reign1
i found things like datafiles encryption, moving between filesystems and so on, while i only need info how to move them between folders correctly
hali
Reign1: yes, you can move datafiles, google it, there are a few steps... depending if you can offline or not
Reign1
got it, will try, thanks
hali
1) cp in unix, 2) alter database rename datafile 3) recover datafile
cofeineSunshine
xiaoshen: oracle sql developer
freee
xiaoshen
oh
ok cofeineSunshine thQ^
Reign1
lets say ive got a huge table, whats better, to partition it or to split table into more tables in stead of partitions? i mean which would be faster to work with?
or can i somehow use 1 table which has data spread on several tablespaces without partitioning or what, dunno whats the best option
idletask
Hello
PL/SQL question... What's wrong with this procedure? According to the tutorials, this should be OK, but it is not: http://www.pastebin.ca/1775374
Well, OK, it was not
Gee
PL/SQL is complicated :/
hali
Reign1: how big is huge?
100+ million rows?
Reign1
ofc
hali
do you have the partioning license?
and a good key to partition by
and splitting it up to more tables will probably require code changes to your app?
Reign1
yep, yep, yep
hali
then i'd say go partitioning
corpxicle
anyone have experience using sqlldr on oracle xe and "normal" oracle ?
we're experience a huge performance difference
XE is about 10x faster
hali
wtf
:)
corpxicle
yea
thats what we're thinking too
         

hali
XE will only spawn processes on a single core for one
same hardware?
corpxicle
no
the xe one is a laptop
the normal oracle one is a sun server
x4200 afaik
hali
iowait on the sun box?
corpxicle
possibly, its around 100% busy on the disk
with just approx 1000kw/s
hali
my guess exactly :)
corpxicle
so whats the problem
the disk is rubbish ?
hali
older sun x usually have sh*t SAS controllers
corpxicle
aw
hali
the cheap LSI ones
corpxicle
but 10 times sh*tter than a dell laptop ??
hali
that is indeed very odd
laptops usually have 5400 rpm drives as well
corpxicle
yes, it is
hali
raid1?
corpxicle
you know im not sure we raided this at all
this was specificly bought for troubleshooting at one point, and then we inherited it
and didnt reconfigure
idletask
corpxicle: is the table when you try to insert in the slow case already indexed? What about the one in xe?
Inserting into a heavily indexed table is _slow_
corpxicle
same table afaik
idletask
Yes, but indexes on that table?
corpxicle
they should both have been new and unused, configured the same
i didnt create them
would xe do something by default that oracle doesnt ?
or vice versa
idletask
You'd better check that, believe me
With sqldeveloper for instance
Also, you may have too small redo logs on the "slow" database, or it is configured with archive logs whereas the xe database is not, etc
Check the alert log of both
But first of all, check indexes
Reign1
hali: what about having more tables, and having a view which union selects needed info from those tables?
idletask
Reign1: it depends really if your problem is insertion performance or select performance
Reign1
select performance
idletask
Insertion wants data scattered, selection wants data gathered
Reign1: care to share a sample query?
Reign1
dont have one on the fly
but thing why im asking this is that atm i got that table partitioned and im not happy with response times when selecting
idletask
Well, it means that the selection criteria are not "selective" enough
Isn't there something rotten in the queries like "when trunc(adatecolumn) = ..." or alike?
Reign1
dunno, its not actualy me selecting, users whine about time :)
should check their selects tho
idletask
Yep, definitely
corpxicle
idletask: indexes should be the same on both unless XE does something strange with that
idletask: direct=true made it about 10000 times faster
idletask
PL/SQL question again: are bind variables case sensitive?
I need to pass a statement with a value in double quotes, but...
Well, it just doesn't work
I have tried this: http://www.pastebin.ca/1775469
But it anwsers ORA-28393: password required to close the wallet
Meh
And if I put ":1" instead of :1, it says ORA-00911: invalid character
:(
cofeineSunshine
liau liau liau
idletask
Grrr
Now I get ORA-06546 :(
Help :(
I cannot get my head around this
I can only use casual concatenation, and that's vulnerable to SQL injection :(
sinesio
don't know nothing about that, but have you tried something like http://pastebin.ca/1775488
probably this is a big nonsence
korb
what do u think of sun fusion ?
oh well think nothing then
idletask
sinesio: I haven't, indeed
RuslanPopov
I have Oracle 11g1 on Windows and the following wild problem http://dpaste.com/153663/ inside my scheme
wtf, ppl?
if I will restart Oracle it will work well, byt it bores me already
sinesio
can someone tell me what is the repository version of oracle database 11gr2?
idletask
RuslanPopov: missing privileges, obviously... Can you create a table at all?
RuslanPopov
yes
if I restart Oracle the same command works well, the problem is until restarting the instance
idletask
Uh
No idea, then
Maybe it's a known bug?
RuslanPopov
maybe
hali
test
hell
123
hali
ack
321
hell
heh. Now i need to identify with nickserv before write.
hali
ah yes, some spamprotection thing
hell
but queries work well)
so, i start playing with tomcat and servlets. But seems like, JDBC does not use my NLS_LANG value.
i set it to NLS_LANG = AMERICAN_AMERICA.UTF8
but data come in some crap win1252 or something lokie this
with ??
RuslanPopov
/ns identify YOURPASS
idletask
hell: are you really sure the variable is passed to your tomcat process? If under Linux, check /proc/<pid>/environ
hell
idletask: i print system.getEnvEnv()
so, internet says that thin driver always use utf-8
idletask
brb
Scorp1us
Hi all, I have a table, and somehow it was created with column names 'hash' and 'size', but I can't seem to use them in a query. What must I do?
RuslanPopov
`hash` ?
or "hash"
Scorp1us
oh, I was trying 'hash' which always gave me 'hash' as the column value
and those are backticks right?
Xgc
Scorp1us: This is Oracle. Use double quotes to enclose identifiers that have special characters or that conflict with reserved words.
Scorp1us: That's the standard mechanism. Some other databases support non-standard mechanisms, like backtics and square brackets. Oracle uses standard double quotes.
idletask
Hello
Procedures run as the user which creates them, but... This is not true of dbvault users :(
Is there a way around this?
I must go
Have fun
TomJ
What exception is raised when you try to pass NULL into a non null column?
RJarett
ORA-ID10T
zasz
lol
dogmeat
RJarett, haha
is there an oracle client for 64-bit freebsd?
RJarett
no
spcshpopr8r
greetings. My sysadmin wants to clone a redhat server running an oracle 10g database in order to create a test environment. Can any of you think of what the implications would be of that? For instance, both databases would have the same db id. Would there be problems with both hosts/dbs together on the same network?
usn_work
no
but grid control will be confused
and, the cloned server should be cloned offline
spcshpopr8r
usn_work: thanks...just to clarify when you say "no" you mean that there are no problems with this approach, but to be sure to do the cloning while the database is offline...correct?
usn_work
yes
you are right ;)
spcshpopr8r
usn_work: I have experienced grid control getting confused in similar situations, do you know the best way to resolve that confusion?
usn_work
Cloning will do the same as an offline backup does
I'm using RMAN duĆ¼plicate database for that purpose
spcshpopr8r
usn_work: right...actually I may be mistakenly using the term "clone", I think he's actually restoring a backup of the filesystems (made while the database is offline)
usn_work
I won't do that
spcshpopr8r
usn_work: yeah, I've used RMAN duplicate for other situations. In this case, sysadmin is creating a new redhat server from the ground up and just planning restoring filesystems, including the oracle home
usn_work
use RMAN duplicate database, you can choose then
let him do it, and then restore your duplicate there
cloning the OS might be a good idea
but cloning / restoring a "normal" backup is not
luisgrin
hi
i was working with oracle ok, now i ger ora 12514
spcshpopr8r
usn_work: thanks for your suggestions...very helpful
usn_work
np
luisgrin,
$ oerr ora 12514
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
/ *Cause: The listener received a request to establish a connection to a
/ database or other service. The connect descriptor received by the listener
/ specified a service name for a service (usually a database service)
/ that either has not yet dynamically registered with the listener or has
/ not been statically configured for the listener. This may be a temporary
/ condition such as after the listener has started, but before the database
/ instance has registered with the listener.
/ *Action:
/ - Wait a moment and try to connect a second time.
/ - Check which services are currently known by the listener by executing:
/ lsnrctl services <listener name>
/ - Check that the SERVICE_NAME parameter in the connect descriptor of the
/ net service name used specifies a service known by the listener.
« prev 1 2 next »