Oracle

Change ip address on 10g / windows 2003 rac nodes
We need to change all our ip addresses of all oracle servers. My specific concern is what we may need to consider for managing change:- The following example is my priority 1) changing addresses on nodes which form a 10.2.0.3 ee rac on windows 2003 regards Chris B ... 9 Jul 2008 15:46

Few big or many small datafiles per tablespace?
We are on 10.2.0.4 on Linux SLES-10 (64-bit) and we are analyzing the IO setup of an OLAP/DWH system (about 800GB in total). We have a large table of about 50 GB in size and it is stored in its own tablespace. Now the question comes up whether few big (say 2 x 25GB) or many small (say 25 x 2GB) datafiles are more... 11 Jul 2008 11:59

Partitioning Best Practices
10gR2 EE with Partitioning. I'm interested to hear peoples opinions on the following scenario. I have a 500 million row table which is partitioned by date (weekly). I'm trying to decide between specifying a maxvalue partition or not. Advantages of MAXVALUE: If we run out of partitions we have a catchall p... 10 Jul 2008 18:35

Disk Utilization alert
Hi Our database generated an alert with a message that reads: Disk Utilization for 1 D: is 98.61% This was generated by the default rules available in 10g. We think it means there's more activity than normal on the disk, but not too sure what to do about it. I don't think we've changed our application in an... 9 Jul 2008 13:42

Incorrect Query
Hi, I'm trying to use an analytic function to get the first row in a group ordered by a date. SELECT customer_id, action, FIRST_VALUE(TRUNC(action_date)) OVER (PARTITION BY customer_id ORDER BY action_date DESC) AS LAST_DATE FROM email_product_hist ORDER BY customer_id; Customer ID Action Act... 9 Jul 2008 14:44

Can you prevent commits from a client application?
10g. Is there any way to alter a session and prevent ANY commits (at least until a subsequent call to remove the alteration)? I'm using the following statement to prevent commits in any procedures (ALTER SESSION DISABLE COMMIT IN PROCEDURE), but I need a way to prevent accidental commits from within a client applic... 23 Aug 2008 17:35

Changing DBID
Is there a way to reset the DBID of a database to a specific value? For example in the case if a duplicated database, I want to reset the DBID of the auxiliary DB to it's original DBID after the duplication is complete to make maintenance on the old backups easier. The auxiliary database in question is a test d... 17 Jul 2008 14:46

Last sync of a context index
Hi, I want to find out when the last synchronization of the context index was done. I'm using the package ctxsys.ctx_ddl.sync_index. In the dba_objects table I just see the creation time of the index not the last synchronization. Thanks & Regards Michael ... 8 Jul 2008 08:59

Could I use user define function as default value of a column?
I wanna add a user define function as default value of a column.But oracle raise an error.Could I do that? Thanks a lot! Jack.Lee ... 8 Jul 2008 13:06

ORA-12514
Hello, Have a 10g database on Solaris. Need to connect with an ordinary unix user ie not oracle. can connect with sqlplus username/password with the ORACLE_SID set in environment But if I append the SID like so: sqlplus username/password(a)REPORT I get "ORA-12514: TNS:listener does not currently know of service ... 8 Jul 2008 07:57