|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
|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.
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?|
|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:
ITWeb : Prevent database disasters with a simple checklist
29 November 2012
Despite the critical nature of the database, many companies do not have a comprehensive backup and disaster recovery.......» read more
ITWeb : Maximum uptime is critical in a globalised, ‘always-on’ business world
09 January 2013
Globalisation has changed the way we work and communicate as geographic boundaries blur and cease to be an issue........» read more
James Symons, Executive: IT, Barloworld Logistics
"From the first time I met with RDB, they said “ James we’re here to add value to your business” and that is exactly what RDB team has done. RDB has stood by their promise to ‘maximise our uptime’. They’ve been accountable and have delivered on their original proof of concept."
Theo Nel, Head: ITSS Services, Momentum
"RDB believes in adding value to business… at Momentum we believe in people who believe in themselves, the foundations for a solid partnership."
Jaco van der Lith: (IS Operational Delivery), Database Manager, MTN
"RDB assisted MTN in getting out of a resource shortfall quickly. They provided us with skilled and qualified consultants at short notice thus ensuring operational delivery to our business and customers continued with minimal impact. There is constant interaction with the management team at RDB and any concerns are addressed and resolved quickly. In short, RDB adds value to our operation!"