One day I noticed one of my
databases is generating lot of archive logs though it is an idle database.
There is no transaction happening in this database for a long time. I came to
know when I tried to clone the database to a different server. The recovery is
taking so much of time with these archive logs. One thing I noticed is this
archive logs are small in size.
It is common requirement for a
developer or DBA to find out the index name, column name for the table. Sometimes
the index would be composite index. So in that case we have to find out that
also like how many columns associated with the index and their order. There are
2 data dictionary views for the same. DBA_INDEXES and DBA_IND_COLUMNS.
DBA_INDEXES gives just index names associated with the table and
DBA_IND_COLUMNS gives the associated columns and their order.
RMAN image copy backup will take more space than the normal RMAN backup as it takes the entire datafile file as backups. But some situations we can use this method to backup and restore the database. Here is the method and RMAN command syntax for the same.
In last few days I have been facing a
problem in my browsers like automatically some WebPages are opening without
asking anything. It is quite disturbing during the serious browsing and it is
slow down my system performance also. The websites are like http://giraffetraffic.com/,
go.oclasrv.com etc. sometime it opens the corner popup in the web pages.
SET PAGESIZE 60 SET LINESIZE 300 SET VERIFY OFF SELECT TRUNC(completion_time) "Generation Date" , thread#,count(*) FROM gv$archived_log GROUP BY TRUNC(completion_time),thread# ORDER BY TRUNC(completion_time)
Nowadays when we apply for a Kerala PSC post using
Thulasi website, we are getting a message saying “You are not eligible to apply
for the Post”. Reason for the rejection is “New declaration is required.”
Most of the time during the shell
scripting we get requirement to get the database table query result values to a
shell script variables. Here is one example to get a single column values to a
variable. If you have multiple column outputs then we will have to concatenate
into a single column and pass it to the shell script variable. You can use awk
or scripting commands to make it separate.
Here are some useful
tips to use screen command in Linux user logins. Linux screen command is very useful
command to keep the session logged in without any failure even if any kind of
network failure etc.