Performance degraded after changing optimizer mode
Hi all, I facing a strange problem. Please help me. Server = Windows 2003 Oracle version – oracle 9.2.0.1.0 (standard edition) I have done the some changes at my client side. I done changes as follows.. 1) Tunning has done on dated 22/10/05 i) The database archive log mode has changed to Archive log mode. [...]
Answer Question
| November 3, 2005 2:49 AM
Oracle, Windows
Hi all, I facing a strange problem. Please help me. Server = Windows 2003 Oracle version – oracle 9.2.0.1.0 (standard edition) I have done the some changes at my client side. I done changes as follows.. 1) Tunning has done on dated 22/10/05 i) The database archive log mode has changed to Archive log mode. [...]
Answer Question
| November 3, 2005 2:49 AM
Oracle, Windows
Knowing the number of rows in a cursor
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]
Answer Question
| October 27, 2005 5:19 PM
Database, DB2, Oracle, SQL, Windows
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]
Answer Question
| October 27, 2005 5:19 PM
Database, DB2, Oracle, SQL, Windows
oracle error
Hi, pl respond urgently The following error has occured while executing a package. The following error has occurred: ORA-21000: error number argument to raise_application_error of -6508 is out of range ORA-06512: at “ECW_LOADER.CREATE_CTL_RANGES”, line 154 ORA-06512: at line 19
Answer Question
| October 25, 2005 2:58 AM
Oracle, Windows
Hi, pl respond urgently The following error has occured while executing a package. The following error has occurred: ORA-21000: error number argument to raise_application_error of -6508 is out of range ORA-06512: at “ECW_LOADER.CREATE_CTL_RANGES”, line 154 ORA-06512: at line 19
Answer Question
| October 25, 2005 2:58 AM
Oracle, Windows
Database Upgrade
1) I am migrating a database to 10G (from 9i) to a new server. The database is the backend for Forms and Reports (currently running 9iAS). How will moving the database to a new server, and upgrading, affect the current application server environment? Other than changing the TNS entry on the web server to point [...]
Answer Question
| October 21, 2005 7:15 PM
Oracle, Windows
1) I am migrating a database to 10G (from 9i) to a new server. The database is the backend for Forms and Reports (currently running 9iAS). How will moving the database to a new server, and upgrading, affect the current application server environment? Other than changing the TNS entry on the web server to point [...]
Answer Question
| October 21, 2005 7:15 PM
Oracle, Windows
Help using oracle Analytical function.
I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from [...]
Answer Question
| October 28, 2005 7:16 PM
Oracle, SQL, Windows
I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from [...]
Answer Question
| October 28, 2005 7:16 PM
Oracle, SQL, Windows
Oracle Hash Partitioning.
Hi, In Oracle hash paritioning do we have control over hash value based on which partitioning is done? My issue is – We have to make a design for datawarehouse application and in the landing area we are planning for range-hash partitionining based on the keys (and their volumes). Now, if we use range-hash paritioning, [...]
Answer Question
| October 14, 2005 1:06 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
Hi, In Oracle hash paritioning do we have control over hash value based on which partitioning is done? My issue is – We have to make a design for datawarehouse application and in the landing area we are planning for range-hash partitionining based on the keys (and their volumes). Now, if we use range-hash paritioning, [...]
Answer Question
| October 14, 2005 1:06 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
Restricted Groups
Hi Guys I have a query regarding the usage of restricted group in a domain enviroment. Could some pls explain the steps required to add Domain Administrator Account to the Local Administrators Groups of a node. I know this can be done but m not sure bout the steps. Please HELP!!!! Thanks Guys Asta La [...]
Answer Question
| October 13, 2005 3:33 AM
Access, Active Directory, Altiris, Availability, Bandwidth, Benchmarking, Bind, Career development, DataCenter, Desktop management applications, Desktops, DHCP, DNS, Ethernet, Fault isolation, FDDI, Frame Relay, General Directories, H.323, Intel, IPv4, IPv6, LANDesk, LDAP, Lotus Domino, Management, Marimba, Microsoft Office, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Novell, Novell IPX/SPX, Novell NDS, OS, Patch management, Performance management, Protocol analysis, Remote management, Security, Servers, SIP, SQL Server, TCP, Updates from SearchWindowsSecurity.com staff, Vector Networks, Windows
Hi Guys I have a query regarding the usage of restricted group in a domain enviroment. Could some pls explain the steps required to add Domain Administrator Account to the Local Administrators Groups of a node. I know this can be done but m not sure bout the steps. Please HELP!!!! Thanks Guys Asta La [...]
Answer Question
| October 13, 2005 3:33 AM
Access, Active Directory, Altiris, Availability, Bandwidth, Benchmarking, Bind, Career development, DataCenter, Desktop management applications, Desktops, DHCP, DNS, Ethernet, Fault isolation, FDDI, Frame Relay, General Directories, H.323, Intel, IPv4, IPv6, LANDesk, LDAP, Lotus Domino, Management, Marimba, Microsoft Office, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Novell, Novell IPX/SPX, Novell NDS, OS, Patch management, Performance management, Protocol analysis, Remote management, Security, Servers, SIP, SQL Server, TCP, Updates from SearchWindowsSecurity.com staff, Vector Networks, Windows
Oracle 10G tuning statements
Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.
Answer Question
| October 5, 2005 9:44 PM
Oracle, SQL, Windows
Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.
Answer Question
| October 5, 2005 9:44 PM
Oracle, SQL, Windows
Cannot see entire network
hi all, i have formatted my system and installed win2kserver.wnen i tried configuring for network printer i am not able to connect to the printer.infact i am not able to access the workgroup itself in which the printer is.when i go to MyNetworkPlaces->EntireNetwork, i don’t see all the workgroups in the network.i tried changing my [...]
Answer Question
| October 6, 2005 7:45 AM
Availability, DataCenter, Desktop management applications, Desktops, Hardware, Management, Microsoft Windows, Networking, OS, Patch management, Security, Servers, Software, SQL Server, Tech support, Updates from SearchWindowsSecurity.com staff, Windows
hi all, i have formatted my system and installed win2kserver.wnen i tried configuring for network printer i am not able to connect to the printer.infact i am not able to access the workgroup itself in which the printer is.when i go to MyNetworkPlaces->EntireNetwork, i don’t see all the workgroups in the network.i tried changing my [...]
Answer Question
| October 6, 2005 7:45 AM
Availability, DataCenter, Desktop management applications, Desktops, Hardware, Management, Microsoft Windows, Networking, OS, Patch management, Security, Servers, Software, SQL Server, Tech support, Updates from SearchWindowsSecurity.com staff, Windows
Looking for a UNIQUE KVM Solution
I’m looking for something unusual in the way of a KVM (Keyboard, Video, Mouse) system, and have no idea where to find such a thing – so I’ll describe it. In this case, I’ll happily take brand names, since this would be a commercial product. As part of my business, I visit sites which are [...]
Answer Question
| October 28, 2005 4:25 PM
Cabling, DataCenter, Dell, Desktops, Hardware, Hewlett-Packard, Hubs, Interoperability, Linux, Management, Microsoft .NET, Microsoft Internet Information Server, Microsoft Office, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches, Tech support, Windows, Wireless
I’m looking for something unusual in the way of a KVM (Keyboard, Video, Mouse) system, and have no idea where to find such a thing – so I’ll describe it. In this case, I’ll happily take brand names, since this would be a commercial product. As part of my business, I visit sites which are [...]
Answer Question
| October 28, 2005 4:25 PM
Cabling, DataCenter, Dell, Desktops, Hardware, Hewlett-Packard, Hubs, Interoperability, Linux, Management, Microsoft .NET, Microsoft Internet Information Server, Microsoft Office, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches, Tech support, Windows, Wireless
AutoUpgrade error: ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors
RDBMS Version: 9.2.0.6 Operating System and Version: Windows 2003 Error Number (if applicable): ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors We are upgrading oracle database to 9.2.0.6 and apps from 11.03 to 11.5.10. while running autoupgrade, we are getting the following error: ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors This is standard oracle package. Anybody experienced this [...]
Answer Question
| September 27, 2005 9:36 PM
Oracle, Windows
RDBMS Version: 9.2.0.6 Operating System and Version: Windows 2003 Error Number (if applicable): ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors We are upgrading oracle database to 9.2.0.6 and apps from 11.03 to 11.5.10. while running autoupgrade, we are getting the following error: ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors This is standard oracle package. Anybody experienced this [...]
Answer Question
| September 27, 2005 9:36 PM
Oracle, Windows
Enabling Java in Oracle 8.1.7 – ORA-29540
I got the error below while trying to UTL_SMTP package to send e-mail: ORA-29540: class oracle/plsql/net/TCPConnection does not exist Apparently my Oracle 8.1.7. db is missing some Java classes. Can someone tell me how to enable Java in 8.1.7?
Answer Question
| September 26, 2005 8:55 AM
Oracle, Windows
I got the error below while trying to UTL_SMTP package to send e-mail: ORA-29540: class oracle/plsql/net/TCPConnection does not exist Apparently my Oracle 8.1.7. db is missing some Java classes. Can someone tell me how to enable Java in 8.1.7?
Answer Question
| September 26, 2005 8:55 AM
Oracle, Windows
Setup an sms to email gateway
Required to setup an sms to email gateway so that customers can SMS the problem they face with Internet or other systems and it can be uploaded into the systems using an email.
Answer Question
| September 19, 2005 2:42 AM
3Com, Access, Availability, Avaya, Bandwidth, Benchmarking, Cabling, Career development, Certifications, Cisco, DataCenter, Dell, Desktops, Enterasys, Enterprise Desktop, Ethernet, Exchange, Fault isolation, FDDI, Foundry, Frame Relay, H.323, Hardware, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, Linux, Looking for a job, Lucent, Management, Microsoft Office, Microsoft Windows, MPLS, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Nortel, Novell IPX/SPX, OS, Patch management, People problems at work -- Get advice here, Performance management, Post a link to your IT resume, Protocol analysis, Remote management, Routers, Security, Servers, SIP, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows
Required to setup an sms to email gateway so that customers can SMS the problem they face with Internet or other systems and it can be uploaded into the systems using an email.
Answer Question
| September 19, 2005 2:42 AM
3Com, Access, Availability, Avaya, Bandwidth, Benchmarking, Cabling, Career development, Certifications, Cisco, DataCenter, Dell, Desktops, Enterasys, Enterprise Desktop, Ethernet, Exchange, Fault isolation, FDDI, Foundry, Frame Relay, H.323, Hardware, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, Linux, Looking for a job, Lucent, Management, Microsoft Office, Microsoft Windows, MPLS, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Nortel, Novell IPX/SPX, OS, Patch management, People problems at work -- Get advice here, Performance management, Post a link to your IT resume, Protocol analysis, Remote management, Routers, Security, Servers, SIP, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows
How to disable export option in 11.5.9 thru applications.
As a security feature,we need to disable export option so that the data cannot be exported to Excel sheet directly . Is there any profile option to do so. Pls advice.
Answer Question
| September 25, 2005 8:02 AM
Database, DB2, E-business, Oracle, Security, Windows
As a security feature,we need to disable export option so that the data cannot be exported to Excel sheet directly . Is there any profile option to do so. Pls advice.
Answer Question
| September 25, 2005 8:02 AM
Database, DB2, E-business, Oracle, Security, Windows
Active Directory/DNS problem in Windows 2003 network
I have just upgraded my 2 DC’s to Win2003 (I totally recreated Active Directory and did a clean install). I set the first DC up with DNS which seemed to work fine. I then set the 2nd DC up with active directory integrated DNS. That seemed to work fine too and it populated itself and [...]
Answer Question
| September 7, 2005 5:38 AM
Active Directory, DataCenter, Desktops, DHCP, DNS, General Directories, Lotus Domino, Management, Microsoft Windows, Network protocols, Networking, Networking services, OS, Security, Servers, Software, SQL Server, TCP, Tech support, Windows, WINS
I have just upgraded my 2 DC’s to Win2003 (I totally recreated Active Directory and did a clean install). I set the first DC up with DNS which seemed to work fine. I then set the 2nd DC up with active directory integrated DNS. That seemed to work fine too and it populated itself and [...]
Answer Question
| September 7, 2005 5:38 AM
Active Directory, DataCenter, Desktops, DHCP, DNS, General Directories, Lotus Domino, Management, Microsoft Windows, Network protocols, Networking, Networking services, OS, Security, Servers, Software, SQL Server, TCP, Tech support, Windows, WINS
Exchange 2003 & MMIS 2002 Server ActiveSync
Currently, we are running Exchange 2000 cluster as back-end and another Exchange 2000 on our DMZ as front-end OWA server, all on Windows 2000 servers. We are also running another Windows 2000 server in our DMZ which we installed MMIS 2002 Server ActiveSync for some Wireless users. In the next couple of weeks we are [...]
Answer Question
| August 29, 2005 8:10 AM
Exchange, Exchange security, Microsoft Windows, Windows
Currently, we are running Exchange 2000 cluster as back-end and another Exchange 2000 on our DMZ as front-end OWA server, all on Windows 2000 servers. We are also running another Windows 2000 server in our DMZ which we installed MMIS 2002 Server ActiveSync for some Wireless users. In the next couple of weeks we are [...]
Answer Question
| August 29, 2005 8:10 AM
Exchange, Exchange security, Microsoft Windows, Windows
Oracle Foreign Keys to Drop
I have a problem where I need to drop certain tables and Create replacements (schema additions/deletions to the tables). Because I have Grandfather-Father-Son table type relationships I have Foreign Keys between them. I need to drop the Foreign Keys but if I build a script to SELECT “ALTER TABLE {TableName} DROP CONTRAINT {ConstraintName}” FROM USER_CONSTRAINTS [...]
Answer Question
| August 19, 2005 3:36 AM
Oracle, Windows
I have a problem where I need to drop certain tables and Create replacements (schema additions/deletions to the tables). Because I have Grandfather-Father-Son table type relationships I have Foreign Keys between them. I need to drop the Foreign Keys but if I build a script to SELECT “ALTER TABLE {TableName} DROP CONTRAINT {ConstraintName}” FROM USER_CONSTRAINTS [...]
Answer Question
| August 19, 2005 3:36 AM
Oracle, Windows
Library management system
i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse
Answer Question
| August 20, 2005 5:39 AM
3Com, ABAP, Access, Active Directory, ActiveX, ADA, ASP, ASP.NET, Availability, Avaya, Bandwidth, BASIC, Benchmarking, Bind, C, Cabling, CGI, Cisco, COBOL, ColdFusion, Computer Associates, DataCenter, Dell, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, H.323, Hardware, HEAT, Help Desk, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Lifecycle development, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Windows, MPLS, NetBIOS, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell IPX/SPX, Novell NDS, Oracle, OS, Patch management, Performance management, PHP, Ping, Programming Languages, Protocol analysis, Remote management, Routers, SAP, Security, Servers, SIP, Software Quality Assurance, SQL Server, Switches, Systems management software, T-SQL, TCP, Tech support, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, VB.NET, VBA, VBScript, Visual Basic, Windows, WINS, XML
i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse
Answer Question
| August 20, 2005 5:39 AM
3Com, ABAP, Access, Active Directory, ActiveX, ADA, ASP, ASP.NET, Availability, Avaya, Bandwidth, BASIC, Benchmarking, Bind, C, Cabling, CGI, Cisco, COBOL, ColdFusion, Computer Associates, DataCenter, Dell, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, H.323, Hardware, HEAT, Help Desk, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Lifecycle development, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Windows, MPLS, NetBIOS, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell IPX/SPX, Novell NDS, Oracle, OS, Patch management, Performance management, PHP, Ping, Programming Languages, Protocol analysis, Remote management, Routers, SAP, Security, Servers, SIP, Software Quality Assurance, SQL Server, Switches, Systems management software, T-SQL, TCP, Tech support, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, VB.NET, VBA, VBScript, Visual Basic, Windows, WINS, XML
Synchronization of application servers
hi all my company has about 30 application servers,so when i want to install something i have to do it on 30 servers which is very time consuming.due to this I Need a way to update all application servers using a single installation routine. can someone help please
Answer Question
| September 25, 2005 3:21 AM
3Com, Access, Active Directory, Apache, AS/400, Availability, Avaya, Bandwidth, Benchmarking, Bind, Cabling, Cisco, Database, DataCenter, DB2, Dell, Desktops, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Exchange, Exchange security, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, Hardware, Hewlett-Packard Application Server, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Linux, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Windows, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell NDS, Oracle, OS, Patch management, Performance management, Ping, Protocol analysis, Remote management, Routers, Security, Servers, SQL, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows, WINS
hi all my company has about 30 application servers,so when i want to install something i have to do it on 30 servers which is very time consuming.due to this I Need a way to update all application servers using a single installation routine. can someone help please
Answer Question
| September 25, 2005 3:21 AM
3Com, Access, Active Directory, Apache, AS/400, Availability, Avaya, Bandwidth, Benchmarking, Bind, Cabling, Cisco, Database, DataCenter, DB2, Dell, Desktops, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Exchange, Exchange security, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, Hardware, Hewlett-Packard Application Server, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Linux, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Windows, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell NDS, Oracle, OS, Patch management, Performance management, Ping, Protocol analysis, Remote management, Routers, Security, Servers, SQL, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows, WINS
PowerBuilder Printing Problem
hi all, i have a problem, when i print a powerbuilder report using a network printer, from some PCs the report is blank where from some others it is printed properly. i don’t think so that the problem is in PowerBuilder because all PCs uses the same EXE. thanks in Advance.
Answer Question
| August 12, 2005 5:15 AM
Database Management Systems, Development, Hardware, Interoperability, Microsoft Windows, Networking, PC/Windows Connectivity, PowerBuilder, Software, Sybase, Tech support, Windows
hi all, i have a problem, when i print a powerbuilder report using a network printer, from some PCs the report is blank where from some others it is printed properly. i don’t think so that the problem is in PowerBuilder because all PCs uses the same EXE. thanks in Advance.
Answer Question
| August 12, 2005 5:15 AM
Database Management Systems, Development, Hardware, Interoperability, Microsoft Windows, Networking, PC/Windows Connectivity, PowerBuilder, Software, Sybase, Tech support, Windows
