Search results for query: *

Question is simple.. Under what circumstance should we start thinking of rebuilding the index? i have seen people talking about Index clustering factor, height of the b-tree within a B*Tree index etc but confused on what these could mean and how they actually affect the rebuilding the index...

I get the ORA-01555 Snapshot too old error when I am trying to get the historical data using the flashback query My UNDO_RETENTION is set at 900 Thanks Engi

Has there been any instance anywhere wherein because of Oracle there has been thread handing and BEA WL server crash with a BEA-000337? The reason I am trying to relate these two is that our WL server hangs and then finally disconnects itself from DB and says that it unable to ping the DB. I...

Has there been any instance anywhere wherein because of Oracle there has been thread handing and BEA WL server crash with a BEA-000337? The reason I am trying to relate these two is that our WL server hangs and then finally disconnects itself from DB and says that it unable to ping the DB. I...

Can someone help ? 2007.06.20 22:52:59 MQJMS1023E rollback failed 2007.06.20 22:52:59 MQJMS1023E rollback failed <Jun 20, 2007 11:02:03 PM CDT> <Error> <WebLogicServer> <BEA-000337> <ExecuteThread: '1' for queue: 'weblogic.kernel.Default' has been busy for "818" second s working on the request...

What is this dbms_pickler? Why scould it cause a core dump? here is what I found in the trace file ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x35E6786] [] [] [] [] Current SQL statement for this session: begin :1 :=...

I have run through a lot of articles on these columns but none gave me satisfactory explanation. Could one of you provide me with the same? Thanks Engi

Could someone point me or help me with some tips & tricks in change management? Thanks Engi

Hi, I have query inside a package which takes a form as below select x, y, (SELECT a, b From P inner join (select c,d from Q where q.k = a.k) xx ON P.C = xx.C) z, t, u from a .... Now this code works fine on our local...

Which of these two is better w.r.t performance? Select x,y, From a where C is null OR Select x,y, From a where C = 0 I can change the data within the table to 0 from null if the later is better. I am looking a rows that run into couple of 1000s

Hi, I am right now involved in a a lot of Code review actiivities. As a part of this i am also looking into the SQL queries to see if any of these are badly written. The one common thing that I come across is that the queries do Full Table Scans. i would like to understand the situations...

Hi, Is there any way that I get the TIMESTAMP to return 3 digit precision of milliseconds instead of 6? I tried setting the NLS_TIMESTAMP_FORMAT, but didn't work!!! Please help!!! Thanks in Advance!! Engi

Hi, Please help me on this one as it is critical on our architecture. My app server connects to the DB server and places a lock on a row (SELECT..FOR UPDATE). After few seconds, while still holding the row lock, the connection fails. My question is after how much time will the Lock be...

Hi All, I am facing a typical issue using Types in Java. Scenario I have two schemas A and B. I have all Types created in Schema A i.e A is the owner of the Types. I also have a role Role_X that has been granted EXECUTE priv on these types. Now the Role (Role_X) has been granted to Schema...

Hi can anyone help me with this I have a table that is partitioned, lets say P1 and P2. If i need to select from P1 or P2 i mention that Partition name within my SELECT. I have two queries 1. What if I dont provide any Partition but within my WHERE mention the Column on which the partition...

Hi, Our local development database server's sort of crashing with the "ORA-12516: TNS: listener could not find available handler with matching protocol stack" error. The first time it happened the DBA increased the connection pool size. But today it happened again. Is there a permanent fix...

Greetings All, I have a JSP that send me a Binary Stream of data to a Oracle 9i Stored Proc. This SP accepts the Binary Stream into a BLOB. We are facing a problem in that, when we try to call this SP from within JSP for a file with size ~3MB, an exception is raised which is something to do...

I have an index on a column (Varchar2 - i know bad idea, but its already there). Now there is a requirement that the size of this column needs to be increased. Could someone help me understand if there will be any impact on the index organization? if yes and -ve impact what should I consider...

We are designing login window which would allow user to login to our application. We have attached profile which would expire user password in 80 days with 10 days grace period. Now, when password expires Oracle throws "ORA - 28001 : The Password expired....." In SQLPlus user is forced to...

I would like a small query that would check a Date value to be between yesterday 1600hrs to today 1600hrs. Thanks in Advance -Engi