Data and Database

When you search for "Data" in the web, you get its meaning something like this "facts and statistics collected together for reference or analysis." Basically, Data gives us a meaningful information. It can be represented with the help of characters like alphabet and digits. Database is a collection of data that is well organized, which make easy for us to access,manage, and update those.

Showing posts with label Oracle Storage architecture. Show all posts
Showing posts with label Oracle Storage architecture. Show all posts

Wednesday, 1 November 2017

Database Storage Architecture

at November 01, 2017 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Oracle 11g, Oracle Architecture, Oracle Storage architecture
Home
Subscribe to: Posts (Atom)
  • DBMS_PROFILER: How to analyze pl/sql performance
  • Index in 12C
  • 12c - Limit the PGA
  • MEMORY_TARGET vs SGA_TARGET vs PGA_AGGREGATE_TARGET
  • Explain the Explain Plan: Access Methods & Join Methods
  • Unusable indexes
  • DML, DDL in Function
  • PRAGMA EXCEPTION_INIT
  • Mutating table
  • DBMS_REFRESH DBMS_SYNC_REFRESH

Followers

Search This Blog

  • Home

About Me

My photo
Data and Database
View my complete profile

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Total Pageviews

Labels

  • Analytic Fnction (1)
  • Analyze (1)
  • append (1)
  • Autotrace (2)
  • AWR (2)
  • b-tree index (1)
  • Background Processes (1)
  • Bitmap index (1)
  • Bulk Binding (2)
  • Bulk Collect (2)
  • collections (2)
  • connect_by (1)
  • cursor (1)
  • Cursor FOR Loop (1)
  • Cursor Variable (1)
  • data pump (1)
  • Dataframe (2)
  • dba tables (4)
  • dba views (1)
  • dba_constraints (1)
  • DBA_DATA_FILES (1)
  • DBA_FREE_SPACE (1)
  • dba_hist tables (1)
  • DBA_HIST_SQLTEXT (1)
  • dba_ind_partitions (1)
  • DBA_JOBS (1)
  • dba_part_tables (1)
  • DBA_SEGMENTS (2)
  • dba_tab_partitions (1)
  • dba_tables (2)
  • dba_users (1)
  • dbms package (1)
  • DBMS_ADDM (1)
  • DBMS_ADVANCED_REWRITE (1)
  • DBMS_DEBUG (1)
  • DBMS_ERRLOG (1)
  • DBMS_FGA (1)
  • DBMS_FILE_TRANSFER (1)
  • DBMS_FLASHBACK (1)
  • DBMS_JOB (1)
  • DBMS_MONITOR (1)
  • DBMS_MVIEW (1)
  • DBMS_PERF (1)
  • DBMS_PROFILER (3)
  • dbms_redefinition (2)
  • DBMS_REFRESH (1)
  • DBMS_SQL (1)
  • DBMS_SQL_MONITOR (2)
  • DBMS_SQLTUNE (3)
  • dbms_stats (5)
  • DBMS_SYNC_REFRESH (1)
  • DBMS_UTILITY (1)
  • DBMS_WORKLOAD_REPOSITORY (1)
  • DBMS_XPLAN (1)
  • Exception handling (2)
  • EXCHANGE PARTITION (1)
  • Explain plan (9)
  • export import (1)
  • External Table (1)
  • External Tables (1)
  • fetch (1)
  • Forall (2)
  • Function (2)
  • Function Cache (1)
  • Gather Statistics (2)
  • GTT (2)
  • Hierarchical (1)
  • Hint (7)
  • Index (8)
  • Installation (1)
  • Invisible Columns (1)
  • Join (1)
  • json (1)
  • Linux (3)
  • Materialized views (5)
  • Mutating table (1)
  • Nested Materialized Views (1)
  • nologging (1)
  • offset (1)
  • Oracle (4)
  • Oracle 11g (23)
  • oracle 12c (19)
  • oracle 18c (1)
  • Oracle Architecture (4)
  • Oracle Memory Architecture (1)
  • Oracle Storage architecture (1)
  • Pandas (3)
  • Parameterized cursor (1)
  • Partition (13)
  • Performance Tuning (24)
  • PGA (1)
  • plsql (5)
  • Pragma (4)
  • python (16)
  • Redo (1)
  • Ref cursor (2)
  • Regular expressions (1)
  • Result Cache (2)
  • RESULT_CACHE (2)
  • row_limiting_clause (1)
  • sequence (1)
  • Series (1)
  • SGA (1)
  • SQL (5)
  • SQL * loader (2)
  • SQL Monitor (1)
  • SQL Tuning (16)
  • Table Reorganization (1)
  • tablespace (4)
  • Tablespace Reorganization (2)
  • Temporary table (2)
  • TKPROF (1)
  • Trace (1)
  • Trigger (1)
  • truncate (1)
  • Undo (1)
  • Unix (3)
  • user_ind_partitions (2)
  • user_indexes (1)
  • user_tab_partitions (1)
  • UTL_FILE (1)
  • UTL_MAIL (1)
  • v$ view (3)
  • v$active_session_history (1)
  • v$session (1)

Blog Archive

  • October 2021 (4)
  • June 2021 (4)
  • May 2021 (6)
  • November 2020 (1)
  • October 2020 (3)
  • September 2020 (5)
  • June 2020 (11)
  • September 2018 (2)
  • August 2018 (1)
  • December 2017 (4)
  • November 2017 (89)
Simple theme. Powered by Blogger.