Search results “Indexes unusable in oracle”
skip_unusable_indexes is NOT skipping unusable indexes!
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: 319 Connor McDonald
【VDEDU】Unusable indexes use
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: 65 崔旭
08 09 Demo   Invisible Indexes
Views: 187 oracle ocm
How can I speed up a query if an index cannot help?
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: 1326 Connor McDonald
Unusable vs Invisible index   - Oracle 12c
Difference between Unusable and invisible index wrt Oracle 12c. +91 991 2323 000 [email protected] 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: 32 DbVidya
Which indexes can I drop?
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: 403 Connor McDonald
How to Detect Soft Corruption in Oracle 12c Database
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: 199 OracleDBA
Frgmentation in oracle database
Fragmentation in oracle database,find and defragmentation
Views: 4052 Sainora Annanagar
How Many Indexes Are Too Many?: Finding All The Red Sweets Part 5
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: 2370 The Magic of SQL
07 04 Index Column Order Matters
Views: 103 oracle ocm
Oracle SQL  Tuning Training Recommendations
dbvidya offers "oracle performance Tuning" , "Data Modeling" Online trainings and Video Tutorials. [email protected] +91 9912323000 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: 18 DbVidya
Which Oracle tool is best ?
SQL Developer, SQLcl, SQL Plus - what Oracle tools do I use ? blog: https://connor-mcdonald.com music: incomptech.com
Views: 448 Connor McDonald
08 08 Invisible Indexes
Views: 122 oracle ocm
Oracle Core,  Лекция 4
Ссылка на файл с презентацией: 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
How to Move Object from one Table Space to Another Table Space? | How to Rebuild the Index ?
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: 1084 Oracle PL/SQL World
Are my index statistics wrong?  Why does NUM_ROWS equal zero?
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: 289 Connor McDonald
Chris Saxon - Finding All the Red M&Ms: A Story of Indexes and Full Table Scans
'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: 105 Riga Dev Days
SQL Server 33 - Indexes
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: 11393 Caleb Curry
Office Hours for DBA - April 2018
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: 303 Oracle Developers
2018 Updated Version for Oracle 1Z0-052 Real Questions
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: 75 Testpassport
Difference Between Delete and Truncate
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: 13560 Ram Gupta
AskTOM TV - helping you understand the process
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: 590 Connor McDonald
AskTOM TV - Direct path read
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: 568 Connor McDonald
SGA, PGA, help me with all these GA's
Highlights from the DBA Office Hours session. Subscribe for more highlight videos coming soon! blog: https://connor-mcdonald.com
Views: 414 Connor McDonald
Spring is in the air!  And so is 18c!
blog: https://connor-mcdonald.com Spring has sprung - and 18c is now generally available on Oracle Cloud.
Views: 646 Connor McDonald
Got a browser ? Then you've got Oracle Application Express!
Blog - https://connor-mcdonald.com/ AskTOM - https://asktom.oracle.com/ New to Oracle ? You can get started with just a browser !
Views: 339 Connor McDonald
Windows 7: Check Disk (chkdsk)
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: 364031 Chris Walker
Fix : The source file names are larger than is supported by the file system
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: 66833 Techno Math
2018 CodeTalk Series - Common Database Development Disasters, Connor McDonald, Oracle Corporation
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: 185 ODTUG
How to delete a Registry entry (Error Deleting Key)
How to delete a "blocked" Windows registry key using "regedit.exe".
Views: 73174 furulevi
Lecture - 14 Query Processing and Optimization
Lecture Series on Database Management System by Dr.S.Srinath, IIIT Bangalore. For more details on NPTEL visit http://nptel.iitm.ac.in
Views: 108911 nptelhrd
Flying High in Hyderabad
SQL talks, snappy wardrobe changes, and an awesome Oracle Code conference in Hyderabad India. blog: https://connor-mcdonald.com Music: incomptech.com
Views: 221 Connor McDonald
שיפור ביצועים בטבלאות עם אינדקסים באמצעות UNUSABLE
כאן נראה כיצד ניתן לשפר במאות אחוזים ויותר טעינות מידע לטבלאות על ידי "הקפאה" זמנית של האינדקסים ושימוש יעיל ב-UNUSABLE Index.
Views: 79 Eran Koren
Stop wasting your time on Performance Tuning
Follow me on twitter: https://twitter.com/connor_mc_d Thinking about performance is important. Understanding performance is important. But that doesn't mean that you should be obsessing about performance in every last piece of your application. At AskTOM, we certainly don't :-) AskTOM data model: https://connor-mcdonald.com/2018/06/08/the-asktom-data-model/ music: kevin mcleoud (incomptech.com)
Views: 478 Connor McDonald
The Evolution of SQL as a Service  - Azure SQL Database Managed Instance with Javier Ville
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
Deletes Without Tombstones or TTLs (Eric Stevens, ProtectWise) | Cassandra Summit 2016
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: 3226 DataStax
CS50 2017 - Lecture 10 - SQL
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: 37104 CS50
CS50 2018 - Lecture 8 - SQL
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: 17622 CS50
SQL Best Practices in less than 20 minutes 2/3
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: 64888 roughsealtd
【VDEDU】AIX 6.1 installation step
vastdata education, AIX 6.1 installation on Power 5.
Views: 119 崔旭
【VDEDU】Uploading  database media to AIX
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 崔旭
【VDEDU】Open and close the PostgreSQL database
Open and close different databases with different features, let us look at the open, shut down the entire process of PostgreSQL database it.
Views: 144 崔旭
Lecture -15 Query Processing and Optimization II
Lecture Series on Database Management System by Dr.S.Srinath, IIIT Bangalore. For more details on NPTEL visit http://nptel.iitm.ac.in
Views: 44690 nptelhrd
【VDEDU】Check the current state of the  PostgreSQL Database
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: 39 崔旭
Baron Schwartz: MySQL, SQL, NoSQL, and Open Source in 2014 and Beyond
Google Tech Talk February 13, 2014 (more info below) Presented by Baron Schwartz (Co-Founder & CEO of VividCortex) ABSTRACT Predictions are hard to get right, especially when they involve the future. Rather than predict the future, I'll explain how I view the relational and NoSQL database worlds today, especially the MySQL product and community, but including open-source and proprietary data management technologies about which I know enough to get in trouble. I'll explain how my self-image as a practitioner and contributor has changed, especially as I've moved from consulting (where I tell people what they should do) into being a company founder (where I sometimes wish someone would tell me what to do). As for the future, I'll express my preferences for specific outcomes, and try to be careful what I wish for.
Views: 12692 GoogleTechTalks
【VDEDU】12c OCM亚太地区首场直考考试Hands on全程解析
我是海量数据学院的崔旭老师,2016年5月30日参加了12c OCM亚太地区首场直考考试,考试圆满结束后,提醒大家不要忘了到VUE网站进行Hands on操作,只有完成Hands on操作以后,OU才会进行判卷。整个Hands on过程我已经制作好视频,希望可以帮助到大家!Keep Walking Together!
Views: 77 崔旭
How to fix Google Chrome Page Unresponsive problem in Windows 10 (3 Possible Solutions)
You can fix Google Chrome "Page unresponsive: The following pages has become unresponsive, Kill pages or wait" problem by three simple methods. Method #1: 0m4s type %localappdata% in searchbar and open localappdata folder. Go to Google\Chrome\User Data. Rename Default as Defaultold. Method #2: 1m1s search Google Chrome in searchbar. Right click on Google Chrome in the results and click on Open file location. Right click on Google Chrome in the folder and chose Properties. Now change the value of "Target" in the Shortcut tab. After "chrome.exe" type the following with a space before it -no-sandbox click on apply and ok. Method #3: 1m53s Download official Google Chrome Clean-up tool from official google chrome website as shown in the video. https://dl.google.com/dl/softwareremovaltool/free-range/win/chrome_cleanup_tool.exe Now run the file...click next..next...This will clean your Chrome! You'll not miss the bookmarks, saved passwords and history! Please consider a LIKE if it works!
Views: 48975 Iviewgle
File system
In computing, a file system (or filesystem) is used to control how data is stored and retrieved. Without a file system, information placed in a storage area would be one large body of data with no way to tell where one piece of information stops and the next begins. By separating the data into individual pieces, and giving each piece a name, the information is easily separated and identified. Taking its name from the way paper-based information systems are named, each piece of data is called a "file". The structure and logic rules used to manage the groups of information and their names is called a "file system". There are many different kinds of file systems. Each one has different structure and logic, properties of speed, flexibility, security, size and more. Some file systems have been designed to be used for specific applications. For example, the ISO 9660 file system is designed specifically for optical discs. This video is targeted to blind users. Attribution: Article text available under CC-BY-SA Creative Commons image source in video
Views: 373 Audiopedia
Fix CRC Error in RAR Files & Extract Data
http://www.winrarrepair.net/file-crc-error.html - Hello Everyone, This video will show you simple 4-step procedure to extract data from inaccessible RAR file, after encountering CRC errors; which may occur due to bad sectors in the storage disk, virus infection during download or transmission errors. As some people recommend, you may try the Repair tool provided in Winrar under Tools section. However, I didn't find this tool efficient enough to repair the CRC error affected archives. It didn't gave any errors when I tried, but my RAR file was in the same state of corruption. So, what I suggest is, you must try any third-party repair utilities available on the internet. Subscribe my channel to view more about repair process of different types of files. To get the software, visit the site, I have mentioned its link above. Hope I helped you in some way. Good Bye.
Views: 179472 Samuel Acorn