• iSeries performance question

    Hello everybody, I'm trying to figure out the best way to count the number of records matching specified criteria in large PF. (The file has over 50 million records currently and with some purging we hope to bring it down to around 20 mil.) Anyway, I created the (SQL) view: create view largePF99 (...

    Dushan0 pointsBadges:
  • New to AS400 administration and need some help.

    I have two questions here if someone can help. I will appreciate anything you can give. First, I am trying to configure a network printer on the AS400. I did wrkcfgsts, work with description, and copied the printer devices description and modified the printer device with the new info. All I changed...

    Bkr0963c0 pointsBadges:
  • error in connection between oracle8i&developer2000

    I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...

    POWERINIT0 pointsBadges:
  • Running a performance baseline trace on a SQL server

    When you are running a performance baseline trace on a SQL server, how long do you typically run the trace? Or, do you run multiple traces at various times of the day?

    SQL Server Ask the Experts2,585 pointsBadges:
  • PL/SQL performance tuning…

    I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied the...

    Jelewis0 pointsBadges:
  • Stop Error (C000021a)

    I am receiving this stop error(C000021a) "windows logon process system process terminated unexpectedly" with win 2000 server. Safe mode and Last Known Good Conf. works fine. Is there any solution without reformating the HDD? I have ERD with me. Will that help me? Any advise on this would be highly...

    BinooDas123410 pointsBadges:
  • execution plan is same even though it takes 10 times longer to run

    I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!

    Abbi20 pointsBadges:
  • Performance Tracking of Stored Procedures

    we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each...

    Pcrum735 pointsBadges:
  • Database Admin…

    Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did... nor did I. Well, I ended up doing security,...

    Znason460 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • moving datafiles to different locations

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me. Regards.

    Sukaina10 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • Oracle Application or Database on its own server.

    Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...

    Ktharrell0 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:
  • inserts through a database link

    Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to...

    carlosdl70,200 pointsBadges:
  • Using optimizer hints in Forms

    Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...

    carlosdl70,200 pointsBadges:
  • SQL Server worst practices

    Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...

    Nbellistri0 pointsBadges:
  • Upgrade to SQL Server 2005 sooner or later?

    Hello, I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans? 58%...

    RobynLorusso230 pointsBadges:
  • Hiding System Tray ICons

    Hi Guys.. I want to know how do we remove/hide system tray icon without stopping the service. I have a monitoring software which appears in the system tray which i want to hide. I m using win xp prof . I dont want to hide it i want to remove the icon from the system without stopping the service. I...

    MithunMCSE0 pointsBadges:
  • Wireless Networks Interfering with Unix Servers

    I have a customer who has a Unix Server running UnixWare 7.1.3. He bought a 3Com wireless access point from a catalogue, but when he switched it on the Unix Server would reboot. This only happened twice before the unit was thrown at me to fins solution. He has in the offices an access point from...

    Mozza10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following