Home
Search results “Oracle index unusable status”
【VDEDU】Unusable indexes use
 
06:29
Unusable indexes in Oracle, DML statements are not use the index to its maintenance, at the same time the optimizer will not use the index. Unusable indexes no segment exists. Unavailable index index becomes available methods are: 1. Place the index can not be truncate operation corresponding table; 2.rebuild index; In addition, the query optimizer can use conversion method expand table so that the SQL statement has encountered unusable index partition table to generate better execution plans.
Views: 68 崔旭
Unusable vs Invisible index   - Oracle 12c
 
05:19
Difference between Unusable and invisible index wrt Oracle 12c. +91 991 2323 000 [email protected] Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Dimensional Modeling Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:131 Erwin Tool Training Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:130 Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/perform... http://www.dbvidya.com/course/dimensional-modeling/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-perform... Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-... Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-t... ER Data Modeling Course : http://www.dbvidya.com/course/er-mode... Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensi... Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 84 DbVidya
skip_unusable_indexes is NOT skipping unusable indexes!
 
06:52
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 331 Connor McDonald
08 09 Demo   Invisible Indexes
 
04:04
ORACLE
Views: 201 oracle ocm
Frgmentation in oracle database
 
34:54
Fragmentation in oracle database,find and defragmentation
Views: 4199 Sainora Annanagar
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
07 04 Index Column Order Matters
 
04:53
ORACLE
Views: 108 oracle ocm
Oracle Histograms Example
 
03:40
An excerpt from "Oracle SQL Tuning Video Tutorial" topic "Oracle Histograms in Oracle 12c" +91 991 2323 000 [email protected] Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Dimensional Modeling Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:131 Erwin Tool Training Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:130 Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/perform... http://www.dbvidya.com/course/dimensional-modeling/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-perform... Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-... Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-t... ER Data Modeling Course : http://www.dbvidya.com/course/er-mode... Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensi... Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 87 DbVidya
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 222 OracleDBA
How Many Indexes Are Too Many?: Finding All The Red Sweets Part 5
 
10:58
Every index you add to a table increases its storage requirements and DML overheads. So it's a good idea to create as few as possible. When you have two or more indexes using the same columns, you may be able to get away with just one. But how do you decide which to keep? This video discusses how to analyze your queries so you can cut the number of indexes you create. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2473 The Magic of SQL
2018 Updated Version for Oracle 1Z0-052 Real Questions
 
01:20
Oracle certification 1Z0-052 real questions and answers have been updated at Testpassport in May, 2018. Share some Oracle 1Z0-052 real exam questions below. 1. Which two statements are true about dispatchers used by the Oracle shared server? A. They pull requests from the requests queue and process them until they are complete. B. A dispatcher Is created for each user process. C. Multiple dispatchers can connect to a single server process. D. Multiple user processes can connect to a single dispatcher. E. They return completed requests to the appropriate user processes. Answer: AD 2.Which two are true about server-generated alerts? A. All stateful alerts can be found in DBA_ALERT_HISTORY. B. They can be based only on database metrics. C. They are visible in Oracle Enterprise Manager by default. D. They can be based only on instance metrics. E. Stateful alerts must always be cleared manually. F. Stateless alerts cannot be found in DBA_OUTSTANDING_ALERTS. Answer: AF 3.Which is true about unusable indexes? A. Rebuilding an unusable index always requires at least twice the space of the original index B. Rebuilding an unusable index creates a new segment after dropping the unusable index. C. Rebuilding an unusable index always allows DML statements on the index's table during the rebuild. D. Rebuilding occurs automatically when an unusable index is chosen by the optimizer when creating an execution plan Answer: B 4.Which Is true when a database instance is shut down? A. Neither the immediate nor the abort mode rolls back uncommitted transactions. B. immediate, transactional, and normal modes all result in a checkpoint. C. Only transactional and normal modes wait for all uncommitted transactions to commit or rollback and then close the database D. immediate, transactional, and normal modes wait for all uncommitted transactions either to commit or rollback and then close the database Answer: B View more 1Z0--052 questions here: https://www.testpassport.com/11g/1Z0-052.asp
Views: 77 Testpassport
Invisible Indexes ( Excerpt from Oracle Tuning Video Tutorial) - Oracle 12c
 
01:41
Oracle 12c Invisible Indexes is a feature , which is useful in oracle performance Tuning. This is an excerpt from "Oracle Performance Tuning Tutorial". [email protected] +91 9912323000 Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/perform... Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tun... Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-perform... Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-... Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-t... ER Data Modeling Course : http://www.dbvidya.com/course/er-mode... Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensi... Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 30 DbVidya
How can I speed up a query if an index cannot help?
 
08:20
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 1451 Connor McDonald
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: 460 Connor McDonald
AskTOM TV - Direct path read
 
04:59
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at direct path reads and how they interact with objects that may already have changed buffers in the buffer cache blog: https://connor-mcdonald.com
Views: 606 Connor McDonald
שיפור ביצועים בטבלאות עם אינדקסים באמצעות UNUSABLE
 
06:26
כאן נראה כיצד ניתן לשפר במאות אחוזים ויותר טעינות מידע לטבלאות על ידי "הקפאה" זמנית של האינדקסים ושימוש יעיל ב-UNUSABLE Index.
Views: 80 Eran Koren
08 08 Invisible Indexes
 
03:27
ORACLE
Views: 136 oracle ocm
Are my index statistics wrong?  Why does NUM_ROWS equal zero?
 
06:27
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 313 Connor McDonald
How to Move Object from one Table Space to Another Table Space? | How to Rebuild the Index ?
 
05:03
This Video will teach you How to Move Object one Table Space to Another | How to Rebuild the Index ? move table from one tablespace to another in oracle 11g oracle move schema to another tablespace oracle how to move objects to another tablespace oracle 11g move schema to another tablespace alter table move tablespace oracle 8i oracle move table script oracle move cluster to new tablespace oracle move table example rebuild index oracle script alter index rebuild online parallel oracle rebuild all indexes oracle index rebuild online vs offline oracle rebuild partitioned index index rebuild oracle best practice index rebuild script in oracle 11g
Views: 1196 Oracle PL/SQL World
Lucie Testimonial on Oracle Performance Tuning DBA Track
 
03:14
http://www.dbvidya.com/blended-training/ [email protected] +91 991 2323 000 Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Dimensional Modeling Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:131 Erwin Tool Training Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:130 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-performance-tuning-videos/ Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-awr/ Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-tool/ ER Data Modeling Course : http://www.dbvidya.com/course/er-modeling/ Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensional-modeling/ Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 116 DbVidya
Difference Between Delete and Truncate
 
03:41
Below is link for Useful Pl/SQL Books http://goo.gl/XMy0tt ---------------------------------------------------------- Difference Between Delete and Truncate in Detail On bigger picture they serve the same purpose but there are many Differences listed with examples Point Delete Truncate 1. Data Recovery Delete: Come under the DML Category, we need to commit or Rollback explicitly to make the changes permanent, so we can recover the data by Rollback command fully with in a session or up to a point if Save Points are used Fall In DDL Category (DDL Command issue the Auto commit implicitly) so no chances of Recovery even not using the Flashback table method. But Truncate operations are also logged , they didn’t generate redo SQL but they are logged , view for truncated data info V$LOGMNR_CONTENTS 2. Data Removal Delete Can remove all or selected data using the Where Clause predicates. Or we can say delete any subset of rows We can Truncate complete table or a partition or sub partition of a table. 3. Speed Delete is Slower because oracle maintain the redo logs for Read Consistency (so that every session connected can see a consistent data at a given point of time ) Delete is very time consuming activity especially when table have numerous indexes and Triggers associated with table Faster as no data logs are maintained no associated trigger firing. 4. DML Triggers Firing DML (Delete) triggers associated with table will fire. DML Trigger will not fire in case of truncate method. 5. Flashback Technology Data can be recovered even after commit operation using Flashback Table options Flashback_transaction_query table will give what to recover and up to which point. Data cannot be recovered in truncate method by Flashback table option. 6. Referential Integrity Constraint Behavior if we don’t have related data in child table then we can delete the data from the parent table or we have variants like On Delete Cascade & on Delete set Null. We can’t truncate a table with enable Referential Integrity Constraint, even there is no data in the child table, we have to disable or drop the constraint if we want to truncate the table. Exception: Truncate is possible if the FK is self-referential means primary key and foreign key are on the same table. 7. Space De allocation or Space Utilization No extent reset with delete when deleting rows from a table, extents are not de allocated, So if there were 50 extents in the table before the deletion, there will still be 50 after the deletion. Truncate: When a table is truncated it will free the space allocated except in case of reuse storage clause. This space can subsequently be used only by new data in the table or cluster resulting from insert or update operations .All extents are de allocated leaving only the extents specified when the table was originally created .Example So if the table was originally created with min extents 3, there will be 3 extents remaining when the tables is truncated. When you truncate a table, NEXT is automatically reset to the last extent deleted. 8. High Water Mark Delete will not reset the high water mark Truncate will reset the High Water mark which is very important for performance point of view as in case of full table scan and full index scan oracle will read all the block under high water mark this makes a lot of difference in terms of performance. 9. Cluster No as such restriction with delete. You cannot individually truncate a table that is part of a cluster. You must truncate the cluster, Delete all rows from the table, or drop and re-create the table. 10. Information Capturing Delete : we can capture the row information what we have deleted using Delete Method, f you are deleting multiple records then use composite data types (collections & records) Truncate Don’t have this feature of capturing the deleted records. 11. Function Based Index Impact DELETE You cannot delete rows from a table if a function-based index on the table has become invalid. You must first validate the function-based index. Truncate: No as such restriction 12. UNUSABLE Indexes Delete no as such feature. Truncate if table is not empty then truncate make all unusable indexes to useable. 13. Complex views You cannot delete data from a Complex view except through INSTEAD OF triggers. But we can delete data from simple Views and MV. We cannot truncate a view simple or complex but you can truncate MV with special Features like Preserve MV Logs and Purge MV Logs. 14. Privileges Delete You need to provide delete table privilege on object. Truncate you must have drop table privilege there is no truncate table privilege exists. 15. Domain Index No as such restriction You cannot truncate the object having domain index in invalid or In progress state
Views: 13972 Ram Gupta
Which indexes can I drop?
 
14:24
Deciding which indexes you can safely drop is not a trivial task - even with the new facilities in 12c Release 2. This Office Hours highlights video shows some of the tools you should have in your arsenal when assessing indexes. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week
Views: 427 Connor McDonald
Office Hours for DBA - April 2018
 
59:47
in this session, Connor McDonald covers a variety of questions challenging the modern DBA: - Getting support for MySQL - Index statistics in the dictionary - Changes to regular expressions in 12c - Understanding queries with unusable indexes - Data change notification to applications https://connor-mcdonald.com https://asktom.oracle.com https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 326 Oracle Developers
Which Oracle tool is best ?
 
02:43
SQL Developer, SQLcl, SQL Plus - what Oracle tools do I use ? blog: https://connor-mcdonald.com music: incomptech.com
Views: 472 Connor McDonald
AskTOM TV - helping you understand the process
 
01:13
blog: https://connor-mcdonald.com Get more than just the solution to questions on AskTom. We're now giving insight into the *how* of problem solving as well. ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 611 Connor McDonald
Spring is in the air!  And so is 18c!
 
01:06
blog: https://connor-mcdonald.com Spring has sprung - and 18c is now generally available on Oracle Cloud.
Views: 648 Connor McDonald
Deletes Without Tombstones or TTLs (Eric Stevens, ProtectWise) | Cassandra Summit 2016
 
36:40
Slides: https://www.slideshare.net/DataStax/deletes-without-tombstones-or-ttls-eric-stevens-protectwise-cassandra-summit-2016 | Deleting data from Cassandra has several challenges, and existing solutions (tombstones or TTLs) have limitations that make them unusable or untenable in certain circumstances. We'll explore the cases where existing deletion options fail or are inadequate, then describe a solution we developed which deletes data from Cassandra during standard or user-defined compaction, but without resorting to tombstones or TTL's. About the Speaker Eric Stevens Principal Architect, ProtectWise, Inc. Eric is the principal architect, and day one employee of ProtectWise, Inc., specializing in massive real time processing and scalability problems. The team at ProtectWise processes, analyzes, optimizes, indexes, and stores billions of network packets each second. They look for threats in real time, but also store full fidelity network data (including PCAP), and when new security intelligence is received, automatically replay existing network history through that new intelligence.
Views: 3348 DataStax
【VDEDU】Check the current state of the  PostgreSQL Database
 
01:15
Every time we look at whether to open the database should use the ps command, we look too much content easily. Command to check the database to the point of professional status right now.
Views: 41 崔旭
Oracle SQL  Tuning Training Recommendations
 
01:27
dbvidya offers "oracle performance Tuning" , "Data Modeling" Online trainings and Video Tutorials. [email protected] +91 9912323000 Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Dimensional Modeling Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:131 Erwin Tool Training Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:130 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/perform... Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tun... Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-perform... Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-... Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-t... ER Data Modeling Course : http://www.dbvidya.com/course/er-mode... Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensi... Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 29 DbVidya
SQL Server 33 - Indexes
 
07:42
Indexes allow us to tell the database that certain columns are columns we want to retrieve commonly. This allows the database to optimize retrieval. Additionally, when we get into the SELECT statement, we will often have to join data from multiple tables. When we correctly add indexes to our tables, we can improve the speed of our SELECT and also our joins. There are two types of Index. One is called clustered and the other is called non-clustered. Clustered indexes determine the actual order of the table. By default this is going to be the primary key column. So when you label a column as PRIMARY KEY, you are also going to be creating an INDEX that is a clustered index. A clustered index is kind of like a telephone book, where the data is right there when you look up a phone number. This means that if you are just making a small database that is only going to store a few things, you may be fine. But more likely than not you are going to want to add additional indexes. When you add a new index, you create a non-clustered index. These things do not actually determine the order of the rows in the table. A way of how you can think of how these work is like an index in the back of a book. The index of the book does not actually contain the data, it just tells you where to find it. What columns do you index? You are going to want every primary key to be indexed. What about foreign keys, are they indexed by default? No, they are not. Of all columns, you are probably going to want to index the foreign keys the most because they are used in joins. Lastly, you will likely want to index columns that you are going to use on a regular basis. You can also make composite indexes just like you can make composite keys. You would want to do this when you are going to constantly being using those columns together. There is a lot to learn on multicolumn indexes. We may explore this concept in more detail and see how SQL Server uses them in a future video, but as of right now it's probably more important that we get a general understanding of all things SQL Server before we deep dive on something like that. In the upcoming videos I'll be teaching you how to create indexes. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 13685 Caleb Curry
2018 CodeTalk Series - Common Database Development Disasters, Connor McDonald, Oracle Corporation
 
01:00:17
The 2018 CodeTalk Series webinars are co-sponsored by ODTUG and IOUG. Developers are under increasing pressure to deliver solutions faster. So often they are encouraged to “just start coding,” and are not given time to stop and think about the best solution to a problem. In this session, I'll take a look at what the results of that can be—failure, delays, and poor performance in your database application implementations. We’ll look at the things done wrong over and over again and how to avoid making the same mistakes yourself.
Views: 193 ODTUG
Got a browser ? Then you've got Oracle Application Express!
 
02:52
Blog - https://connor-mcdonald.com/ AskTOM - https://asktom.oracle.com/ New to Oracle ? You can get started with just a browser !
Views: 342 Connor McDonald
Chris Saxon - Finding All the Red M&Ms: A Story of Indexes and Full Table Scans
 
46:01
'Why isn’t my query using an index?' is a common question people have when tuning SQL. This talk explores the factors that influence the optimizer’s decision behind this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms from their bags. It contrasts using an index range scan and a full table scan to do this. It introduces the concepts of blocks and the clustering factor. It discusses how these affect the optimizer's calculations. It goes on to demonstrate how these concepts work in practice using real SQL queries. This session is intended for developers and DBAs who want to learn the basics of how the optimizer chooses between an index range or full table scan.
Views: 113 Riga Dev Days
【VDEDU】AIX 6.1 installation step
 
34:46
vastdata education, AIX 6.1 installation on Power 5.
Views: 123 崔旭
How to delete a Registry entry (Error Deleting Key)
 
02:05
How to delete a "blocked" Windows registry key using "regedit.exe".
Views: 75837 furulevi
Flying High in Hyderabad
 
02:56
SQL talks, snappy wardrobe changes, and an awesome Oracle Code conference in Hyderabad India. blog: https://connor-mcdonald.com Music: incomptech.com
Views: 222 Connor McDonald
CS50 2017 - Lecture 10 - SQL
 
01:45:22
00:00:00 - Muppet Teaser 00:03:02 - eprint 00:05:07 - Facebook Login Walkthrough 00:14:34 - Flask Sessions 00:28:56 - SQL 00:29:44 - Databases 00:36:55 - SQLite 00:39:01 - Database Operations 00:45:32 - SQL Data Types 00:54:33 - Optimizing the Database 01:06:13 - phpLiteAdmin 01:12:42 - Constraints 01:18:01 - Creating a Database 01:21:58 - sqlite3 01:25:14 - SQL in Python 01:33:15 - SQL Injection Attacks 01:38:50 - Adding SQL to Flask 01:43:31 - C$50 Finance
Views: 38584 CS50
【VDEDU】AIX installed SSH package
 
02:52
AIX6.1 default is not installed SSH service, use SSH to connect AIX server, you must manually install OpenSSH software.
Views: 143 崔旭
DOAG@Talk: Oracle Partitioning: Hilfreiche Funktionen für DBAs und Entwickler
 
07:25
Oracle Partitioning ist wohl eine der am meisten benutzten Optionen der Datenbank. Wie und von welchen Funktionen können Datenbankadministratoren und Entwickler besonders profitieren? Hermann Baer, Director Product Management Data Warehousing bei Oracle, steht im Interview mit Matthias Mann, stellvertretender DOAG-Themenverantwortlicher Datenbankadministration, Rede und Antwort und stellt dabei einige der Funktionen vor.
Views: 99 doagtv
【VDEDU】Uploading  database media to AIX
 
02:42
Uploading database installation media to AIX, you need to modify fsize parameter for allows the user to create unlimited file size, and also install unzip package to decompress than Linux does slightly different.
Views: 9 崔旭
The Evolution of SQL as a Service  - Azure SQL Database Managed Instance with Javier Ville
 
59:30
We will look at the future of SQL Server as a Service. Azure SQL Database Managed Instance is a new PaaS service that will allow us to have almost 100% compatibility with the SQL Server On-Premise platform, allowing us to quickly migrate to the cloud all our applications This service will be available in Azure during the year 2018, so we will make an introduction to it and we will demonstrate how to create an instance, as well as the data migration Javier Villegas Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2017, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability. He is a Microsoft MVP in Data Platform. Javier is a frequent speaker in conferences and events such as SQL Saturday , PASS Virtual Groups, 24 Hours SQL PASS , NetConf, GroupBy and DataPlatformGeeks. @sqlargentina
Fable Anniversary Walkthrough - Gateway to Hook Coast (Xbox 360) [1080p HD]
 
11:36
Part 23 of Fable Anniversary with all Cutscenes and 1080p HD Platforms: Xbox 360 Release Date: 7th Feb 2014 Recorded with: HDPVR 2 Subscribe: https://www.youtube.com/FRWALKTHROUGHS Website: https://www.fireravengaming.com Facebook: https://www.facebook.com/pages/FR-Walktroughs/359599880789160 Twitter: https://twitter.com/FRWalkthroughs Google +: https://plus.google.com/u/0/118185998676788351767/posts Discription: As the biggest-selling RPG on the original Xbox, "Fable" pioneered every player's choice of having a consequence. The world of Albion inspired gamers to fall in love with a franchise for a decade and counting. "Fable Anniversary" will remind players why the "Fable" franchise is so special and why there is nothing else quite like it on any other gaming platform. With an entirely new lighting system, slick new interface, all-new textures, models, achievements and "The Lost Chapters" content, "Fable Anniversary" is the definitive "Fable" experience for beloved and new players alike! "Fable Anniversary Full Movie" "Fable Anniversary Movie" "Fable Anniversary All Cutscenes" "Fable Anniversary All Endings" "Fable Anniversary Guide" "Fable Anniversary PS3" "Fable Anniversary PS Vita" "Fable Anniversary Xbox 360" "Fable Anniversary PS3 Gameplay" "Fable Anniversary PS Vita Gameplay" "Fable Anniversary Xbox 360 Gameplay" "Fable Anniversary Walkthrough" "Fable Anniversary Walkthrough No Commentary" "Fable Anniversary No Commentary" "Fable Anniversary Let's Play" "Fable Anniversary Gameplay" "Fable Anniversary Playthrough" "Fable Anniversary Part 1" "Fable Anniversary Walkthrough Part 1" "Fable Anniversary Walkthrough Part 1 Xbox 360" "Fable Anniversary Walkthrough Part 1 English" "Fable Anniversary Walkthrough Part 1 No Commentary" "Fable Anniversary Playthrough Part 1" "Fable Anniversary Gameplay Part 1" "Fable Anniversary Let's Play" "Fable Anniversary Opening Song" "Fable Anniversary Full Game"
Views: 169 FRWalkthroughs
SQL Best Practices in less than 20 minutes 2/3
 
08:43
CAPTIONS AVAILABLE - View on www.konagora.com where Youtube is blocked. Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. Video transcription of a presentation that was given before several groups of IT managers in a big international bank.
Views: 65013 roughsealtd
Windows 7: Check Disk (chkdsk)
 
09:35
This is a video about how to run a chkdsk (check disk) on your windows OS. CheckDisk will repair and try to recover a dirty file system. Most of the time that I use this is when I see a Blue Screen of Death (BSOD) with a 0x0000007B stop code. This means that the file system is corrupt and you should run a CHKDSK /R on your operating system. Also, I've various people tell me that they need to do this as their file systems become too fragmented. I demonstrate the methods available on Microsoft Windows 2000 XP Vista & Server 2003 and 2008. This is a very important part of disk maintenance. If windos is too corrupt to boot these may also be run from Startup Repair/Recovery Console. The commands I run are... chkdsk /f e: chkdsk /r e: chkdsk /r c: chkdsk /r d: Providing training videos since last Tuesday. http://www.technoblogical.com Thanks for watching.
Views: 367039 Chris Walker
CS50 2018 - Lecture 8 - SQL
 
01:54:22
00:00:00 - Introduction 00:00:50 - Hackathon Teaser 00:02:23 - Week 7 Recap 00:05:35 - C$50 Finance 00:07:47 - Cookies 00:15:46 - store 00:22:22 - Databases 00:27:15 - Mock Database 00:29:07 - SQL 00:39:32 - SQLite 00:51:52 - phpLiteAdmin 01:12:54 - lecture 01:38:39 - Race Conditions 01:45:57 - SQL Injection Attacks
Views: 23835 CS50
Lecture - 14 Query Processing and Optimization
 
56:41
Lecture Series on Database Management System by Dr.S.Srinath, IIIT Bangalore. For more details on NPTEL visit http://nptel.iitm.ac.in
Views: 109755 nptelhrd
【VDEDU】12c OCM亚太地区首场直考考试Hands on全程解析
 
02:11
我是海量数据学院的崔旭老师,2016年5月30日参加了12c OCM亚太地区首场直考考试,考试圆满结束后,提醒大家不要忘了到VUE网站进行Hands on操作,只有完成Hands on操作以后,OU才会进行判卷。整个Hands on过程我已经制作好视频,希望可以帮助到大家!Keep Walking Together!
Views: 78 崔旭
Predefined Reports
 
03:28
• A set of Predefined Reports is available in SQLfly and User could select one or more Predfined Reports • Creates interactive HTML report of all the selected Predefined Report in the SQLfly • User can configure one or more data source for the Predfined Reports • Reports can be scheduled to run at any frequency defined by users.
Views: 31 SQLFLY
Fix : The source file names are larger than is supported by the file system
 
02:37
Fix : The source file name(s) are larger than is supported by the file system So Today we are going to see one weird situation where you are trying to copy or delete something on your computer and this error pop up appears. Which says "The source file name(s) are larger than is supported by the file system. Try moving a location which has a shorter path name, or try renaming to shorter name(s) before attempting this operation." Even If you right click on this file, there are no options like Rename, Delete, Copy and Properties. So basically you can not do anything with this file except let it use your disk space for nothing. Solution for this is very simple. We need to shorten the file path. You can see here the file which I am trying to copy, is way deeper inside the E Drive. And along with the file name the file path is also very long probably exceeding 255 characters. Microsoft restrics users from using the file name that exceeds 255 characters. This is the reason file became unusable. We can not rename the file we can not shorten the file name. So go to the previous directory and rename the directory name to something shorter. Now if you go into the folder and right click on it, it will show all the options which were previously unavailable. And if you try to copy, rename or delete this file, you can easily do that. Even after shorterning the previous directory, still gives you the same error while copying, deleting the file in this folder, than there is a posibility that the file path is still more than 255 characters. So again go to previous directory and shorten the file name. As you can see the error is self explanatory, and tells us the root cause of this issue, which is "Source Path Too Long" and also the resolution is given in the same error saying "Try moving a location which has a shorter path name, or try renaming to shorter name(s) before attempting this operation." If you like the video, keep sharing it, provide your valuable comments and do not forget to hit the subscribe button.
Views: 68786 Techno Math