Search results “Oracle show cpu usage”
Detailing Oracle CPU Consumption: The Missing Link - Seminar Introduction
Detailing Oracle CPU Consumption: The Missing Link helps Oracle Database Administrators answer this question, "What's Oracle doing with all that CPU?" For details go to http://www.orapub.com/video-seminar-detailing-cpu-consumption Here's the problem: While Oracle has the world's most advanced database wait time instrumentation, Oracle does NOT instrument CPU consumption. This presents the Oracle DBA with a tuning handicap because CPU consumption can be a significant component of database time. The unintentional result can be solutions with a wait time bias and solution guessing. In this session you will learn how to determine where Oracle is consuming CPU down to the Oracle kernel code function level and how this relates to the broader performance situation. Now you will be able to more effectively develop solutions to reduce both CPU consumption and wait time. Important: The solution created to solve the CPU detail limitation is Linux based. While I'm confident there are very similar solutions in other operating systems, I do not explore this. What You Will Learn - How to answer the question, "Is that process doing anything or stuck?" - How to answer the question, "So what is Oracle doing with all that CPU?" - How to overcome the problem of understanding limitation when there is little wait time but lots of CPU time. - Finding the Oracle kernel function when there could be a possible bug. - Helping you understand what Oracle is doing, "under the hood." Modules - The problem and what to do about it - My journey to find a solution - Creating the solution based on the Linux "perf" tools - Examples of how to use the tool in production situations For information on how you can watch the whole seminar or for more great eduction from OraPub, go to www.orapub.com
Views: 1916 OraPub, Inc.
Debugging CPU Issue
Views: 4873 Prashant Lakhera
Oracle VM 3.2.1 CPU pinning
In this demo of Oracle VM Manager 3.2.1 I will show what CPU pinning is, and what it look like in an VM. Hard Partitioning with Oracle VM Server for x86 (PDF) http://www.oracle.com/technetwork/server-storage/vm/ovm-hardpart-168217.pdf
Views: 2705 gandalf3100
Oracle Enterprise Manager 12c: Monitor an Individual Host
This demonstration shows you how to monitor an individual host, including CPU, memory, and network utilization, incidents, compliance, log file alerts and other targets on this host. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Confused? vCPUs, Virtual CPUs, Physical CPUs, Cores
Check out this brief video about vCPUs, CPUs and Virtual Machines.
Views: 86258 Jeffrey Lush
Shell Script to Monitor Network, Disk Usage, Uptime, Load Average and RAM Usage in Linux/Ubuntu
Hello Everyone, In this tutorial, How to Configure & Shell Script to Monitor Network, Disk Usage, Uptime, Load Average and RAM Usage in Ubuntu 15.04 - 32bit or 64bit You can also configure in Redhat Linux, CentOS, Fedora, Debian, Linux Mint, Xubuntu. Download the Script from Jumpshare.com Step1 :- http://jmp.sh/v/aCo3L7Qrm8FzwWn1tqGP Step2 :- chmod 755 cloudnetwork_monitor.sh To install Step3 :- ./cloudnetwork_monitor.sh -i Step4 :- monitor NOTE :- For Any Clarification Please Below Comment, Like and Share us and help us to spread. ####--------------------------------------------------------------------------------------#### Subscribe :- http://www.youtube.com/user/itcloudnet?sub_confirmation=1 Website :- http://www.cloudnetwork.in Facebook :- http://facebook.com/itCloudNetwork/ Twitter :- http://twitter.com/itcloudnet Pinterset :- http://pinterset.com/itcloudnet LinkedIn :- http://in.linkedin.com/pub/itcloudnet Google+ :- https://plus.google.com/u/0/107923552480070716949/posts Skype Id :- cloud.network1 E-Mail Id :- [email protected] ####----------------------------------------------------------------------------------------#### Thanking You Hope U Like it........
Views: 12680 Cloud Network
Caching In: Understand, Measure, and Use Your CPU Cache More Effectively
Modern computationally intensive tasks are rarely bottlenecked by the absolute performance of your processor cores. The real bottleneck in 2013 is getting data out of memory. CPU caches are designed to alleviate the difference in performance between CPU core clock speed and main memory clock speed, but developers rarely understand how this interaction works or how to measure or tune their application accordingly. This session aims to address this by • Describing how CPU caches work in the latest Intel hardware • Showing what and how to measure in order to understand the caching behavior of software • Giving examples of how this affects Java program performance and what can be done to address poor cache utilization Author: Richard Warburton Richard Warburton is a software developer who loves solving complex problems, but actively challenges how much of software development is dealing with day-to-day trivialities. Having obtained a PhD in the area of compiler optimizations and static analysis, he has been applying his abilities in industry. Initially on bytecode analysis software, and more recently on Java performance tuning tools. He actively involves himself in the London Java Community, and its Java Community Process Committee. He has been helping with the push to improve and complete the JSR 310 API and the expand community engagement with JSR 335. View more trainings by Richard Warburton at https://www.parleys.com/author/richard-warburton Find more related tutorials at https://www.parleys.com/category/developer-training-tutorials
Views: 16159 Oracle Developers
Identify Database Bottlenecks with Performance Monitor Counters [HD]
Description: This video is about How to Identify Database Bottlenecks with Performance Monitor Counters [HD]. You can refer complete Text Tutorial on my website: www.SQLServerLog.com You can join me on social networks: Facebook: http://www.facebook.com/SQLServerLog Linkedin: http://in.linkedin.com/in/SQLServerLog Google+: http://www.google.com/+SQLServerLogs Twitter: http://www.twitter.com/SQLServerLog
Views: 14806 SQLServer Log
Utilization On Steroids | OraPub Online Institute
For details go to http://www.orapub.com/video-seminar-utilization-on-steroids Utilization On Steroids is a fast-paced, one-hour video seminar for busy Oracle DBAs and Developers. No boring slide decks here! This is high quality video training for an amazing online experience. I has taken me 20+ years to learn what I know and now I'm sharing it with you. You will learn in one hour what took me years to create. I will reveal my approach to calculating utilization. You will see the tools I use in action. I show you how to gather the data and give you my information sources. This nine-module seminar makes you better at Oracle Database performance tuning by digging deep into the realm of utilization. To register and for more information go to: http://www.orapub.com Here is what you can expect to learn: * Possess an intuitive understanding of utilization * See how OS tools gather raw performance data * See how Oracle gathers OS statistics and their reliability * Have the ability to calculate CPU utilization two different ways from v$osstat * Determine your database server's "unit of power" - the core, thread, etc. * Understand the issues with virtualized environments and what to do about them * Be able to apply utilization concepts to IO subsystems, memory and networks * Be able to effectively and authoritatively use utilization in your daily Oracle performance optimization work The course modules are: 1. Introduction/Preview (this video) 2. What is utilization? 3. Where OS tools collect performance data 4. Where Oracle collects OS performance data 5. Calculating OS CPU utilization using the core method 6. Calculating OS CPU utilization using the busy:idle method 7. Utilization challenges and solutions in a virtualized environment 8. Calculating and using your DB server's unit of processing power 9. Additional resources and seminar close To register and for more information go to: http://www.orapub.com
Views: 623 OraPub, Inc.
Oracle Enterprise Manager 12c: Use Active Session History (ASH) Analytics
This demonstration shows you how to monitor your database using Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Forms opening slowly Troubleshooting
https://amzn.to/2Ph2CbI [affiliate link] We are back again with some issues and solutions. Actually one of my friends asked me regarding performance tuning if forms are opening slow. That time I gave him some ideas and promised him that I will back very soon with some more information. There are lots of factors which may impact the applications but there are some work around which can helpful fixed the issues. One more thing I would like to tell, friends I shared my knowledge’s as per my real time experiences and real life experiences. So, there is not like just copying and pasting the stuff. As already I have shared my real life time stories which I have learned from my life. So, let’s start now. Suppose, our forms are opening slow then what things we should be check and how to debug it. I will try to explain here and share my knowledge. I am sure; it will be useful because it’s having been experienced. 1. We should check which forms are opening slowly either any particular form or all forms. 2. If all forms are opening slowly for particular machine then clear the cache and try again. It can be machine speed slow, machine hardware and bandwidth speed. If all forms are opening slow and for all machine then we really need to check below things such as: A. Check whether Trace is enabled or disabled and if it is enabled then kindly disabled it. B. Check the top commands if any resources are consuming high CPU usage. C. Check for all Inactive Sessions if it’s there then kill those sessions. D. Check for deadlocks. E. Every user should close the forms and logout properly. But actually we don’t care. We just close windows tab at a time and left for break :D :P but that’s also impact our EBS internally. F. A programmer if ran any program with infinite loops then this also cause a performance issue. That’s why we need to write any program carefully. If program not properly then it may cause deadlock as also which I have explained it in my previous posts. G. It can also be because of increasing the number of users. Also need to check users have one active session. H. Check for the Performance Pack (Native I/O) is turned on for WLS. And most and always we use this method. If the users have issue for any custom forms then we should follow below steps which are easy and very effective. When he run the program that time you should follow below steps: 1. Enable the Trace file. Login to front-end - Help - Diagnostics - Trace - "Trace with Binds and waits” . Then there will be a trace file generate under below patch: $cd $ORACLE_HOME/admin/$CONTEXT_NAME/udump Now you can run either Trace Analyzer or tkprof as shown below commands: Trace Analyzer command: $sqlplus apps/apps_password SQL START TRCANLZR.sql UDUMP ora-data_ora1919.trc; TKPROF command: $ORACLE_HOME/admin/$CONTEXT_NAME/udump $tkprof ora-data_ora_1919.trc ora-data_ora_1919.txt explain=apps/apps_pwd Hope this may useful and helpful. We will come back again with new troubleshooting and solution as what we should do if forms opening slow after increasing the number of session. For any concerns or suggestions please reach to us either by comment box or contact us @ ora-data.blogspot.com.
Monitoring Disk Space utilization and Send Email Alert
Monitoring Disk Space utilization and Send Email Alert. Using this shell script we can monitor all mount point usage based on specified threshold value it will send an email alert to email address specified in script. Facebook Page: https://www.facebook.com/Linuxarkit/ LinkedIn Profile: https://www.linkedin.com/in/ravi-kumar-94530121 Google Plus: https://plus.google.com/u/0/+RedhatEnterpriseLinuxStepbyStepGuide Twitter: https://twitter.com/aravikumar48 RSS Feed: https://feedburner.google.com/fb/a/mailverify?uri=arkit GetPocket: https://getpocket.com/@em6gvd95p09cFA4di1T23c2T28Acp7a92c9J1cV31cc953y26eWfrex2FptHu24f Reddit: https://www.reddit.com/user/aravikumar48/ Tumblr: https://www.tumblr.com/blog/aravikumar48
Views: 3674 Tech Arkit
How to add more CPU cores to Virtual Machine in VirtualBox
How to add more CPU cores to a Virtual Machine in VirtualBox some of you might have a good CPU but are only use one core on your virtual computer.. This video shows you how you can add more cores depending on your CPU so you can use Virtual Machine too its full potential
Views: 6507 Haig Dickson
How to see how much CPU usage an application is using in Windows Server 2012
Author and talk show host Robert McMillen explains how to see how much CPU usage an application is using in Windows Server 2012.
Views: 332 Robert McMillen
100 percent disk usage windows 10 fix
Fix 100% disk utilization in task manager - Windows 10 - Simple 3 Step Procedure to make your PC faster For More Tutorials, Tips, Tricks and Hacks on Linux, Oracle, Android, Windows, Whatsapp click on the Below Links. Subscribe : https://www.youtube.com/subscription_center?add_user=technologylair Website : http://techlair.info Facebook : https://www.facebook.com/technologylair
Views: 217236 TechLair
Oracle Performance Tuning onlineTraining
Feel free to contact Call : +91-8870903864 Or E-mail [email protected] ORACLE PERFORMANCE TUNNING 1 – 1: Introduction to Oracle tuning - The top-down approach to tuning - The history of Oracle tuning - A review of the Oracle architecture - The goals of Oracle tuning - Overview of SQL tuning - Oracle network bottlenecks - Oracle RAM usage and bottlenecks - Oracle CPU usage and bottlenecks - Oracle disk I/O overview - Monitoring server (sat, vmstat, top, glance) - Movement toward server consolidation 1 – 2: Oracle disk I/O tuning - History of DASD - Understanding disk I/O - Monitoring disk I/O (AWR, dba_hist_filestatxs) - Sorted hash cluster tables - Disk I/O waits - Oracle data buffer internals (db_cache_size) - Caching data blocks in the PGA (parallel full-table scans) - Blocksize and I/O performance 1 – 3: Oracle CPU Tuning - Finding your cpu_count - Measuring CPU usage with vmstat - Oracle CPU usage - Using processor affinity - _optimizer_cost_model=cpu - Parallel query and CPU 1 – 4: Oracle RAM tuning - all_rows and first_rows optimization and RAM - Multiple data buffers - Multiple blocksizes - Measuring RAM paging - Oracle SGA RAM - Oracle PGA RAM - Using the KEEP pool - Automatic Memory Management (AMM) 1 – 5: Oracle Instance Tuning - Global tuning techniques - Display possible unnecessary large-table full-table scans - Library cache tuning - Finding missing indexes - Tuning the database writer - instance parameter tuning 1 – 6: Oracle SQL Tuning Introduction - SQL tuning hierarchy - SQL tuning goals - optimizer modes - query re-write - cursor_sharing - viewing execution plans (autotrace) - verifying optimal join techniques - parallelizing SQL execution - dynamic statistics - Exercise – count times when a table is invoked - 12c new SQL features - function-based virtual column - adaptive execution plans - 12c new optimizer metadata collection features 2 – 1: AWR and ASH - AWR vs STATSPACK - Reading an AWR report - AWR report analyzer - Basics of predictive modeling for performance - Finding repeating signatures of data 2 - 2: Oracle RAC Tuning - RAC architecture tuning - Tuning disk I/O on RAC - Tuning the cache fusion layer on RAC 2 – 3: Oracle Tuning Pack - creating SQL Profiles - Recommending new indexes - “automatic” SQL Tuning - SQL Performance Advisor (SPA) - recommending object reorganization 2 – 5: Oracle Diagnostic pack - AWR and ASH - real time SQL monitoring - comparing performance periods - Oracle monitoring & alert notifications (setting thresholds) 2 – 6: Oracle Tracing - 10046 tracing - TKPROF tracing - Trace analyzer - Autotrace 3 – 1: Introduction to SQL tuning - Pre-SQL database communications - The evolution of SQL - Declarative languages 3 –2: Optimizing Oracle SQL - Parsing a SQL statement - Semantic parsing - Hard parse vs. soft parse - Decision tree generation - Making SQL reentrant 3 –3: Optimizer statistics - Types of metadata - Index metadata - Segment metadata - Server metadata - System stats 3 – 4: Exposing & Reading Execution Plans - autotrace - SQL*Trace - Determine the steps of an execution plan 3 – 5: altering execution plans - Changing CBO statistics - Changing init.ora SGA parameters - Changing optimizer parameters - Using hints - Using the opt_param hint 3 – 6: Oracle indexing - Overview of Oracle indexing - bitmap indexes - bitmap join indexes - guidelines for creating indexes - function-based indexes (FBI) - index usage monitoring - fishing in the library cache - optimizing indexes - The transient nature of indexing - database modality of workloads - SQL Workload analysis - Identifying EOW, EOM and EOY SQL. - Creating on-demand indexing - oracle text indexes Oracle Performance Tuning training online, Oracle Performance Tuning training material, IBM Websphere Application Server training cost, Oracle Performance Tuning training pdf, Websphere Application Server training in USA uae India, Oracle Performance Tuning training, online Corporate training malaysia Singapore, Oracle Performance Tuning software, Oracle Performance Tuning training in bangalore, Oracle Performance Tuning training institutes in hyderabad, Oracle Performance Tuning training in chennai, Oracle Performance Tuning training in hyderabad, Delhi, Mumbai, Pune, Oracle Performance Tuning, IBM Websphere ApplicationServer webinar, online training singapore, Oracle Performance Tuning eam, Oracle Performance Tuning as a service,Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training maximo scheduler, Oracle Performance Tuning (consumer product) Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training Oracle Performance Tuning online Training , Post Training Support
Oracle VM Manager 3.2.1 show hot re-assign of CPUs (cool demo)
This is a cool demo of Oracle VM Manager 3.2.1 with Oracle VM server for SPARC 3.0. I Dynamically re-assign CPUs in a running VM on Solaris 10. Imagine that your VM/Application in running low on CPU power, and without stopping the VM. You just add or remove CPUs. :-)
Views: 1365 gandalf3100
centos 6 - check free memory, cpu usage & running program
chek memory, cpu & running program on centos 6 : ##check free memory free -m ##check cpu usage & running program top
Views: 3611 CentOS Tutorials
Top 10 Linux Job Interview Questions
Can you answer the 10 most popular Linux tech job interview questions? 0:00 Introduction 0:53 Tech Phone screens 1:50 How to check the kernel version of a Linux system? 2:50 How to see the current IP address on Linux? 4:03 How to check for free disk space in Linux? 4:55 How to see if a Linux service is running? 6:33 How to check the size of a directory in Linux? 7:02 How to check for open ports in Linux? 9:48 How to check Linux process information (CPU usage, memory, user information, etc.)? 11:49 How to deal with mounts in Linux 13:51 Man pages 15:04 Other resources How to ask questions the smart way: http://catb.org/~esr/faqs/smart-questions.html This is a list of the most common Linux System Administration Job Interview Questions. These questions are commonly used as 'filters' in a phone screen or first-round interview. Make sure you know all the answers, and the reasoning behind them! This video only covers Linux-related interview questions; the position you're interviewing for might involve other technologies, too: -databases (or a specific database) -networking -programming, or a specific language -infrastructure / architecture -specific applications or services -AWS, Google Cloud More Linux Tutorials ############### Free Linux Sysadmin Course Playlist: https://www.youtube.com/playlist?list=PLtK75qxsQaMLZSo7KL-PmiRarU7hrpnwK Check out my step-by-step project-based Linux course for beginners, 93% off when you use this link: https://www.udemy.com/hands-on-linux-self-hosted-wordpress-for-linux-beginners/?couponCode=TL-YOUTUBE Official Site & e-mail list: https://tutorialinux.com/ Twitter: https://twitter.com/tutorialinux Facebook: https://www.facebook.com/tutorialinux Patreon: https://www.patreon.com/tutorialinux Podcast: http://kernelpanicpodcast.com
Views: 944834 tutoriaLinux
ubuntu 14.04 check your cpu and mem usage using htop 20feb2016
http://askubuntu.com/questions/114997/how-where-do-i-check-my-ubuntu-laptopss-cpu-usage/115044 Help us caption & translate this video! http://amara.org/v/HtVW/
Views: 1790 Dennis G D
Performance Analysis with Project Monitoring in the Oracle Solaris Studio IDE
Learn how to monitor the CPU, memory, and thread usage of your application through this audio-less screencast. The Oracle Solaris Studio IDE is specifically optimized for enterprise C, C++ applications and helps improve developer productivity and reduce time to deliver applications. Download a free copy and learn more about Oracle Solaris Studio at: http://www.oracle.com/technetwork/server-storage/solarisstudio/overview/index.html Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Identifying Long Running Queries
Tuning the performance of your queries in SQL Server can be a lot of work. However, in order for your systems to receive the full benefits of query tuning, you must tune the queries that need it the most. This session will show you three different methods for determining which of the queries on your system are being called the most frequently, take the longest period of time to run, or are using the most resources. You'll be able to use the information in this session to quickly set up your own metrics gathering processes in order to understand what is happening on your systems and which queries will benefit most from tuning. Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011. Hosted by Steve Cantrell of DBAFundamentals
Views: 12782 DBAFundamentals
How to Monitor the Linux CPU and I/O statics using iostat
This video illustrates the step by step procedure to monitor the Linux CPU and I/O statics using iostat tool. For more explanation on this video: https://www.linuxhelp.com/monitor-cpu-io-statistics-iostat/
Views: 5713 Linux Help
Windows 98 on VirtualBox - How to do it properly. 32bit Graphics, ACPI and Internet Access.
Windows 98 is not supported on VirtualBox and it runs really badly. For Windows 98 to run properly it has to be installed with ACPI, without it, CPU usage will be at a constant 100% (Things can be improved further with a piece of software called RAIN, this will be shown in a future video.). If you install everything correctly, Windows 98 will run in VirtualBox like a dream, this video will show you how. SciTech Display Doctor: Here is the key for display doctor. I have included this as the company does not exist anymore and there is no possible way to buy and/or register the product. Name: CSCKnight Serial: 0B5E-12B4-A8A4-0B https://www.virtualbox.org/wiki/Downloads https://winworldpc.com/library https://www.fileplanet.com/85954/80000/fileinfo/SciTech-Display-Doctor-v7.0-Beta Part 2 will show you how to tune Windows 98 to run Games and other software at optimum performance. Coming soon! A mix of modern and vintage programming languages. From 8 bit consoles to early PC languages such as Pascal, all the way to Java and C#. In addition we will show you how to make games on all of these languages and on modern Game Engines such as Unity.
Views: 44557 Nevets
Two Queue Or Not To Queue, That Is The Question - Seminar Intro
Two Queue Or Not To Queue, That Is The Question will help you tune Oracle systems faster and with a greater depth of understanding. The insights you gain provide both a tactical and strategic performance tuning advantage. From driving in traffic to being served at a restaurant, every person feels the impact of queuing theory. Queuing theory beautifully relates time and work into experiences we can feel; like utilization, workload intensity, response time, elapsed time, user experience and systems architecture design. Queuing theory can be well...theoretical! But Oracle ACE Director Craig Shallahamer turns this topic upside down making it a fantastic learning experience. For details go to http://www.orapub.com/video-seminar-to-queue-or-not For details on OraPub go to www.orapub.com Modules 1. Setting The Stage 2. You Can't Escape A Queuing Theory World 3. The Work And Time Relationship 4. Craig's Hamburger Stand - Definitions 5. Utilization Explored 6. Response Time Explored 7. Going Deeper Part 1 - CPU and IO Subsystems 8. Going Deeper Part 2 - Changing Parameter Values 9. How Queuing Theory Is Used By DBAs 10. Seminar Close What You Will Learn - How to tune Oracle systems faster by understanding queuing theory - How to merge queuing theory into Oracle database performance tuning - What truly is response time - How response time relates to workload intensity, utilization... user experience - How to explain a performance incident from a practical queuing theory perspective - How every person is immersed in a queuing theory world - How an Oracle time-based analysis intimately relates to queuing theory - Why increasing an Oracle workload can hurt performance - How to understand the classic response time curve - How the response time curve relates directly to SQL elapsed time - What are the key queuing theory parameters - Why performance slows when CPUs and IO devices get busy - How to get the busyness for your CPU and IO subsystem - How to calculate the CPU subsystem utilization from v$osstat - Why CPU and IO subsystems are different queuing systems - What happens when we tweak queueing theory input parameters - How is utilization and response time are affected by more or faster CPUs - How does adding more IO devices affect SQL statement elapsed time - How does queuing theory relate to a SQL statement's elapsed time - Why pushing more work through your Oracle system consumes more CPU and potentially more wait time - How can I determine the response time for a SQL statement - How queuing queuing theory relates to performance tuning - How queuing theory parameters relate to my Oracle database activity - How applying queuing theory focuses my performance tuning solutions - How queuing theory can be used in forecasting and predictive analysis - How can I tell if a performance solution is bogus using queuing theory - How can I pick better tuning solutions using queuing theory - How I can use my AWR or Statspack report from a queuing theory perspective
Views: 367 OraPub, Inc.
How to enable Virtualization (HP550 Laptop, Intel CPU)
Similar examples: - Dell Latitude E5550 ► https://www.youtube.com/watch?v=J377EdVY0jQ - MSI B350 PC MATE ► https://www.youtube.com/watch?v=OtTkbfscU3g - Asrock N68C-S UCC ► https://www.youtube.com/watch?v=XgF7RiXs43k
Views: 31679 furulevi
Why Is My Query Slow? More Reasons Storing Dates as Numbers Is Bad
Storing dates as numbers can cause unexpected problems. In this video Chris looks at one possible issue: inconsistent query performance. He then shows methods you can use to improve performance, including function-based indexes and histograms. ============================ 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: 7422 The Magic of SQL
Improve SQL Server performance using profiler and tuning advisor
For more such videos visit http://www.questpond.com See our other Step by Step video series below :- Learn SQL Server Step by Step in 16 hours:- http://tinyurl.com/ja4zmwu Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Angular tutorial for beginners https://tinyurl.com/ycd9j895 Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MVC 5 Step by Step in 16 hours:- https://goo.gl/dmdakg Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn Design Pattern Step by Step in 8 hours:- https://goo.gl/eJdn0m Learn C# Step by Step in 100 hours :- https://goo.gl/FNlqn3 Learn Data structures & algorithm in 8 hours :-https://tinyurl.com/ybx29c5s Learn Javascript in 2 hours :- http://tinyurl.com/zkljbdl Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn TypeScript in 45 Minutes :- https://goo.gl/oRkawI Learn webpack in 50 minutes:- https://goo.gl/ab7VJi Learn Visual Studio code in 10 steps for beginners:- https://tinyurl.com/lwgv8r8 Learn Tableau step by step :- https://tinyurl.com/kh6ojyo This video first starts with a simple explanation of what is a SQL server profiler and performance tuning wizard. After completing the basic concepts it then demonstrates a simple example using two tables by capturing the work load and understanding the recommendations given by the tuning wizard. For more such videos visit http://www.questpond.com We are also distributing a 100 page Ebook "Sql Server Interview Questions". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
SQL Monitor 6 - New features
Mark Champion, Product Marketing Manager at Redgate, talks you through the major new features in SQL Monitor 6, including: 00:33 New diagnostic interface 03:10 Query plans To find out more about SQL Monitor, visit https://www.red-gate.com/sql-monitor Or download it now https://www.red-gate.com/dynamic/products/dba/sql-monitor/download ----- Transcript ----- Hi I’m Mark Champion, one of the team behind SQL Monitor. We have recently released version 6 of our SQL Server monitoring and alerting tool, SQL Monitor, and I want to show you what’s new, what’s great and how SQL Monitor can make your job easier. In version six we have make it quicker and simpler to diagnose the cause of problems affecting a server. The main changes you will see are centred on the server/instance overview, which we get to by clicking here. In previous versions the information was displayed across a variety of screens, and it could be fiddly to jump between them to get the information you needed. In version six we’ve brought all that information together into this one server overview. Starting at the top of the page there’s an overview graph showing four key metrics for this server, the CPU and Memory usage, Disk I/O, and Waits. These can all be turned on and off like this. We can also baseline any of these, based on the previous 7 periods. By default this graph shows the past 24 hours, but you can look at longer or shorter periods like “The last 6 hours” or “the Last 2 days”, and of course, you can rewind time as in previous versions. Another thing you’ll notice is that underneath the graph there are small circles. These indicate alerts that happened over your select period and they are colour-coded according to severity. If I hover over the circle I get a brief description and if I click it, I can see the details for that alert in this right-hand-side panel. I can also now directly clear the alert from here, or jump straight to that alert’s settings. This makes it easier to clear and tune alerts as they arrive. Having the alert information on the same page as the metrics gives you additional context so you have a better understanding of exactly what was going on with your server. You’ll see on the overview graph, there’s a highlighted window in white. This is the “Focus Window”. We can move it around or resize it using the handles. Everything below that graph now updates to look at just that narrowed time window that we have selected. For example, I might want to take a look at this spike in CPU usage from this morning. The 4 graphs below break out those metrics further, and let you see some finer detail which isn’t visible on the main graph above. All the other metrics you will see below are also tied to the period selected in the Focus Window. So first we have Top Queries and Top Waits ( I’ll come back to the top queries section in a moment) , but scrolling down or using the navigation on the left here, we can see various other metrics you’d expect from the previous version, including general metrics, processes, the error log and databases. We can click any of the databases here and see full details for that database appear. Jumping back up to the top to the top queries list, we can see another major new enhancement. If we choose to look at this most expensive query, we can see a new query plan button. We automatically pick out expensive operations which you can jump straight to by clicking here. We also automatically pick out certain warnings for you. Here for example, we show that there was an operation with no join predicate, which is the reason this query runs slowly, and can be used to understand how the query could be rewritten better. We’ll also warn about things like missing indexes, and give you the script to create those indexes. Version six of SQL Monitor now helps you get the answers to a whole range of SQL Server problems in a faster, easier and simpler way. Try it for yourself by clicking the download link in the description below and get a free 14 day trial. If you have any questions, feel free to email [email protected] Thanks for watching and remember to subscribe.
Views: 819 Redgate Videos
How to Find Top 5 CPU Consuming Processes
How to find top 5 CPU consuming processes with eyeShare- Ayehu video tutorial. We'll take a look at how to find top 5 CPU consuming processes using Ayehu eyeShare. Ayehu eyeShare is an IT Process Automation tool. Try it for free! Ayehu eyeShare IT Process Automation for 30-day free evaluation! For more Info please visit our website at http://www.ayehu.com
Views: 1124 Ayehu NG
SQL Server DBA Tutorial 143-How to Find out How Much Memory is Allocated to SQL Server Instance
In this video you will learn how to find how much memory is allocated to SQL Server instances using various methods. Methods include by viewing SQL Server memory configuration via SSMS, using SQL Server dynamics system view and how to configure SQL Server Minimum (min) and Maximum (Max) memory using SQL Server Memory Configuration. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-find-out-how-much-memory-is.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 8798 TechBrothersIT
Wappalyzer CPU usage when Firefox is idle
Love Wappalyzer for Firefox, it's one of the very best reasons I use Firefox. My issue is that when the extension is enabled the CPU usage of Firefox is constantly between 12% to 20% when Firefox is idle and now loading or doing anything at all. I made a screen recording to show the problem. Please note the CPU usage of Firefox when extension is enabled and Firefox is idle! Recorded on Macbook Pro, 2.3Ghz Core i5, OS X Lion 10.7.3, Firefox 10.0.2.
Views: 667 Kaloyan Petrov
Windows 7 - Adjust the Vitual Memory Pagefile Setting - Increase Performance
Do you want to make sure that you are getting maximum performance from Windows 7? Make sure that you Virtual Memory Pagefile is set up correctly. This is particularly important if you have increased or decreased the amount of physical RAM that you have on your motherboard. See my other videos for more help and tutorials. If you found this video tutorial useful, please Subscribe for updates and new info.
Views: 263784 Help Video Guru
What is Oracle Exadata Smart Scan (Demonstration)
How does Oracle Exadata Smart Scan work? What is Smart Scan. How to insure Oracle is offloading work to the Storage Tier? Learn this and more in this demonstration by OC Master John Watson of SkillBuilders. See all 11 lessons in this tutorial at http://skillbuilders.com/exadata-tutorials. John Watson: I want to show you very briefly how offload Smart Scan or flow processing can actually function. I'm working here just in the little demonstration Scott schema. I'll enable auto tracing so that we can see the effect on execution plans, which will also show me whether offload processing is indeed possible. So it's a simple query. I'll use a function here to check that to get offloaded as well as the column selection and the row selection and column projection. We'll have a predicate. Right. So there is the statement. It returned these three scalar values, as you would expect. How was this actually executed? There was a select statement, then it was executed, table access full. That's the only way to run that statement given the index on that table because in the middle of this, we see the key word, "storage." That key word tells me that this statement could indeed be offloaded to the storage tier. Furthermore, we see down here in the predicate information, "storage." That key word again tells me that the row filtering could have been done by the storage tier. So what happened is that the storage tier did not return every block of the empty* table to the database buffer cache, where my session would then have had to extract these values. All it returned to the instance was these three scalar values directly into the PGA of my server process. Now, there's also the initcap function there. Was that offloadable or not? There is a view "Read our SQL fm letter data," and that will tell us for each function whether or not it can be offloaded. So, just select its name, whether it's offloadable. Declare offloadable as yes and put in a sort order as well, and we see that in the current release, there are 393 functions that can be offloaded. Which ones? All the typecasting functions, truncations, trims. These are functions that get executed millions of times an hour in many, many environments. Note here two particularly important ones, balloon filters. The offload capability for balloon filters allows us to offload joins or facts to dimension tables. Those two in star schemas can be offloaded. The function I used was, in fact, initcap. Just for completeness, we'll scroll through all of these and we'll see that initcap itself is an offloadable function, and there it is along with many others. There are two classes of function that cannot be offloaded, and those are the aggregation functions and the analytic functions. I mention them just for completeness. There's an architectural issue there because aggregations and analytics potentially require access to all rows in the table. The row might be distributed across a cell. So it's a technical issue why they can't be offloaded, but virtually, all other functions can be offloaded with terrific drops in CPU usage, and combining that with the reduction of data traffic into the instances will give us vast performance improvements.
Views: 3941 SkillBuilders
Bart Sjerps | EMC World 2014
This week's EMC World 2014 Event, held at The Sands Convention Center in Las Vegas, is actually the site of where theCUBE broadcast its first event five years ago, and also the site of two live broadcasts brought to you by SiliconANGLE. Joining co-hosts Jeff Frick and Steve Kenniston was Bart Sjerps, Principal Engineer for EMC out of EMEA. Dirty Cache To start off the interview, Kenniston asked Sjerps about his blog Dirty Cache. He explained that the inspiration behind his blog's name came from a 90s song with the same title, and also because he likes to help his customers save money. You can read more on that story here, and even find a video link to the referenced song. Insights on Oracle . As Sjerps is an Oracle specialist, Kenniston went on to ask about his perspective. "What I see now in my customer base is that customers are actually virtualizing their databases," Sjerps responded. "They are conservative, and I don't blame them. So, what they do is start with test and development, and they slowly move a virtual platform." "Some of our customers are putting mission critical production database on VMweb, and they solve all the issues around support and certification, and what they have to do if Oracle finds an issue." Kenniston then went on to ask Sjerps what best practices he has learned along the way, or some of the right first steps as one is thinking of putting your Oracle database into the cloud. "The first thing you have to do is start conservative," said Sjerps. "Be very slow moving. Just test it out. Make sure the tools are in place. If you would go and migrate the whole thing at once, then you'll probably hit some issues down the road." The next thing that Sjerps goes into is licensing, emphasizing its importance. "Oracle is very keen on licensing. They have audits, policies and stuff like that," he warned. "Make sure that your licenses are in place, that you're compliant with your Oracle policy and all that. That's critical. If you're not in compliance, then you might have some severe issues later." Hybrid and Public Clouds . Frick went on to ask Sjerps about what he's seeing with hybrid clouds and public clouds. "Customers are very conservative," Sjerps answered. "So, they will probably deploy on a private cloud -- maybe hybrid if the hybrid partner is an outsourcer that they trust." Frick then brought the conversation back to licensing and asked if customers are finding it to be a relatively neutral transition cost-wise when they move from the regular licenses to the virtualized. "Many databases that are physically deployed have a very low CPU utilization," said Sjerps. "Now, Oracle, I would say 90 percent of the cases are licensed by CPU core and it's pretty expensive. Probably, as you know, 70 -- 80 percent of a database tech -- the cost of it -- is made by licensing and support of those licenses. So, if my database tech is expensive and 80 percent of that cost is in Oracle licensing and that 80 percent is only utilized for 20 percent, you see how many dollars I am basically wasting." Sjerps then explained that customers have to do this because they have to size for big loads or for future growth. Oversizing one's server means average utilization is low. "One of the things you can do with virtualization is basically glue all those CPU resources together and now you have kind of like a cloud, if you will," Sjerps explained. "That cloud allows you to move workloads and set CPU shares and all of that stuff so now every database can use all of the CPUs in the farm. And, by doing that, and using some specific workload management techniques, you can drive utilization." After discussing Sjerps' history with the EMC conference and finding out what he hopes to learn at the event this year, the interview concluded with him going into further detail about Dirty Cache. The number one topic that his customers ask for is performance on databases. Sjerps also uses real-world examples in his blog posts and does tests to show what's going on. See the blog here for more details.
Oracle ZFS Storage Appliances - Demonstration: ZFS Storage Appliance Details (Part 6 of 6)
Learn about the options and capabilities of ZFS storage appliance management. Part 6 of 6 in this series from SkillBuilders.com/ZFS. Mick: Now we're going to look at the Storage Appliance in some detail. The first thing we're going to do is just have a quick look through the different menus that you see here at the top. You can see that within the different menus - can you see here you have services, storage, network, etc. on the configuration? These are maintenance menu which allows you to do things with the system. For example, do a reset which is what I have to do every time I want to start from scratch for example. I can create shares. I can look at the system status and my status screen showing various analytics or I can generate specific analytics. Just let's get started by showing you how I can add statistic, say a percent utilization of the CPU and instantly I'll get a nice graph coming up. I can add another statistic like network interface statistics. I can go on like this creating whatever statistics I like. Using these little buttons here, these icons, I can show a minute of data, show an hour. Obviously, the appliance would need to be running for some time before I could actually show these in full detail - show a full day, etc. I can represent data by different types of graph. You can see pretty detailed information is available. Let's go back. What I'll do is start by going into configuration and I'll create a user account. The analogy would be just like creating a user on a Microsoft system or Unix box. I'll click on plus (+), I'll create a user. ZFSuser1, local only, not on the network directory. Clear the password. The things here require sessionalization. It would mean if they user logged in, they have to type a reason as to why they're logging in, if they have some sort of admin function on the Storage Appliance. I only want to use the user for authenticating when I access the share. If I click kiosk user, that would then restrict what they could see when they use the browser interface to look at the Storage Appliance. I'm going to add the user then I'm going to go into shares. Rather than create a single share, which I could do, I'm going to go into projects so I can categorize my share under project which will make it easier for me to manage a bit later. I'm going to add a project called SkillBuilders. Now I'm going to go back into shares and bring up my projects, select SkillBuilders. Now when I create a file system that will be associated with that project (as you can see) and I'm going to create a share called reports owned by the user I've just created, zfsuser1. Here I can set my permissions, which you can see are Unix permission groups, and I can click on individual permissions. I'm just going to leave read-write execute for owner at the moment. From there I've created a share. Now you might say, "How would you see this?" Just like any other share. If I go into a remote session, I'm going to log into a local system, logging in as zfsuser1. I've got the equivalent user account setup on my Solaris 10 system. If I do showmount-c, I can see the report share is exported. Note the default mount point export report which I can change if I want to but everything is shared from /export. In order to mount this manually I would need to become root on my Solaris box and then mount mnt directory and /mnt. As you may be aware, if you're used to Solaris, it is always a mnt directory that's handy for mounting stuff. Usually it is.
Views: 2917 SkillBuilders
How to Check details of processor / CPU in linux based operating systems ?
How to Check details of processor / CPU in linux based operating systems ?, How to Check details of processor in Linux ?
Views: 2859 Being Skilled
100% CPU usage in Windows 7 ?? Watch this !
In this video I show a couple of tricks to lower your CPU idle usage. There are a few processes that usually steal a lot of your CPU-time, like svchost.exe and wmpnetwk.exe. More details in the video! The system I'm using is Windows 7 Ultimate 64-bit
Views: 437394 Zdem0Z
Basic Stress Identifier Usage
The OraPub Stress Identifier is an automated software product which allows Oracle DBAs to determine what specific Oracle internal database activity is stressing their database server. Unexpected performance events are disastrous because they catch you by surprise. If you knew what to watch out for, obviously you would have monitored the situation. By knowing exactly what Oracle internal activity stresses your database servers' CPU, IO, and network subsystems you can be sure that anytime an application, Oracle, or a user change occurs you'll be able to know if it will impact your system. That's powerful because performance threats are effectively dealt with before they are allowed to become disastrous. That's why the Stress Identifier product is more---a threat identifier.
Views: 512 OraPub, Inc.
NEXT MAP FOR SEA AND GLOBAL. EPISODE 4 YUNO/JUNO Einbroch Field Lava Caves credit Roguard also for the screenshot of mob details Hello, you can support the channel here: Thank you so much! Paypal: https://www.paypal.me/vergel520 Patreon: https://www.patreon.com/vergel520 CoinsPH QR code: https://imgur.com/lTT8lfj I am Vergel520 the guide maker. I enjoy making guides as I enjoy watching people learn more. 2nd track: Track: Lost Sky - Dreams [NCS Release] Music provided by NoCopyrightSounds. Watch: https://youtu.be/SHFTHDncw0g Free Download / Stream: http://ncs.io/DreamsYO 1st track: Music: TheFatRat - "Fly Away feat. Anjulie" https://www.youtube.com/watch?v=cMg8KaMdDYo
Views: 26975 Vergel520
How To Kill All Database Processes On SQL Server
SQl management studio provides lot of facilities to manage SQL processes. The “Activity monitor screen” which will show you some very useful and important information about SQL processes. It will show you all active processes, there status, number of open transactions for each process, the application by which the process is generated, Wait time CPU and memory utilisation, and the host name, means the host or the machine by which the process is initiated etc. If a process is hanging, it will show the process icon with an hour glass. Refresh it several times, sometimes the icon will turn to sleep mode if the process completes its execution. If the icon remains an hour glass, the process may be hanging. Use other info as well to decide if the process is really hanging. If you double click on the process ID it will show the SQL stamen subjected to the execution of the process. If a process is hanging you can identify which application has originated the process, which SQL stamen is hanging and even more from which machine or the host the process is initiated If some application users are complaining about uneven slowness, uneven timeouts etcetera, the reason behind may be one or more processors are hanging. What can you do now? You can restart the SQL server or the service which will disconnect all databases and all applications disturbing all the users. Or otherwise you can take the database to off line and bring it back to online. Or you can disconnect all connections to the database. The disturbance may be lesser than the previous case but still lot of applications and users can be disturbed, especially in an industrial setup. And still you do not know the real reason for the slowness or the malfunctioning as well. So what can you do? Go and examine the processors. Identify exactly which process is hanging. And most probably you will be identifying how and why. So you can find permanent solution. But the immediate solution is you can kill the troubling process or the few. It will solve the issue with minimum disturbance immediately. After identifying the correct process, you can right click on the process ID and click on ‘Kill process’ button. It will kill the selected process. You can kill processors using SQL statements and, using SQL commands you can kill all processors at once as well. Code for Killing Processes Individually USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' EXECUTE ('KILL 53') Code for killing all Processes USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE ('KILL ' + @spid) SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid @spid END
Views: 6974 Rohan Mehtha
Fedora 26 Workstation Installation + Guest Additions on Oracle VirtualBox [2017]
This video tutorial shows Fedora 26 Workstation installation on Oracle VirtualBox step by step. This tutorial is also helpful to install Fedora 26 on physical computer or laptop hardware. We also install Guest Additions on Fedora Linux for better performance and usability features: Automatic Resizing Guest Display, Shared Folder, Seamless Mode and Shared Clipboard, Improved Performance and Drag and Drop. Steps: 1- Create Virtual Machine on Oracle VirtualBox 2- Start Fedora 26 Workstation Installation 3- Install VirtualBox Guest Additions 4- Test Guest Additions Features: Automatic Resizing Guest Display and Shared Clipboard Fedora 26 Workstation New Features and Improvements - Fedora Workstation uses GNOME as the default desktop environment but provides other spins based on KDE, Xfce, Cinnamon, MATE etc. - Default desktop environment GNOME 3.24.2 brings nightlight feature to Fedora. Weather information is in the notification area. - Linux Kernel 4.11.8 - GCC 7 (though not all packages have been compiled with GCC 7) - Other major package updates: DNF 2.5, Python 3.6, Golang 1.8, Ruby 2.4, Boost 1.63, OpenSSL 1.1.0 - New Fedora spin based on Lxqt - Python Classroom: A special Fedora spin for teachers and instructors to use Fedora in their classrooms or workshops for teaching Python - Chinese input improvement - Improved systemd integration - SSSD fast caching is now enabled by default - Many under-the-hood improvements, like better caching of user and group info and better handling of debug information Fedora 26 Workstation Recommended System Requirements - 6GB plus the required disk space recommended by the guest operating system per guest. For most operating systems more than 6GB of disk space is recommended. - One processor core or hyper-thread for each virtualized CPU and one for the hypervisor. - 2GB of RAM plus additional RAM for virtualized guests. Hope you found it informative and useful. Any questions or comments are welcomed. PLEASE SUBSCRIBE TO THE CHANNEL ---------------------------------------------------------------------------- Website: http://www.SysAdminsHowto.com/ Facebook Page: https://www.facebook.com/SysAdminsHowto/ Twitter: https://twitter.com/SysAdmHowto Linux Video Tutorials: https://linux-video-tutorials.blogspot.com/ Fedora 26 Installation on VirtualBox Video: https://youtu.be/W6mhJXVVbrs
Views: 9833 Linux Video Tutorials
SQL Server Data Compression
Have you heard of the data compression feature in Enterprise Editions of SQL Server 2008 and later? It promises great savings on storage space. But did you know it can also improve I/O performance and enhance SQL Server memory? It also has costs too, in particular, it costs additional CPU to compress data on the fly. But how much CPU is spent on data compression overhead? Is it too much to be worth your time? Or is it an acceptable cost for the big gains in storage space, I/O performance, and memory improvements? To find out all about this cool technology, join Kevin Kline (@kekline) and Melissa Connors (@melikanokaoi) for this case study webinar. They’ll show how data compression works, how to choose the tables and indexes to compress, and the positive and negative performance impact of implementing data compression. Attend this webinar to learn the important ways that data compression affects workloads.
Views: 2344 SentryOne
Linux Commands for Real Life with Examples
Practical Linux Commands for Real Life With Example This article is part of the Linux Commands for Real Life series, Part - 1 https://goo.gl/6oPfMG Part - 2 https://goo.gl/WxxGLl Written Tutorial Part 1: https://goo.gl/XcayZn Written Tutorial Part 2: https://goo.gl/fbchIw Using cut command with cat Sometimes when i am writing a script and i want to find out the name of the server, network type...etc i use the below command. I use cat to screen all the file content, i use grep after to find specific line then i cut only specific part. Command: cat /etc/sysconfig/network-scripts/ifcfg-eth0 | grep -i TYPE | cut -d "=" -f 2 Output: "Ethernet" Explanation: grep -i type - Find line which has type cut -d "=" -f 2 - use "=" as a delimeter and -f 2 means show  the second column. Another example: if you have a file which contains type=3=4=5=6 Then you use cat that file and -d "=" and -f 3 then the output will be '4' as 4 is the third column. Change text color using tput You can change text output color/bold/italic/backgroun color using tput. Example: echo "$(tput smul)$(tput setaf 1)Text$(tput sgr0)": Output: Explanation $(tput smul) - Underline $(tput setaf 1) - Text color is red $(tput sgr0) - this part you should put it at the end to get the text back to normal, if you don't put it all the tyle will be applied to all the next written text. Sort processes by CPU usage Command ps -e --sort -pcpu -o comm,pcpu,user,pid | head -11 Output COMMAND %CPU USER PID systemd 50.0 root 1 kthreadd 44.0 root 2 ksoftirqd/0 38.0 root 3 kworker/u30:10 0.0 root 6 migration/0 8.0 root 7 rcu_bh 0.0 root 8 rcu_sched 0.0 root 9 watchdog/0 0.0 root 10 khelper 0.0 root 12 kdevtmpfs 0.0 root 13 Explanation --sort -pcpu , Sort by CPU Usage -o comm,pcpu,user,pid , show output columns of cpu, user,process id. | head 11 , show top 11 Rename multiple files with specific name with number sequence Below example will rename multiple files which starting with x to data01.csv , data02.csv ...etc ls x[a-z]* | while read file;do let c++;mv $file data$(printf "%02d" $c)".csv";done Explanation: ls x[a-z]* - List all the files which start with 'x' letter while read file;do let c++ - Loop while listing all the files and do the following mv $file data$(printf "%02d" $c)".csv";done - Move all the files with naming them 'data' and have 0 then number of the loop of $c and place extension .csv Check each installed packaged information and sort by date Not all the installed packages' information can be retreived using yum, if packages where installed using rpm you can query and find installation date using below command: Example: rpm -qa --qf  '%{INSTALLTIME} (%{INSTALLTIME:date}): %{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}\n' | sort -n | tail -n5 Output sample: 1496198202(Tue 30 May 2017 10:36:42 PM EDT):mysql-community-common-5.7.18-1.el7 1496198203(Tue 30 May 2017 10:36:43 PM EDT):mysql-community-libs-5.7.18-1.el7 1496198207(Tue 30 May 2017 10:36:47 PM EDT):mysql-community-client-5.7.18-1.el7 1496198234(Tue 30 May 2017 10:37:14 PM EDT):mysql-community-server-5.7.18-1.el7 1496198235(Tue 30 May 2017 10:37:15 PM EDT):mysql-community-libs-compat-5.7.18-1.el7 Explanation: rpm -qa --qf '%{INSTALLTIME}(%{INSTALLTIME:date}):%{NAME}-%{version}-%{RELEASE}\n' | sort -n | tail -n 5 rpm -qa - List and query all installed packages. --qf '%{INSTALLTIME}' - This will show file information of Install Time and all the rest of parameters have different info like date, name, version..etc \n' - To have each package in a new line sort -n - Sort the list tail -n5 - List only the latest 5 installed packages Find Apache uptime or when was restarted Method #1 apachectl status | grep -i active Method #2 locate error_log cat /var/log/httpd/error_log | grep -i resum List files by last accessed ones ls -latu This command will differ than ls -lat that it will show last accessed even if it was not modified. Which processes using certain file Example: fuser /var/log/httpd/error_log Output example: /var/log/httpd/error_log: 27431 27432 27433 27434 27435 27436 Investigate certain pid ps aux | grep -i 27431 Output will show that httpd is running, now we can know that httpd is using that file.
Views: 1047 dotsway
AS400 Tutorial - WRKSYSSTS
http://www.midrangejumpstart.com - Checking out the resources, CPU, disk space and memory usage on the AS/400, iSeries and IBM i.
Views: 27574 AS400Tutorials
5 Linux Commands: To See Amount Of Free and Used Memory
Explains how to find out the total amount of free and used physical and swap memory in the system, as well as the buffers used by the Linux kernel. See our tutorial page for more detailed information http://www.cyberciti.biz/faq/?p=171 *** Software used *** GNU/Linux (http://kernel.org/) is a free and open source kernel used by Linux operating systems. It is licensed under GNU General Public License version 2 http://www.gnu.org/licenses/gpl.html Debian Linux (http://debian.org/) is free and open source operating system by Software in the Public Interest, Inc. It is licensed under GNU General Public License version 2 http://www.debian.org/license *** Music / song track used *** Parting of the Ways - Part 2 (http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100335) by Kevin MacLeod is licensed under a CC Attribution 3.0 http://creativecommons.org/licenses/by/3.0/deed.en_US
Views: 19286 nixcraftcom