FAQs

Q: How do I copy my SQL database from one machine to another?

A: Make a dump of the database to be copied : mysqldump -u root -p --databases --opt  MyDatabase > MyDatabase.sql

Copy MyDatabase.sql to the second machine
Import the database to MysSQL server : mysql -u root -p < MyDatabase.sql

Q: What Oracle database block size should I use?

A: Oracle recommends that your database block size match, or be multiples of your operating system block size. You can use smaller block sizes, but the performance cost is significant and your choice should depend on the type of application you are running.

Q: Why and when should I tune my Oracle Database?

A: One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance.
One should do performance tuning for the following reasons:

  • The speed of computing might be wasting valuable human time (users waiting for response);
  • Enable your system to keep-up with the speed business is conducted; and
  • Optimize hardware usage to save money (companies are spending millions on hardware).

Although this site is not overly concerned with hardware issues, one needs to remember than you cannot tune a Buick into a Ferrari.

Q: What tools does Oracle provide to assist with performance tuning?
  • ADDM (Automated Database Diagnostics Monitor) introduced in Oracle 10g
  • TKProf
  • ULTBSTAT.SQL and UTLESTAT.SQL – begin and end stats monitoring
  • Statspack
  • Oracle Enterprise Manger – Tuning Pack

Q: Who can benefit with Oracle’s Linux support?

A: Anyone can get Linux support from Oracle whether or not they are using Oracle products.

Q: Why can’t I connect to oracle?

A: If a user does not have the "create session" privilege you should get the following:

ORA-01045: user <username> lacks CREATE SESSION privilege

To fix this you will have to grant this user the CREATE SESSION privilege.

GRANT CREATE SESSION TO <username>