Linux command prompt provides history of all commands which got executed under that login. If you give normal history command it will not show the date and time for the command execution. But in many cases you would need the date and time of the command execution which we can easily get it by formatting the HISTTIMEFORMAT environment variable.
Oracle 10g R1 onwards the case .. when clause has been added to the select statement which can perform several comparisons in a single query. Prior to that we should have to use the DECODE function to achieve this goal.
The following error is getting logged frequently in alert log and as per the metalink suggestion the SGA_TARGET has to be increased to fix the same. To increase the SGA_TARGET value it requires the database bounce. If you are running in Oracle RAC environment you can perform this change without full database outage. Please find the steps to change value instance by instance.
Error: ORA-04031: unable to allocate 2048024 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
The domain which is registered from the blogger is valid only for one year from the date of registration. You must have to renew the domain to retain your visitors. If you forget to renew your domain after a year, someone else can take the domain. If you miss the existing domain name it is very tough to achieve the same amount visitors with different domain name.
Normally "ORA-01950: no privileges on tablespace" error occurs due to the no space quota allocated to the user on the particular tablespace. I wish to explain the difference in ORA-01950 error with deferred segment creationvalues with TRUE and FALSE.