Question : I ran MySQLTuner to verify the configuration of a MySQL database, and it reported this problem: [!!] Maximum […]
Tag: solaris
Slowness after migration to RAC 11gr2
Question : we are getting slowness after migrate from ORacle 10gr2 single db to Oracle 11204 oracle rac (standard ed) […]
ORA-48108 & ORA-01034
Question : I’m trying to set up a database on a Solaris 10 platform that had its database corrupted before. […]
SGA size vs SWAP space in Oracle RAC
Question : I’ve searched and read wide about the good practices of configuring swap space for Oracle Database installation. I […]
Logging procedure, package errors to OS’s Syslog
Question : Good day, Setup: Oracle 11G on Solaris 10 x86 We’d like to capture the errors/failures of our nightly […]
ORA-01658 on index tablespace when trying to insert into empty table of new database
Question : We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our […]
How to know which process is causing high memory usage on DB?
Question : I’ve got one Onesight alert mail stating below: Short Description: Onesight Alert: ZEUS DB Monitor (zeus04) Description: Solaris […]
Is Oracle 10g smart enough to work on a WHERE clause identically as the equivalent INNER JOIN?
Question : Way back when Michael Jackson was still alive, I made this question: https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause And now I’m performance-auditing a […]
Is Oracle 10g smart enough to work on a WHERE clause identically as the equivalent INNER JOIN?
Question : Way back when Michael Jackson was still alive, I made this question: https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause And now I’m performance-auditing a […]
How to put Oracle Redo Log file at the outer edge of disk for performance?
Question : I always read that the outer edge of disk is the fastest place. Somebody said “You better put […]
- 1
- 2