• November 28, 2005 28 Nov'05

    Difference between "SYSADM" and "SYSDBA"

    What are the differences between "SYSADM" and "SYSDBA"?  Continue Reading

  • November 23, 2005 23 Nov'05

    Is it beneficial to switch from dedicated to shared mode?

    We are using Oracle 9i on Windows 2000 Server with 2GB RAM. When we restart the database, it's running fine, but as soon as users connect with the database they get very slow results; some queries take an hour to get results. We are running this in...  Continue Reading

  • November 23, 2005 23 Nov'05

    High traffic and bad performance at peak times

    Our database has very much traffic at peak times. It has two servers, one located in the U.K. and another in India. The client machine is installed in India. From there they access both servers. At peak times the perfomance is very bad. All ...  Continue Reading

  • November 23, 2005 23 Nov'05

    First steps for determining database performance

    Here is the scenario: as soon as you join a concern that is performing maintenance of a production database in a Unix environment (e.g., banking), you are asked to verify the performance of the database. Is it high-quality or not? Where will you ...  Continue Reading

  • November 17, 2005 17 Nov'05

    Way to recover a tablespace without backup

    We have just lost a tablespace on our live database (looks like someone ran the command "drop tablespace $$$ including contents"). The tablespace (GSIF) is gone! But we can see the datafile. Is there a way of recovering the tablespace with its ...  Continue Reading

  • November 17, 2005 17 Nov'05

    Performance tuning questions

    What is the formula to calculate space for the tables in a database? If I run a query that displays the number of physical read and writes per second for each datafile and they are high numbers, then what should I do to tune the database?  Continue Reading

  • November 17, 2005 17 Nov'05

    Mapping values from 8i to 9i

    I want to convert Oracle8i to Oracle9i. The problem is, I want to get a structure from Oracle8i and after modification in Oracle9i (including the primary key) I want to map the values. I also want to know which migration method is suitable.  Continue Reading

  • November 17, 2005 17 Nov'05

    Unable to open 8.0 database on Windows

    I run Oracle 8.0 on Windows 98 for my pharmacy software. The system has been hanging a couple of times. Now when I start Oracle prior to running my application it shows the database instance started, then mounted, but stops with this error: "ORA-...  Continue Reading

  • November 17, 2005 17 Nov'05

    Error during import from 9i to 10g

    I am using Oracle 10g (release 1). I have taken a table export from a schema which is in Oracle 9i (9.2.0) using the exp command, and it successfully completed without warnings. But when I import into my Oracle 10g server from the same export file...  Continue Reading

  • November 17, 2005 17 Nov'05

    Can I use RMAN to back up a database not running in archive log mode?

    Can RMAN be used to back up a database that is not running in archive log mode? I need to back up the test database but we don't run it in archive log mode. I understand that it wouldn't be a hot backup.  Continue Reading