Home
Search results “Pctfree oracle index”
SCPT 47: Oracle Storage Parameters: PCTFREE and PCTUSED
 
09:16
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 23049 Oresoft LWC
PCTFREE / PCTUSED / FREELISTS for the novice
 
10:00
There's a lot of settings you can modify when you create a table. But which ones do you need to worry about? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #pctfree #pctused
Views: 519 Connor McDonald
Pack Rows Tightly setting PCTFREE correctly - With Demo - DBPerf Video 14
 
04:36
In this video you will understanding about setting PCTFREE correctly and its impact in I/O and Memory / SGA utilization. At the end there is a demo to show you the same. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 2075 Ramkumar Swaminathan
Space Management in Extents and Segments - DBArch Video 31 / DBPerf Video 13
 
13:00
In this video you will understand about the following - Dictionary managed Vs Locally Managed Tablespaces - Manual Vs Automatic Segment Space Management - PCTFREE and PCTUSED - Row Migration and Row Chaining . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 11650 Ramkumar Swaminathan
pct free, oracle storage,dba videos from cpisolution.com
 
02:30
understand pct free...what is pct used etc...used in dictionary managed tabelsapce and when segment management is manual..in locally managed tablespace.. oracle dba block and storage
What is High Water Mark(HVM) in oracle and how it effects the performance of queries?
 
05:41
This video tutorial is to understand the concept of a High Water Mark or HVM of a oracle table, also it states the various changes in the HVM when we perform a insert, delete and Truncate operation on the table, and the video also informs why is the truncate operation more advisable and optimized then the delete operation.
Views: 4389 Kishan Mashru
Oracle - Hot Backups
 
15:15
Oracle - Hot Backups
Views: 12089 Chris Ostrowski
10 10 Monitoring Index Usage
 
02:15
ORACLE
Views: 114 oracle ocm
Local Vs Global Partitioned Index in Oracle 11g
 
17:30
The Video Explains the difference between Local Partitioned Indexes(Prefixed vs Non Prefixed Indexes). and Global Partitioned Index along with the challenges in maintaining Global partitioned Indexes when the underlying tables partitioned is dropped/truncated/Merged/Moved. Local Partitioned Index Shares the same boundaries as the table and are in the same number as table partitions they are widely used in DSS and DWH systems. While Global Partitioned Index are predominantly used in OLTP systems
Views: 10036 Tech Coach
INITRANS / MAXTRANS - transaction slots for the novice
 
06:05
There's a lot of settings you can modify when you create a table. But which ones do you need to worry about? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #initrans #maxtrans
Views: 282 Connor McDonald
SCPT 43: How Commit and Rollback Works in Oracle
 
20:17
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 22497 Oresoft LWC
Oracle Invisible Column
 
06:18
Oracle 12c new feature - Invisible column https://easy-learning-tech.blogspot.com/2018/05/invisible-column-from-oracle-12c.html oracle 12c new features for developers
Views: 423 Siva Academy
SCPT 46:Oracle Storage Termininology:  High Water Mark and Free Lists
 
15:30
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 18776 Oresoft LWC
Chained rows? Migrated rows?
 
10:37
Understanding the basics of what happens when rows are just too damn big. blog: https://connor-mcdonald.com Highlights from the June DBA Office Hours session. Subscribe as new tech videos come every week!
Views: 745 Connor McDonald
Oracle Core,  Лекция 4
 
43:44
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1hqsC6hEGybAbEEPko56razF7eLBJQEZ3L-ECWtp7rbM/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции:https://docs.google.com/document/d/1UFayi0YIXxLrRuj4-JZj-jooyvpoa4rKLOryBloTtag/edit?usp=sharing 1. Create table: permanent tables, temporary tables (on commit delete/preserve rows) 2. Physical properties таблицы: tablespace, logging, pctfree, pctused, initrans 3. Pctfree и pctused 4. Initrans и maxtrans 5.Storage clause: initial, next, minextents, maxextents, pctincrease, freelists, freelist groups, optimal, buffer_pool (keep,recycle), flash_cache (keep, none), encrypt 6. Table properties: column_properties, cache, result_cache, enable_disable_clause, flashback_archive_clause 7. Alter table: column_clause, constraint_clause, alter_table_partitioning, move_table_clause, enable_disable_clause, rename to, shrink space 8. High water mark. Low high water mark 9. Create index: table index clause, index_expr, index_properties, unusable 10. Reverse indexes 11. Function based indexes 12. Alter index: сжатие (shrink space), параллелизм, физические атрибуты (pctfree, pctused, initrans), logging/nologging, rebuild, enable/disable, unusable, visible/invisible, rename to 13. Индекс по внешнему ключу 14. Причины неиспользования индексов 15. Оператор truncate 16. Неявный commit при выполнении ddl 17. Словари данных Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Oracle DBA Tutorial || Tabelspace in Oracle11gR2 by shiva
 
22:50
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Do NOT index small tables?
 
08:20
How small does a table have to be before you should NOT create an index on it? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #indexes #performance
Views: 491 Connor McDonald
Internals of Binary Tree Indexes
 
09:51
Binary Tree Indexes For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 17038 Oresoft LWC
Oracle DBA - Extents and Segments
 
05:13
http://oracledbazerotopro.com This tutorial explains Oracle Extents and Segments.
Views: 25530 HandsonERP
ROWID - DBArch Video 32
 
05:20
In this video you will understand what is ROWID in an Oracle Database, where is it stored and what are its components. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 5002 Ramkumar Swaminathan
Compression Options for Oracle Database
 
36:49
Held on August 9 2018 This session by Gregg Christman focuses on general questions and insights regarding Oracle Basic Compression, Oracle OLTP Table Compression and Oracle Advanced Row Compression. Here is a quick guide to the highlights: 2:25 Basic vs. Advanced Row Compression comparison 4:55 Should you expect the same compression ratio with Basic and Advanced Row Compression? 8:29 Should you compress all tables and partitions? 15:50 What is the overhead associated with Advanced Row Compression? 17:06 Do I need to change my application to use compression? 17:31 Who uses Advanced Row Compression? 18:35 Is there any ongoing administration with Advanced Row Compression 20:43 When does updated data get compressed? 26:30 What role does PCTFREE play in updates and compression? 28:44 Does Advanced Row Compression work with Oracle Encryption? 29:34 Does enabling compression online or offline make a difference? 31:38 What are the typical compression ratios with Basic and Advanced Row Compression? 32:56 Are there any suggested MOS notes related to compression? 34:12 Feedback about ACO from customers AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 815 Oracle Developers
How Reverse Key B*Tree Index Helps in Certain Cases
 
06:06
When to use Reverse B * Tree Index For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 10875 Oresoft LWC
Best practice for creating indexes
 
14:12
Done properly, creating an index requires a lot of validation effort to ensure you don't totally break your application. Are you doing all the things you are meant to do? In version 19c, the database will follow best practice and do this automatically. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #19c #indexes
Views: 509 Connor McDonald
Peeking on steroids: Adaptive Cursor Sharing
 
06:24
blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Bind peeking in early version of Oracle: https://youtu.be/MnISfllmK74 Issues with bind peeking: https://www.youtube.com/watch?v=ynLF6S15J5M Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #binds #performance
Views: 464 Connor McDonald
Oracle Data Storage
 
09:58
CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. How Oracle stores your tables, how they grow, and how they can go bump.
Views: 8266 roughsealtd
Change INITRANS on table in Oracle database
 
01:36
http://dbacatalog.blogspot.com
Views: 938 dbacatalog
Oracle I:O Architecture
 
03:21
Oracle I/O Architecture watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Row chaining and Row Migration Management
 
14:00
Hi guys today i will give you introduction about row chaining and row migration managing block space. #Rowchaining #RowMigration Oracle database Unbeatable,Unbreakable Platform..
Views: 2376 Oracle World
SCPT 48: Oracle Storage Parameters: INITTRANS and MAXTRANS
 
09:18
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 13574 Oresoft LWC
Oracle DBA - Blocks
 
09:22
http://oracledbazerotopro.com This tutorial explains Operating System Blocks and Database Blocks.
Views: 35568 HandsonERP
SCPT 7: Oracle Control Files
 
12:13
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 45698 Oresoft LWC
SCPT 41: Types of Locks and Latches in Oracle
 
07:11
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 21799 Oresoft LWC
SCPT 23: Oracle Slave Processes
 
11:05
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 17172 Oresoft LWC
SCPT 40: Types of DDL Locks in Oracle
 
11:17
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 13563 Oresoft LWC
SCPT 44: Undo Management In Oracle
 
14:07
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 21952 Oresoft LWC
SCPT 36:What is Locking
 
12:34
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 30750 Oresoft LWC
SCPT 25: Hardware Consideration For Installing Oracle Database
 
21:05
Hardware requirement for Oracle Database For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 11467 Oresoft LWC
SCPT 18: Introduction to Oracle's Processess
 
08:09
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 17491 Oresoft LWC
SCPT 35: Autonomous Transaction
 
10:59
Oracle Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 14916 Oresoft LWC
How to Tune SQL when You Can't Edit the Source Code, Part 2 of 2
 
01:46
How do you tune SQL if you don't have access to the source code? Sometimes. Oracle indexes, statistics, stored outlines, profiles or 12c directives will solve a tuning problem. However, as a last resort, you may want to add a hint. In this case (and you cannot edit the code) DBMS_ADVANCED_REWRITE could be the solution. In Part 2 of this tutorial, Oracle Certified Master DBA John Watson of SkillBuilders completes the demonstration - using DBMS_ADVANCED_REWRITE to change the SQL Oracle executes - without changing the source code!
Views: 805 SkillBuilders
Fine Grain Audit Oralcle Database Administration
 
04:05
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
SGA, PGA, help me with all these GA's
 
04:23
Highlights from the DBA Office Hours session. Subscribe for more highlight videos coming soon! blog: https://connor-mcdonald.com
Views: 524 Connor McDonald
SCPT 4: Introduction to File Structures in Database
 
09:07
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 80719 Oresoft LWC
Oracle Midlands #3: Row Chaining and Row Migration Internals - Christian Antognini
 
01:01:12
The second talk from Oracle Midlands #3 (20th May 2014) was Christian Antognini talking about row chaining and migration internals; how to detect them, why you should care and how to prevent them. Christian kindly gave permission for me to share the video here. The second edition of his book, Troubleshooting Oracle Performance, is out next week. Be sure to check it out: http://www.amazon.co.uk/gp/product/143025758X/ref=as_li_qf_sp_asin_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=143025758X&linkCode=as2&tag=oraclmidla01-21 The PDF and scripts are available at https://www.dropbox.com/sh/dhe7dv9ztejtfxe/AAC1niC43hFBElWF9CZO8EICa This event was sponsored by Red Gate (http://www.red-gate.com/). The Oracle ACE programme was also kind enough to support Christian in visiting us. See more events at http://OracleMidlands.com/ Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. "Fair Dealing" under UK Copyright, Designs and Patents Act 1988.
Views: 2411 Oracle Midlands
SCPT 17: Tools to Manage Oracle's Memory Structure
 
11:54
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 16639 Oresoft LWC
Resolving Latch Contentions - OTW2018
 
48:54
Arup Nanda presents this technical talk during the OTW 2018 unconference in San Francisco.  See the full agenda at https://otw18.org.  For more information about the OakTable, go to https://oaktable.net.  ~Be Kind. Blog Often. Share Responsibly.~
Views: 145 Database Community
Understanding And Resolving Oracle CBC Wait/Latch Contention - Introduction
 
07:10
Understanding And Resolving Oracle CBC Wait/Latch Contention When a server process needs to access a buffer it must access the cache buffer chain (CBC) structure to determine if the buffer is already in the buffer cache. With just the right workload mix, performance can be a problem. Learning about the relevant Oracle internals and how to diagnose and solve CBC performance problems is what this seminar is all about. For more information go to www.orapub.com
Views: 1200 OraPub, Inc.
SCPT 24: Oracle Database Server Installation Scenarios
 
11:21
Oracle DB installation Types. For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 12505 Oresoft LWC