Question : I’ve searched and read wide about the good practices of configuring swap space for Oracle Database installation. I […]
Tag: solaris
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 […]
I am trying to restore an Oracle DB, but I am getting strange controlfile errors. What do I do next?
Question : Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = […]
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 […]
Where is oraenv located in solaris?
Question : I had a problem recently with oraenv and oratab and finding out where oraenv is located was a […]
- 1
- 2