Open Access   Article Go Back

Tuning a Multi-Million Row Table

A. Sharma1

Section:Research Paper, Product Type: Journal Paper
Volume-4 , Issue-9 , Page no. 141-145, Sep-2016

Online published on Sep 30, 2016

Copyright © A. Sharma . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

XML View
PDF Download

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: A. Sharma, “Tuning a Multi-Million Row Table,” International Journal of Computer Sciences and Engineering, Vol.4, Issue.9, pp.141-145, 2016.

MLA Style Citation: A. Sharma "Tuning a Multi-Million Row Table." International Journal of Computer Sciences and Engineering 4.9 (2016): 141-145.

APA Style Citation: A. Sharma, (2016). Tuning a Multi-Million Row Table. International Journal of Computer Sciences and Engineering, 4(9), 141-145.

BibTex Style Citation:
@article{Sharma_2016,
author = {A. Sharma},
title = {Tuning a Multi-Million Row Table},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {9 2016},
volume = {4},
Issue = {9},
month = {9},
year = {2016},
issn = {2347-2693},
pages = {141-145},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=1068},
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=1068
TI - Tuning a Multi-Million Row Table
T2 - International Journal of Computer Sciences and Engineering
AU - A. Sharma
PY - 2016
DA - 2016/09/30
PB - IJCSE, Indore, INDIA
SP - 141-145
IS - 9
VL - 4
SN - 2347-2693
ER -

VIEWS PDF XML
1474 1316 downloads 1365 downloads
  
  
           

Abstract

Every organization faces the issue of slow performance with their database on regular basis. In this scenario, a DBA is required to tune the database or find the root cause of the sluggishness. Tuning a database after it has been setup is a highly tedious task and requires a lot of expertise, in-depth knowledge of the architecture and underlying functionality. So, it�s better to deal with the problem from the starting, i.e. structuring the Database in such a manner, that it yields good performance. This will make the database more stable and reduce the effort required to manage the database. So, presented below is a method to achieve better performance regardless of the quality of the hardware on which the database is hosted. Below method of database structuration made my life easier when I was asked to design the structure of an organization�s database from scratch and this entire paper is based on that method.

Key-Words / Index Term

Database Optimization, Database Structuration, Performance Tuning, Table Structuration

References

[1] Partitioning in Oracle Database, http://www.oracle.com/technetwork/database/enterprise-edition/partitioning-11g-whitepaper-159443.pdf, Jul 4, 2014
[2] Create Tablespace, https://docs.oracle.com/database/121/SQLRF/statements_7003.htm#SQLRF01403 Aug 23, 2014
[3] Managing Tablespace and Datafiles, http://www.oracle-dba-online.com/tablespaces_and_datafiles.htm Aug 30, 2014
[4] Managing Resumable Space Allocation, http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#ADMIN11581 Sep 15, 2014
[5] Resumable Space Allocation, http://gavinsoorma.com/2009/06/resumable-space-allocation/ Oct 1,2014
[6] SQL Loader Concepts, https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm Oct 27, 2014
[7] The Query Optimizer, http://docs.oracle.com/cd/B28359_01/server.111/b28274/optimops.htm Dec 20, 2014
[8] Performance Tuning Overview, http://docs.oracle.com/cd/E11882_01/server.112/e41573/perf_overview.htm#PFGRF025 Jan 24, 2015
[9] Database Performance Tuning, Guidehttps://docs.oracle.com/database/121/TGDBA/toc.htm Feb 25, 2015
[10] How to tune your Oracle database`s performance, http://www.theregister.co.uk/2014/05/06/oracle_database_performance_workshop/ Mar 2, 2015
[11] Explain Plan Usage, https://oracle-base.com/articles/8i/explain-plan-usage Jul 15, 2015