Need help with a slow pl/sql script
Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ----------------------------------spool noaddressusagerelfix.LOGset timing on;SET SERVEROUT ON;DECLAREvpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE;vI_OCPOSTAD_USAGES ...
View Answer
| May 23 2008 11:00 AM GMT
| asked by
Darrankavanagh
PL, SQL, script
Options available for implementing external account authentication with Windows AD with Oracle 10.2.0.3 on Linux
Scenario: Windows desktop user logs in to the Windows domain and is authenticated by Windows Active Directory. The same user then lauches a Citrix session to connect to an application running on a Windows Citrix server and is authenticated using Windows passthrough authentication. The...
Answer Question
| Apr 23 2008 5:17 PM GMT
| asked by
JPGDBA1968
Oracle 10.2.0.3, Linux, Oracle Internet Directory
ASM State in GMON Trace File
Oracle 10.2.0.3 RAC using ASM:Red Hat Enterprise 2.6.9.44 (RHEL 4.4)I have having problems bringing up a diskgroup in ASM. When I try to mount it, ASM hangs. When I review the GMON trace file, it shows the diskgroup trying to mount and is says "Member state = 4". What's a member state and what are...
Answer Question
| Apr 14 2008 2:39 PM GMT
| asked by
Dwaltr
Oracle administration, ASM, Red Hat Enterprise Linux
Where does Oracle automatic backup create the backup file?
I have created one database through DBCA on Oracle 10.1.0.2.0 and choose automatic backup daily at 2 am. But I cannot see any backup that is done under Oracle flash recovery area. Does it create in any other place? No error message was found in alertlog. Any ideas?
Answer Question
| Apr 10 2008 3:18 PM GMT
| asked by
OracleATE
Oracle backup, Flash Recovery, DBCA
Export Oracle 10g and Import to Oracle 9i
I have a data warehouse server that's running Redhat AS 2.1 and Oracle 9.2.0.4, and a production database that's running Redhat AS 4.0 and Oracle 10.2.0.3. I need to export tables from the Oracle 10g database and import them into the Oracle 9i database. The Oracle 10g server/database is new. I...
View Answer
| Mar 17 2008 7:36 PM GMT
| asked by
Llewis
Oracle Import/Export, Oracle 10, Oracle 9
Oracle 10.2.0.2 on AIX5L
we installed oracle 10.2.0.2 on AIX 5l, we heard that there are performance issues with indexing (Oracle may pick the wrong index) . Has anyone had similar experiences and if so, what patches have you applied to resolve the problem?
Answer Question
| Mar 6 2008 7:45 PM GMT
| asked by
Jpenn
Oracle 10, AIX 5L, AIX
Parameter file
Hi I have installed Oracle 10g Win 2003 server, as I know there are 2 parameter files one is dynamic and other is static. how do I know that which parameter file is being used? If I go to EM DBcontrol "all Initialize parameter file" I can see SPFILE is disabled, means dynamic parameter file is not...
View Answer
| Dec 18 2007 12:37 AM GMT
| asked by
Sr1234
Oracle 10, EM DB Control, Oracle Enterprise Manager
Why numeric data truncated to be integer when declaring NUMBER data type in Oracle 10g
Hello, My company recently upgraded Oracle server form 9i to 10g and I was requested to load all tables data from 9i to 10g. Most data transfer are good except this situation:If 9i table with date type declared as NUMBER, all numeric data will be truncated as integer in 10g (I used the same...
View Answer
| Nov 30 2007 9:55 PM GMT
| asked by
Sleu
Oracle 10, Oracle NUMBER data type
Tracing on Oracle 10
Hi, In order to get tracing info on Oracle 9 I added the following to the SQLNET.ORA TRACE_UNIQUE_CLIENT=on TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = C:\Oracle10Run TRACE_FILE_CLIENT = SQLNetTrace TRACE_TIMESTAMP_CLIENT = ONThis worked fine and generated the relevant trace files.When I...
Answer Question
| Oct 5 2007 3:00 PM GMT
| asked by
Eg
Oracle 10, Oracle
