dbTalk Databases Forums  

Sponsored Links


comp.databases.oracle.server comp.databases.oracle.server


Discuss in the comp.databases.oracle.server forum.



Post New Thread
Threads in Forum : comp.databases.oracle.server Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I am on Oracle 10.2.0.4 on HP UNIX 11.2. I am running a program which has an infinite loop. Each loop iteration sleeps for 15 seconds, does some...
zigzagdna
03-21-2011 09:40 PM
zigzagdna Go to last post
4 39
Dear all, I came across a question I was not able to answer. I create a VIEW in Oracle 10g like this: -- --------------------------- CREATE OR...
NewUser2008
03-17-2011 06:45 PM
onedbguru Go to last post
14 82
I tried to get the way to get comma seprated values, except listagg or wm_concat. You may have a look on what I tried to get dept wise comma...
Nimish Garg
03-16-2011 10:16 PM
Nimish Garg Go to last post
5 48
Hi, I need to take the elapsed time / response time / query execution time alone of a particular query. For example, if i try to take the response...
raja
03-16-2011 06:56 PM
onedbguru Go to last post
8 46
I know that Oracle 10g can utilize Oracle 11g ASM. Can it also use 11g CRS? I am getting ready to convert my last 9.2.0.8 DB to 11G. Here...
Mladen Gogala
03-14-2011 06:33 PM
onedbguru Go to last post
15 88
Hello, I have XE 10. 2 on linux, 3-4 times a day data gets written into this database, which actually overwrites what was there before.. What I want...
syd_p
03-10-2011 01:50 PM
joel garry Go to last post
7 39
Hi All, Three node cluster on Enterprise 10.2.0.4 SLES 10 64 bit Can anyone tell me why the following may full scan the partition...
Steve Howard
03-09-2011 02:53 PM
Steve Howard Go to last post
6 45
On Mar 8, 2:30*pm, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote: Preston, I am not spamming on this group, as many other r doing with...
Nimish
03-08-2011 11:36 AM
joel garry Go to last post
8 36
Is it more frequent than that? Of course when I actually need to log an SR ( happens rarely usually I am self service ) the system is not exactly...
John Hurley
03-05-2011 03:15 PM
John Hurley Go to last post
2 40
How can I use the departments table ? Should I use the HR,oracle login or with scott,tiger login ? Thanks
happy
03-04-2011 12:13 PM
Mark D Powell Go to last post
1 41
I have a data table like this (Oracle 10.2.0.3.0): SQL> set null '---' SQL> select day, value_a, value_b from x where day>=date'2007-01-01' order by...
yossarian
03-04-2011 02:26 AM
yossarian Go to last post
8 45
Surely using any size sample, even auto, means that the actual rows sampled (ignoring sample size aspect) are different each time so in theory the...
Noons
03-02-2011 02:37 PM
Noons Go to last post
7 36
patch (Multi-page thread 1 2 )
On Mar 2, 1:01*am, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote: Of course I disagree (except as to the full text quoting), and...
harry
03-02-2011 11:26 AM
joel garry Go to last post
15 72
Hi Just wanted to know if this was (coneceptually) feasible and supported to get from 10gR2 to 11gR2: - build new 11g database - export from 10g...
Jeremy
03-01-2011 03:28 PM
Jeremy Go to last post
5 40
We have 2 job openings for Oracle DBA's in downtown Chicago. The job description is below. Thank you for your help. Please call me as soon as you can...
Christi L
03-01-2011 11:33 AM
Mark D Powell Go to last post
2 32
Hi, Is there a good way to convert a date to the Unixtimestamp? We need to do this. I used the function below, but our developers are tells us it...
The Magnet
02-28-2011 03:51 AM
Robert Klemme Go to last post
3 39
Hi, We have a query which has a surprising plan. I assume Oracle considered the right plan, but rejected it. Is there any way to tell it that...
Tom Anderson
02-26-2011 04:19 AM
Jonathan Lewis Go to last post
3 35
On 16.02.2011 20:24, Tom Anderson wrote: Well, OR-Mappers are typically not very fast since they tend to handle every single instance individually...
Robert Klemme
02-25-2011 10:57 AM
Tom Anderson Go to last post
6 36
I converted a single instance to RAC manually. I re-created the control file, I added & enabled an additional logfile thread, additional undo space...
Mladen Gogala
02-25-2011 10:48 AM
Mladen Gogala Go to last post
2 36
Hi, Oracle 9.2.0.8 Enterprise (Linux) MySQL (Windows) Could anyone provide me with a solution(s) to export/migrate schemas from Oracle to...
trub3101
02-23-2011 09:29 PM
Steve Howard Go to last post
6 32
All, I hope this is not too vague of a question, but let me know if better clarification is needed. I am going to be replacing a...
seanD
02-23-2011 08:26 AM
Mark D Powell Go to last post
3 32
Dear All, Let me know if you have anyone available for the below position, please send resumes with rate, location and contact details: Job Title:...
Isaac
02-21-2011 12:02 PM
Mladen Gogala Go to last post
1 33
Oracle 11.1.? on Linux We are using partitioned tables, partitioning by interval, so partitions are automatically created as we need them. Part of...
Adrian
02-20-2011 04:06 PM
John Hurley Go to last post
5 34
I was comparing 2 SQL statements which produce the same result. Here are the statements: with e(empno,mgr,lev) as ( select empno,mgr,1 from emp...
Mladen Gogala
02-19-2011 12:52 PM
Randolf Geist Go to last post
6 29
Just got a call from some Oracle customer rep with a difficult Indian accent, telling me support prices will increase 10% for those who don't upgrade...
joel garry
02-18-2011 05:33 PM
John Hurley Go to last post
11 48
Has anyone upgraded to 11.2.0.2 (rac and non-rac) yet and would you say it is better or worse that 11.2.0.1+NovPSU??
onedbguru
02-17-2011 11:29 AM
John Hurley Go to last post
2 36
i have a problem for "before insert or update" trigger. Currently this trigger records old table X record in dedicated X_HIST table (same structure...
Frank Bergemann
02-16-2011 11:19 AM
joel garry Go to last post
5 31
Looks like OEL 5.6 just became available last month ... http://oss.oracle.com/el5/docs/RELEASE-NOTES-U6-en.html
John Hurley
02-16-2011 08:25 AM
John Hurley Go to last post
3 34
I invested quite some time in learning the thing, as it seemed very similar to Oracle. Unfortunately, when it came down to the pilot project, the...
Mladen Gogala
02-15-2011 02:21 PM
Mladen Gogala Go to last post
65 182
Hello out there, I tried to configure alerts for full tablespaces using dbms_server_alert.set_threshold. Since we do not have licensed diagnostics...
Lothar Armbrüster
02-12-2011 01:10 PM
onedbguru Go to last post
6 25
I've only just come across this possible SQL bug and was wondering why this SQL returns a result? I got it through an email and had to change it to...
DG problem
02-11-2011 06:46 PM
Noons Go to last post
16 56
oracle 10.2.0.4 enterprise windows 2003 service pack 2 1) Code we use is driven by concept of list of stale objects at table level eg...
dba cjb
02-10-2011 07:22 PM
onedbguru Go to last post
2 26
Hi I figured that you need people like me to ask questions in cdos to keep it going ;) I am trying to help a colleague work out why something...
Jeremy
02-10-2011 09:21 AM
Jeremy Go to last post
3 24
On Wed, 09 Feb 2011 09:54:09 -0800, ddf wrote: David, V$SORT_USAGE and V_$SORT_USAGE are synonyms. QL> select table_owner,table_name from...
dba cjb
02-09-2011 12:49 PM
Mladen Gogala Go to last post
7 30
( Sorry a repeat of blog posting ... ) I get grumpy when I see negative serial#'s in v $session_connect_info ... this is almost enough to make a...
John Hurley
02-08-2011 01:41 PM
John Hurley Go to last post
4 33
Hi This is on 10gR2 / 11gR2 We have a simple "hello world" type java proc in the database which we can access via a pl/sql wrapper - works...
Jeremy
02-07-2011 04:30 PM
Thomas Olszewicki Go to last post
5 32
Have a load of this: http://it.toolbox.com/blogs/database-soup/why-postgresql-doesnt-have- query-hints-44121?rss=1 This is just phenomenal! The...
Mladen Gogala
02-05-2011 06:15 AM
Noons Go to last post
1 33
Dear group, We are moving our Oracle database on redhat 4 10.2.0.4 to redhat 5 and upgrade it to 10.2.0.5 so, on server A(redhat 4), i took a hot...
charles
02-04-2011 10:12 PM
bdbafh Go to last post
6 36
Hi, The following code will stop working if I remove the (xmlns=""). As I don't control the web-service that generates the XML (and omits the null...
Richard Maher
02-04-2011 04:27 PM
Richard Maher Go to last post
5 40
http://www.oracleobserver.com/?q=node/28 seems to have an unnecessary use of dual, or am I missing something? It seems to work fine for me without...
joel garry
01-31-2011 07:35 PM
John Hurley Go to last post
15 50
Per the subject line, this drives me bonkers. I have a particular error message for which I am searching a solution. All I end up with are hits for...
Steve Howard
01-24-2011 04:06 PM
jimmyb Go to last post
9 32
I was looking around because of some performance problems with Direct NFS, but it seems nobody has problems with Direct NFS. Or is nobody using...
Gerard H. Pille
01-22-2011 05:51 PM
Noons Go to last post
24 68
Hi, i wonder why this doesn't work: --------------------- snip ---------------------------------------- set serveroutput on drop table tabx; /
Frank Bergemann
01-21-2011 06:43 PM
Tim X Go to last post
6 31
We keep running into suboptimal query plans with 11g and then we run into slow queries and once we collect stats, things get better again. How can...
RF
01-19-2011 08:55 AM
Mark D Powell Go to last post
6 32
On Jan 18, 1:41*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote: LOL! Join the club!
Mladen Gogala
01-18-2011 10:48 AM
joel garry Go to last post
4 28
I want to build an oracle function, in a 10g Unicode database, that accepts a varchar, of any length, and returns a translation. It will translate...
oldyork90
01-17-2011 04:11 PM
onedbguru Go to last post
5 33
Hi, I have some Mviews for query rewrite it takes 15-20 minutes to create them The refresh takes more than 5 hours ... why ? What can I do to speed...
bob123
01-16-2011 04:33 PM
JohnEllis Go to last post
11 52
With rule-based it was quite easy: you made sure an index on that column was used and the results returned in the desired order, immediately. But if...
Frank Bergemann
01-14-2011 01:59 AM
Gerard H. Pille Go to last post
4 32
Dear group, We are using Oracle 10g on linux RAC with 4 nodes. We have a small table, no more than 300 rows, but most people will...
charles
01-13-2011 04:14 AM
Jonathan Lewis Go to last post
5 34
I have a SR priority 2, ORA-07445. SR Number is 3-2695873331. They haven't responded in five days. Look at this: Update from Customer 10-Jan-2011...
Mladen Gogala
01-11-2011 09:29 PM
Mladen Gogala Go to last post
6 29
Post New Thread

Display Options
Showing threads 601 to 650 of 17885
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.