How to change the screen resolution in Oracle Enterprise Linux on Vmware

I found a lot of trouble related to screen resolution which was struck to 800x600 or 600x480 resolutions  after installation of oracle enterprise linux as guest OS on vmware de. Then i went through many blogs and forums to change this problem and at last i was able to fix it. I am summarizing the steps to fix this issue.
• Install Oracle Enterprise Linux • Login as "root" user and install vmware tools • After installation of vmware tools, restart it and login as a root user • go to System -> Administration -> Screen. In Hardware tab, click Configure for Monitor Type and select a suitable monitor type of high resolution e.g. LCD Panel 1280x800 etc. • Now go to etc/X11 and open XORG.CONF file • There will be a section "Screen" in that file which will contain a subsection "Display". Inside that section there is a line  'Modes "800x600" "640x480"'. Add a suitable screen resolution which you want to add e.g. i added "1280x800" and "1024x768" for my LCD. Now new line will be "Modes "1280x800" "1024x768" "800x600" "640x480". • Save it and restart the OEL. Now go to System->Preferences->Screen Resolution and select a suitable screen resolution now and enjoy.

taken from : https://sites.google.com/site/technicalinfosite/tips---techniques/howtochangethescreenresolutioninoracleenterpriselinuxonvmware

Oracle Error with Explain Plan | ORA-00904: "OTHER_TAG": invalid identifier

when we try to explan plan, we get the below error, this is becauae the plan table is corrupted
drop and recreate the plan table.


SQL> explain plan for   select * from id_meta_ticket_query;
Explained.

SQL> SELECT * FROM TABLE(dbms_xplan.display);

PLAN_TABLE_OUTPUT

------------------------------------------------------

ERROR: an uncaught error in function display has happe  Please provide also a DMP file of the used plan

       ORA-00904: "OTHER_TAG": invalid identifier

SQL> drop table  plan_table;

Table dropped.

SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql

Table created.

SQL> explain plan for  select * from id_meta_ticket_query;

Explained.

SQL>  select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT

------------------------------------------------------------------------------

Plan hash value: 683485703

------------------------------------------------------------------------------------------

| Id  | Operation         | Name                 | Rows  | Bytes | Cost (%CPU)| Time     |

------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |                      |     1 |   867 |     2   (0)| 00:00:01 |

|   1 |  TABLE ACCESS FULL| ID_META_TICKET_QUERY |     1 |   867 |     2   (0)| 00:00:01 |

------------------------------------------------------------------------------------------

8 rows selected.