(Oracle) custom call AWR

Oracle - > auto send AWR Report September 21, 2016 09:31 Requirement Description: Daily or regular manual use of AWR reports to check the status of Oracle database is not only time-consuming but also labor-intensive, requiring the use of scripts to automatically collect AWR reports.    Analysis scheme: Script to collect AWR report: $o ...

Posted by DoomyCheese on Tue, 31 Mar 2020 21:18:39 -0700

zstack version upgrade

Summary Today, I saw the installation image of zstack on the official website, and found that it was released on March 24, 2018. Because the local environment is a test environment, and I haven't tried to upgrade zstack, I plan to upgrade zstack Things to know before upgrading First of all, zstack supports two upgrade methods on the official w ...

Posted by onlyican on Tue, 31 Mar 2020 18:00:03 -0700

(4) Global exception capture for Springboot

Original address: http://te-amo.site/user/article/info/ARTICLE20180223085118171 Written in the front Exceptions are inevitable in project development, so it is important for an application to capture and handle exceptions uniformly in the project. It is easy for developers to find the cause of errors, and users ...

Posted by davey10101 on Tue, 31 Mar 2020 17:57:03 -0700

Commonly used select statements to view mysql system parameters

The buffer pool size 393215 this is a page, not a byte. To see the buffer pool size in GB, run the following command: SELECT FORMAT(BufferPoolPages*PageSize/POWER(1024,3),2) BufferPoolDataGB FROM (SELECT variable_value BufferPoolPages FROM information_schema.global_status WHERE variable_name = 'Innodb_buffer_pool_pages_tota ...

Posted by freakstyle on Tue, 31 Mar 2020 17:39:59 -0700

Detailed examination papers

Because of the data problem in the database, it is not as good to take blank pages as the prototype image on the board: Body Code: <div *ngFor="let q of qt.questionMainList; let i=index" [ngSwitch]="qt.questionTypeId"> <div *ngFor="let qtl of questionTypeList; let k=index"> <div *ngIf="qt.quest ...

Posted by tommyrulez on Tue, 31 Mar 2020 14:54:18 -0700

Android adds pictures and alarm clocks to the database and displays them with listview 2

Android adds pictures and alarm clocks to the database and displays them with listview 2 Novice on the road, please give me more advice Continue last time, the teacher proposed to add two more alarm clocks. Although it was not satisfactory, it also made Because it's not so hard for a novice to simplify his intelligen ...

Posted by BAM1979 on Tue, 31 Mar 2020 14:33:17 -0700

Mysql Event scheduling history

Mysql Event scheduling history The current mysql version does not have Event execution history information. In order to check whether the Event is executed normally and the execution result conveniently, the following two steps can be used:   1, Create job execution Event history table CREATE TABLE `mysql`.`t_event ...

Posted by Danicek on Tue, 31 Mar 2020 11:51:26 -0700

SQL basic bullet 2

Prepare data: – create a "shop" Database CREATE DATABASE shop CHARSET=utf8; – use "Jingdong" Database use shop; – create a goods data table Insert data (if you don't understand the meaning of each field name, read the insert data below, you will understand it, but you still ...

Posted by v00d00 on Tue, 31 Mar 2020 11:28:01 -0700

GitLab backup and recovery

Because the company changed the server service provider and the server was migrated to another service provider, today we will simulate the operation of online migration of gitlab git-A IP:192.168.82.184 git-B IP:192.168.82.184 If the version number is the same, the backup migration will fail   Step 1.gitlab backup gita-A #c ...

Posted by vichiq on Tue, 31 Mar 2020 10:54:28 -0700

HPU timetable software of Henan University of Technology

HpuTimetableAPI Background open interface of [HPU timetable] software It includes the whole course library of the second semester 2017-2018 of Henan University of technology 23 colleges, 901 classes, 5647 courses, 20241 course records Rubbing class function Sharing courses Scan code import course management Course library ma ...

Posted by solus on Tue, 31 Mar 2020 08:20:54 -0700