Troubleshooting issues in Oracle, RedHat Linux, Windows and lot more!.

Need multiple shell sessions? You are logged into your remote server via  SSH  and happily plucking along at your keyboard and then it happens. Suddenly, the characters stop moving and then you get the dreaded “Connection Closed” message. You have just lost your session. You were halfway through some task and now you have to start over. Ugh. Well you can prevent this from happening by using screen. Lost your shell connection? The Linux screen tool can not only save you from disconnection disasters, but it also can increase your productivity by using multiple windows within one  SSH session.  What is Screen for Linux? As the man page states, “Screen is a full-screen window manager that multiplexes a physical terminal between several processes (typically interactive shells).” This can be a life saver when working on your dedicated server. Screen has a several great features for helping you administer your server more productively and safely. Ins...

DDL Data Definition Language (DDL) statements are used to define the database structure or schema.  CREATE - to create objects in the database ALTER - alters the structure of the database DROP - delete objects from the database TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed COMMENT - add comments to the data dictionary RENAME - rename an object DML Data Manipulation Language (DML) statements are used for managing data within schema objects. SELECT - retrieve data from the a database INSERT - insert data into a table UPDATE - updates existing data within a table DELETE - deletes all records from a table, the space for the records remain MERGE - UPSERT operation (insert or update) CALL - call a PL/SQL or Java subprogram EXPLAIN PLAN - explain access path to data LOCK TABLE - control concurrency DCL Data Cont...

1.DELETE The DELETE command is used to remove rows from a table.  A WHERE clause can be used to  remove some rows.  If no WHERE condition is specified, all rows will be removed.  After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it. Note that this operation will cause all DELETE triggers on the table to fire. 2.TRUNCATE TRUNCATE removes all rows from a table.  No triggers will be fired.  Not able to perform ROLLBACK operation. TRUNCATE is faster then DELETE and doesn't use as much undo space as a DELETE. 3.DROP The DROP command removes a table from the database.  All the tables' rows, indexes and privileges will also be removed.  No DML triggers will be fired.  Not able to perform ROLLBACK operation. SOME MORE DIFFERENCES DROP and TRUNCATE are DDL commands, wh...

What Is ORACLE? Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery. ORACLE PLATFORMS Oracle is considered the world’s most powerful, flexible and robust database because it runs on just about every platform imaginable, from a mainframe to a Macintosh.Today, most shops run Oracle in UNIX, Linux, and Windows. Oracle runs on almost every computer ever made, with over 60 diverse platforms such as Intel (like your PC does), Sun Solaris, old IBM mainframes, and many, many others.  What Is an Oracle Database? An Oracle database is a collection of data treated as a big unit in the database server. What Is an Oracl...