Calculating concurrent users based on active members in DB
Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address...
Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address...
5 pts.
The most-watched IT questions this week: Nov. 3, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
SAP Oracle DBA security privileges
What roles, privileges, transactions should we allow the Oracle DBA to use and access. Presuming DEV-PROD. Were moving the DBA role out of the BASIS group. We know all DB.. transactions, plus ST22, and looks like SE11 and SE16 are suggested. Thank you for your help. Software/Hardware used:...
What roles, privileges, transactions should we allow the Oracle DBA to use and access. Presuming DEV-PROD. Were moving the DBA role out of the BASIS group. We know all DB.. transactions, plus ST22, and looks like SE11 and SE16 are suggested. Thank you for your help. Software/Hardware used:...
Oracle table update exist ?
dear all, i want implemente a update on many table but i don't know the syntax please help me. My update is at less on 5 table
dear all, i want implemente a update on many table but i don't know the syntax please help me. My update is at less on 5 table
isa server 2006
I install isa server 2006 internet is working fine but i enable isa client firewall in client side that time externel email working but oracle application not working when i disable isa client firewall externel email not working but oracle application is working fine i want working both oracle...
I install isa server 2006 internet is working fine but i enable isa client firewall in client side that time externel email working but oracle application not working when i disable isa client firewall externel email not working but oracle application is working fine i want working both oracle...
How to convert LONG to CLOB or to VARCHAR type in select statement
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
Entering more than 45 data Selection Values in Data Selection for Version in Version List in DreamWriter
How do I enter more than 45 values for a field (this appears to be an upper limit - with only 45 fields (15 lines of 3 fields per line) available on the display) within Data Selection Values for a Version on Version List in DreamWriter in JDE. Thank you to anyone for helping with this.
How do I enter more than 45 values for a field (this appears to be an upper limit - with only 45 fields (15 lines of 3 fields per line) available on the display) within Data Selection Values for a Version on Version List in DreamWriter in JDE. Thank you to anyone for helping with this.
The IT Blog Top 10: Oct. 29, 2009
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...
Error installing linux on Dell Poweredge 2950
I'm trying to install Novell Linux OS on a Dell Poweredge 2950 server. 64-bit with raid and sas drives but i am getting a "no hard disk found" error Software/Hardware used: Dell poweredge 2950, Novell Linux, Linux,
I'm trying to install Novell Linux OS on a Dell Poweredge 2950 server. 64-bit with raid and sas drives but i am getting a "no hard disk found" error Software/Hardware used: Dell poweredge 2950, Novell Linux, Linux,
Configuring listener.ora
This is regarding Oracle 10g networking. On the server side I had configured listener.ora. and on the client side I had configured tnsnames.ora, but when I started listener.ora I got an error: tns name is incorrect. Could u please explain to me how to configure on Linux? Software/Hardware used:...
This is regarding Oracle 10g networking. On the server side I had configured listener.ora. and on the client side I had configured tnsnames.ora, but when I started listener.ora I got an error: tns name is incorrect. Could u please explain to me how to configure on Linux? Software/Hardware used:...
Data Guard implementation for Oracle 10gR2
I am making a standby database for dataguard on 10.2.0(windows 2003 VmWare) following this tutorial. I am confused about the standby database creation. I successfully configured the PD with these steps, but I simply ran the oradim command for the standby databae creation then mounted the database...
I am making a standby database for dataguard on 10.2.0(windows 2003 VmWare) following this tutorial. I am confused about the standby database creation. I successfully configured the PD with these steps, but I simply ran the oradim command for the standby databae creation then mounted the database...
Flash Recovery Area in Oracle 11g
What is the easiest way to handle the flash recovery area in Oracle? I'm having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind after the...
What is the easiest way to handle the flash recovery area in Oracle? I'm having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind after the...
How can automatically execute a oracle process
Give me the steps to create a batch file or some executable to run a oracle process (form/report) at any given time. Eg. Every day at 10 PM
Give me the steps to create a batch file or some executable to run a oracle process (form/report) at any given time. Eg. Every day at 10 PM
sql query
i am working on a project. If i enter the a/c no and i found correct then the companies name and their share values are provided to me.. After that when i buy a no of shares i get the Transaction amount(no of shares*share value),broker value(1.5% of transaction amount),total amount (transaction...
i am working on a project. If i enter the a/c no and i found correct then the companies name and their share values are provided to me.. After that when i buy a no of shares i get the Transaction amount(no of shares*share value),broker value(1.5% of transaction amount),total amount (transaction...
Oracle 9i install failure
Friends, i am using 1gb ram, 80 gb hard drive, i am trying to install 9i on my desktop pc of above config. After the installation of database, before installation of configure tools, oracle db configuration assistant and oracle intelligent agent are failed to install..(The first two were installed...
Friends, i am using 1gb ram, 80 gb hard drive, i am trying to install 9i on my desktop pc of above config. After the installation of database, before installation of configure tools, oracle db configuration assistant and oracle intelligent agent are failed to install..(The first two were installed...
About Time
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet Software/Hardware used: OC
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet Software/Hardware used: OC
Oracle usernames
I have installed Oracle but when I’m starting Oracle *Plus it is not accepting the username and password 'scott and tiger' and 'system manager.' It is also not accepting these user names and passwords. Software/Hardware used: Oracle 10g
I have installed Oracle but when I’m starting Oracle *Plus it is not accepting the username and password 'scott and tiger' and 'system manager.' It is also not accepting these user names and passwords. Software/Hardware used: Oracle 10g
Forms and Reports Beginners level Coding Sites
I studied oracle forms and reports books i am developing the form through wizard only not by code but i need better site which is beginners level practise forms and reports coding i always my wishes to anyone who are helping me Thanking You
I studied oracle forms and reports books i am developing the form through wizard only not by code but i need better site which is beginners level practise forms and reports coding i always my wishes to anyone who are helping me Thanking You
MERGE using DECODE logic to control UPDATE
MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...
MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...
Oracle: Can a character set be changed after a schema has been created?
My boss was so pleased with the response from this site that he asked me to ask another question! He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!). In any case, we build a new db (schema) prior to...
My boss was so pleased with the response from this site that he asked me to ask another question! He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!). In any case, we build a new db (schema) prior to...
