: ORACLE4U.COM :

Oracle 12C,Oracle PLSQL,Oracle Workspace Manager,Oracle 11G,Oracle Apps,Oracle Forms,Oracle Reports,Oracle DBA,Oracle Discoverer,Oracle Spatial,Oracle Network,Oracle Text,NO SQL

Pages

  • Home
  • Oracle DBA
  • ERP
  • Oracle Apps
  • Data Warehouse
  • Java
  • UNIX
  • Hadoop
  • JOBS4U
  • Misc

Apr 20, 2014

Oracle Baseline

Oracle Baseline
































































* Adopted from Slide of Arup Nanda
Reactions: 
No comments: Links to this post
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
Labels: dbms_spm, DBMS_SQLTUNE, dbms_xplan, Oracle Baseline
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

PLSQL

Enter your email address:

Add to Favorites

Add your Response

Popular Posts

  • PCTFREE , PCTUSED ,INITRANS & MAXTRANS
           The datafiles are the physical storage space on the server. Storage in the datafiles is allocated by blocks to each extent that is u...
  • Spatial Error Related with SDO_NN
    SELECT sdo_nn_distance (1) dist, a.cid, sdo_geom.sdo_min_mbr_ordinate (b.sdo_geometry, 1) x, sdo_geom.sdo_min_mbr_ordinate (b.sdo_geometry,...
  • ORA-20061 ,ORA-00604 and ORA-2017
    ORA-00604: error occurred at recursive SQL level 1 ORA-20061: versioned objects have to be version disabled before being dropped ORA-065...
  • ORA-20104: cannot version disable this table
    ORA-20104: cannot version disable this table ORA-06512: at "SYS.LT", line 9152 ORA-06512: at line 3 the following error will o...
  • Oracle Text - Part 5
    Generating XML Output The INDEX_STATS procedure supports both formatted text and XML output.The following code creates the INDEX_STATS re...
  • Oracle Exdata
    Exdata is a hardware machine which runs oracle database; supports OLTP, Database Exologic is a hardware machine for application and primar...
  • Pivot , Unpivot Queries
    In the FOR IN clause of PIVOT keyword, we cannot use column names , can only use values  ORA-56901 : non -constant expression is not al...
  • Convert a number to word
    select to_char(to_date('1983','J'),'JSP') from dual; In this query the number is converting into Julian date then ...
  • Oracle Information Architecture Capability Model
  • UNDERSTANDING EXPLAIN PLAN 1
      UNIQUE Sorts to eliminate duplicate rows. This typically occurs as a result of using the DISTINCT clause. SORT UNI...

TOPICS

  • ►  2019 (5)
    • ►  December (5)
  • ►  2018 (2)
    • ►  December (1)
    • ►  February (1)
  • ►  2017 (2)
    • ►  June (1)
    • ►  January (1)
  • ►  2016 (28)
    • ►  December (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (5)
    • ►  April (1)
    • ►  March (10)
    • ►  February (6)
    • ►  January (2)
  • ►  2015 (11)
    • ►  August (2)
    • ►  June (2)
    • ►  April (6)
    • ►  February (1)
  • ▼  2014 (8)
    • ►  November (1)
    • ►  October (3)
    • ►  August (2)
    • ►  July (1)
    • ▼  April (1)
      • Oracle Baseline
  • ►  2013 (13)
    • ►  December (5)
    • ►  May (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2012 (6)
    • ►  October (1)
    • ►  September (3)
    • ►  May (2)
  • ►  2011 (24)
    • ►  December (3)
    • ►  November (4)
    • ►  October (1)
    • ►  August (3)
    • ►  July (6)
    • ►  June (3)
    • ►  May (2)
    • ►  March (1)
    • ►  January (1)
  • ►  2010 (24)
    • ►  November (4)
    • ►  October (3)
    • ►  September (2)
    • ►  August (1)
    • ►  July (1)
    • ►  June (2)
    • ►  April (3)
    • ►  March (5)
    • ►  February (2)
    • ►  January (1)
  • ►  2009 (51)
    • ►  November (2)
    • ►  September (1)
    • ►  July (3)
    • ►  May (14)
    • ►  April (4)
    • ►  March (12)
    • ►  February (12)
    • ►  January (3)
  • ►  2008 (11)
    • ►  December (1)
    • ►  November (4)
    • ►  September (6)
Share in FACEBOOK
Print

Explore ORACLE4U
Oracle4u.com

Total visitors

hidden statistics
Online User
ORACLE4U.COM. Picture Window theme. Powered by Blogger.