How to auto-enable a password protected role
Hello out there, I'm currently testing the migration of our application from Oracle 10.2.0.4 to 184.108.40.206. All tables of the application belong to one schema. Access to these tables is granted to a password protected role which is enabled at application start using the command set role <role> identified by <pwd>... 23 Apr 2010 20:39
What does the COST(%CPU) in explain plan mean?
Hi all I have an explain plan like below. and I doubt about the COST. How is the COST be calculated? I mean what does that mean? (CPU rate?) SQL> @?/rdbms/admin/utlxpls.sql PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- Plan hash value: 1764098166 ----... 20 Apr 2010 15:42
Can you nest DECODE with different field criteria? Here is our DECODE: DECODE(SUM(DECODE(subproduct_id, 238, 1, 0)) OVER (PARTITION BY customer_id),0,'N','Y') ultimate_trader Now, with that, if the result is Y, meaning that they DO have this 238 product, I want to see if they have a status = 'Active'. So, ... 17 Apr 2010 16:18
11gR2 Or 10gR2 on Linux x64?
Hi all I want to use the newest 11gR2 in a new project. But my boss said 11gR2 is too new. 10gR2 is the best. I want to know if there are some fatal bug report about 11gR2 on Linux ? And is 11gR2 more available with 10gR2? Thanks. Best Lau Lu ... 16 Apr 2010 16:11
Oracle RMAN Catalog vs. controlfile advantages
Can someone point me to exact list of things we'd lose w/o running w/ catalog? After upgrade to 10.2.0.5 on Grid Control we have random job failures w/o any clear cause, and prior to that we already had a number of databases which had performance issues (resyncing with catalog forever). Yes, we do have a number ... 13 May 2010 12:40
Copying Backup of 32-bit Win2000 10g Database into a 64 Bit Win2003 Server
if_investor(a)yahoo.com wrote: Hi, We have a cold backup of a 10.2.0.2 database from a 32-bit Windows 2000 environment. We would like to copy that database into a 10g 64-bit Windows 2003 environment. We already have the 10g binaries (Also 10.2.0.2) installed on x64 Win2003. Can this b... 14 Apr 2010 06:34
oracle sql profile - need help please
Hi folks Enterprise Manager suggested a better plan for me (Oracle 10.2.3 / Solaris64) and I went for it. However, it doesn't look like it's being used at all. EM still shows the SQL using the inefficient plan. SQL> l 1 begin 2 dbms_output.put_line( 3 dbms_sqltune.accept_sql_profile( 4 task_name... 13 Apr 2010 13:55
importing DBMS_SCHEDULER jobs - date formatting problem...
Hi all. I have 2 10.2.0.4 Standard Edition 64-bit instances, on 2 separate servers - both running on Win2003 Server x64 OSs. One of these physical servers is Win2003 R2 - if that makes a difference. I have a schema which I am trying to import into a database on each of these servers. The schema import conta... 12 Apr 2010 17:00
Advanced Compression – how much compression was done?
I am using Oracle 11g (11.1) on HP UNIX 11i. I have set some tables using Alter table mytable compress for all operations; Lots of data is being inserted into this table. I want to find how much disk space was reduced because of compression. I cannot take all this data and create another table without compressio... 11 Apr 2010 23:25
Avoiding refresh in MV replication
All, I have master table t ( col1 primary key , col2) has snapshot log on t and has Materilased view MV_T on table t , Table t has 2 million records. When I add column col3 in table t with some default value ( -2). mlog captures all these delta and pushes again 2 million to MV_t. I want to avoid this ... 12 Apr 2010 13:38