First, Prepare knowledge: Oracle's logical storage management.
Oracle is divided into 4 granularity on logical storage: tablespaces, segments, extents, and blocks.
(1) Block: Is the smallest granularity of storage units, now the standard block size is 8k,oracle every I/O operation is also done by block, that is, when Oracle reads data from the data file, is read how many blocks, not how many rows. Each block can contain multiple row.
(2) Area: comp
standard mode, with the 1th, because the log is often an important basis for restoring the database in some unusual cases.
Method Two
Copy Code code as follows:
SET NOCOUNT on
DECLARE @LogicalFileName sysname,
@MaxMinutes INT,
@NewSize INT
Use TableName-the name of the database to manipulate
SELECT @LogicalFileName = ' Tablename_log ',--log file name
@MaxMinutes =--Limit on time allowed to wrap log.
@NewSize = 1-the size of the log file you want to set (M)
--Setup/initiali
can only be modified in INI, and here are the default values, unless otherwise stated
; Select Low Level shm/allocator scheme implemenation
Xcache.shm_scheme = "Mmap"
; Disabling: xcache.size=0
; Enable: xcache.size=64m (any >0 value) Please also note that your system mmap upper limit
Xcache.size = 0
; Recommended set to CPU number (Cat/proc/cpuinfo |GREP-C processor)
Xcache.count = 1
; is only a reference value, you can safely store more than this number of items (PHP script/variable)
Connection Timeout _ handshake waiting Response Timeout
Proxy_read_timeout 180;
After successful connection _ wait for back-end server response time _ actually entered the back-end of the queue waiting for processing (also can be said to be the backend server processing request time)
Proxy_send_timeout 180;
Back-end server data return time _ is within the specified time the back-end server must pass through all the data
Proxy_buffer_size 256k;
Sets the buf
, investigating errors
Sqlcode: Product specific error code;
SQLSTATE:DB2 series of common error codes, in line with the Iso/ansi 92SQL standard.
Investigating SQLCODE:DB2? sql1403n
Investigating SQLSTATE:DB2? 08004
22, create a table space
REM Create buffer pool space 8K
DB2 Connect to gather
DB2 CREATE Bufferpool stmabmp IMMEDIATE SIZE 25000 PAGESIZE 8K
REM Create tablespace: STMA
REM must confirm that
other configurations:Client_header_buffer_size syntax: Client_header_buffer_size size Default value: 1k Using fields: HTTP, server This directive specifies the HTTP header buffer size requested by the client in most cases the size of a header request will not be greater than 1k but if there is a larger cookie from the WAP client it may be greater than 1k,nginx will assign it a larger buffer, this value can be in the Large_ Client_header_buffers inside set. Large_client_header_buffers Syntax: la
reset your database properties to standard mode, with the 1th, because the log is often the important basis for restoring the database in some unusual situations. Grassland Chin ai tp owerftgjy
Methods two grassland chin ai tp owerftgjy
SET NOCOUNT onDECLARE @LogicalFileName sysname,@MaxMinutes INT,@NewSize INT grassland chin ai tp owerftgjyUse TableName-the name of the database to manipulateSELECT @LogicalFileName = ' Tablename_log ',--log file name@MaxMinutes =--Limit on tim
, because the log is often an important basis for restoring the database in some unusual cases.Method TwoSET NOCOUNT onDECLARE @LogicalFileName sysname,@MaxMinutes INT,@NewSize INTUse TableName-the name of the database to manipulateSELECT @LogicalFileName = ' Tablename_log ',--log file name@MaxMinutes =--Limit on time allowed to wrap log.@NewSize = 1-the size of the log file you want to set (M)--Setup/initializeDECLARE @OriginalSize intSELECT @OriginalSize = sizeFrom SysfilesWHERE name = @Logica
.
Method Two
SET NOCOUNT on
DECLARE @LogicalFileName sysname,
@MaxMinutes INT,
@NewSize INT
Use TableName-the name of the database to manipulate
SELECT @LogicalFileName = ' Tablename_log ',--log file name
@MaxMinutes =--Limit on time allowed to wrap log.
@NewSize = 1-the size of the log file you want to set (M)
--Setup/initialize
DECLARE @OriginalSize int
SELECT @OriginalSize = size
From Sysfiles
WHERE name = @LogicalFileName
SELECT ' Original Size of ' + db_name () + ' LOG is ' +
CONVERT (
=10k. Since Vout has a maximum current output of 10mA, it is set to 20mA or 30mA in order to retain enough headroom. We now set the power of 20MA,R1 to PR1=20MA*4V=0.08W 4, Calculate load resistance (value of R3) when vin=0v, the transistor cutoff, 9014 of the Collector No current flow, the value of Vout is R1, R2 these two resistors. We can calculate the resistance value of R3 according to the voltage divider: r3= (r1*vout)/(Vcc-vout) = (10k*4v)/(9v-4v) =
Problem: The actual size of the database is 600MB, the actual size of the log file is 33MB, but the log files occupy space for 2.8gb! tried a variety of ways, shirnk DATABASE, TRUNCATE log file, there is no way to reduce the files. Anyway, this should be a bug in SQL Server.
Workaround:
Then find the following code, you can reduce the log file to the size you want. Copy the code to the Query Analyzer, and then modify the 3 parameters (database name, log file name, and target log file size) and
Js|servlet
Because response is an implied object in JSP pages, you can use Response.sendredirect () directly in JSP pages to achieve relocation.Attention:(1). You cannot have HTML output before using Response.sendredirect.
This is not absolute, and the inability to have HTML output actually means that HTML cannot be sent to the browser. In fact, the server now has the cache mechanism, generally in 8K (I mean JSP SERVER), which means that unless you cl
Server
method One:
Change the database log file to simple log mode
Method Two:DUMP TRANSACTION your database name with NO_LOG
BACKUP LOG your database name with NO_LOG
DBCC shrinkdatabase (your database name)
EXEC sp_dboption ' Your database name ', ' autoshrink ', ' TRUE '
Method Three:
Copy the code into the Query Analyzer, and then modify the 3 parameters (database name, log file name, and target log file size) and run it (I've used it many times)-----
SET NOCOUNT on
DECLARE @LogicalFileName
());
System.out.println ("Copy over ...");
Close Flow
ins.close ();
Outs.close ();
}
First of all, I used a program of more than 860 m to test, found that the speed of copying and pasting in Windows is roughly 40M per second, copying one such file takes approximately more than 20 seconds, while using the above method to replicate, after repeated testing, Found that the time is basically about 23 seconds in appearance, and when the value of more than 16K
Main function Accept: Using the MCU STM8S105C6 PWM Channel 2 PC2 to do the breathing light has been verified OK, ah//Ah, this PWM setup just started with a little trouble, because it is their own groping, take some time, or conquer.
The child functions used are all called stm8s in the library function stm8s_tim.c.
Macro definition://Divider macro//Counter clock frequency (fck_cnt) equals fck_psc/(pscr[15:0]+1).
#define TIM1_PRESCALER_1 ((U16) 0x00) #define TIM1_PRESCALER_2 ((U16) 0x01) #define
Tags: query isa mat own system sed fail interface share picture1.Background Winsock Kernel buffer
To optimize performance on the application layer, Winsock copies data buffers from application send calls to a Winsock Kernel buffer. Then, the stack uses it own heuristics (such as Nagle algorithm) to determine when to actually put the packet in the wire .You can change the amount of Winsock kernel buffer allocated to the socket using the SO_SNDBUF option (it's
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.