Oracle - > auto send AWR Report
September 21, 2016
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.
Script to collect AWR report: $o ...
Posted by DoomyCheese on Tue, 31 Mar 2020 21:18:39 -0700
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
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
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
Because of the data problem in the database, it is not as good to take blank pages as the prototype image on the board:
<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
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
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
– create a "shop" Database
CREATE DATABASE shop CHARSET=utf8;
– use "Jingdong" Database
– 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
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
If the version number is the same, the backup migration will fail
Step 1.gitlab backup gita-A
Posted by vichiq on Tue, 31 Mar 2020 10:54:28 -0700
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
Scan code import
Course library ma ...
Posted by solus on Tue, 31 Mar 2020 08:20:54 -0700