Ask TEM Dba

What is your regular command you use? I am sure you must thinking of ls and cd. Yeah, they are common for every users, but how about the rest of them? I have construct a combos of commands to help you identify your top t[...]

History is a common command for shell to list out all the executed commands. It is very useful when it comes to investigation on what commands was executed that tear down the server. With the help of last command, you be[...]

Part I) First of  all you must configure the following parameters related to database archiving: You have two main options for define archive log destinations: 1) Flash Recovery Area (recommended) In this part, first of[...]

In Oracle 9i and up, you can generate CPU cost information during a workload with a procedure of the dbms_stats package. The dbms_stats.gather_system_stats packaged procedure can be used during a certain interval to meas[...]

You are trying to delete a record, but one or more child records were found, preventing the delete. A (parent / child) relationship between 2 tables are defined by a foreign key constraint. eg: CREATE TABLE PARENT ( ID [...]

How to Safely Remove a Data Guard Broker Configuration Doc ID: 261336.1 Type: REFERENCE Modified Date: 20-MAY-2009 Status: PUBLISHED PURPOSE ——- How to safely remove a Data Guard Broker conf[...]

Imagine, there are a few tables in your schema and you want to find a specific value in all columns within these tables. Ideally, there would be an sql function like select * from * where any(column) = 'value'; Unfort[...]

This table is taken from Sun Microsystems' User's Guide: Getting Started (. Starting vi vi filename open or create file vi +18 filename open to line 18 vi +/"mustard" filename open file to first occur[...]

Oracle maintains its own buffer cache inside the system global area (SGA) for each instance. A properly sized buffer cache can usually yield a cache hit ratio over 90%, meaning that nine requests out of ten are satisfied[...]

Place all the rpm packages in one local sub-directory (lets say RHEL5) which does not have and sub-directorires and do; rpm -ivh createrepo*.rpm createrepo /RHEL5 Then in the /etc/yum.repos.d directory place a file named[...]