Search results for query: *

Hi there, The sqlplus "/ as sysdba " still returned that Oracle wasn't available. The output of ipcs -lm is ------ Shared Memory Limits -------- max number of segments = 4096 max seg size (kbytes) = 256416 max total shared memory (kbytes) = 8388608 min seg size (bytes) = 1 While...

Hi, I tried installing Oracle on RedHat Linux 7.3 and I'm having 2 issues: 1. The Oracle Net Configuration Assistant hangs, so I stopped it. 2. When I try to SQL plus to it, I get the following error: ORA-27101: Shared memory realm does not exist. I'm a new Linux user, so I'd appreciate a...

Actually, I'm not using DBMS_STATS for performance per se. I want to do some profiling of my data and hoping I could use some existing packages for performance's sake. Actually, I could really just do a select distinct p1 from T to get the distinct values. Thanks for the help. Ron

Hi all, I want to use DBMS_STATS to gather column value histograms, but it seems that there's a maximum number of buckets allowed - around 250 I think. Is this the case or am I missing some syntax? What I want to do is run the histograms so I can get the distinct values available for a given...

Hi there, I was hoping someone could comment on the performance of Java in the database. I don't intend to do anything fancy. All I want to do is do something like insert into t select c1,format(c1),c2,format(c2) from t1; where format is a static Java method wrapped in some call spec. So I'm...

Hi guys, Just wondering: if column A values are unique in a table with 2 columns A and B, is it safe to say that A->B, meaning B is functionally dependent on A? Thanks!

Hi there, I am currently using the sys_guid method of Oracle to generate unique ids for an application. However, the id generated is 16 bytes(128 bits) in its hexadecimal representation. This large number of bytes does not fit in a number data type(of length 38) which can only take 126 bits...

Hi there, I'm executing this sql statement: select c.name from paris.table1 c,table1 t where c.id = t.id where paris is a schema in the same database. When I execute this statement, I get the end-of-file on communication channel error. Any ideas? Thanks!

Does analyzing the table improve the index rebuilding speed? My understanding is that it only improves selectivity of the table. Anyways, I'll try that idea and see if it improves my situation. Thanks!

Hi, I created an application that inserts a number of records into a certain table. The problem is that the 6 VARCHAR2(500) columns of this table are indexed, and when inserts are done on this table, the tkprof disk access value increases 6 times from ~2000 to ~12000. I dropped these indexes...

Hi, I tried using the database configuration assistant to delete an Oracle instance, but I'm getting an ORA-12560 error. What should I do to fix this? I already created a separate instance so I just want to drop this other one. Another thing is: I want to completely uninstall Oracle and get...

Hi there, I'm running a PL/SQL script that is doing updates using a statement like this: update t set id = decode(id,a,b,id), id1 = decode(id1,a,b,id1), and so on. This statement is being invoked within a forall statement so I'm avoiding the expensive SQL-PL/SQL context switch. Is...

Hi all, I'm getting myself into bioinformatics and I find that perl is the language of choice for parsing sequences and the like. I would like to use Ruby for this, but I'm just worried at the performance compared to Perl. It seems some unofficial benchmarks say that Ruby is 2-3x slower than...

Does anyone know how to initialize MD5 from DBMS_OBFUSCATION_TOOLKIT with a secret key generated from a user defined string? Basically, I initialize a secret key generator with an algorithm like HMACMD5 and a string like 'Hello there'. This will then generate a secret key that will be used by...