oracle| problem Oracle Common fool question 1000 Q (13)
Author: ccbzzp
Oracle9i's Data dictionary.
901. Chained_rows
Stores the output of the Analyze command with the list CHAINED rows clause.
902. chainge_sources
Allows publishers to view existing change resources.
903. Change_sets
Allows publishers to view existing change settings.
904. Change_tables
Allows publishers to view existing change tables.
905. code_pieces
Oracle Access this vie
/
In order to use the relatively accurate timing function in JS, we can
var starttime = new Date (). GetTime ();
var count = 0;
SetInterval (function () {
var i = 0;
while (i++
In the code, the time of the next trigger is calculated by subtracting the current time and the exact time gap by 1000 (i.e. cycle time), thus correcting the current trigger delay.
Here is the output
186
230
271
158
899
900
899
900 899 899
899
418
232
266
145
174 902
Servlet engine:apache tomcat/8.5.4 2017-08-30 16:05:11.441 INFO 5180---[ost-star TSTOP-1] O.a.c.c.c.[tomcat]. [localhost]. [/AAA]: Initializing Spring embedded Webapplicationcontext 2017-08-30 16:05:11.441 INFO 5180---[ost-startstop-1] o. S.web.context.contextloader:root Webapplicationcontext:initialization completed in 902 Ms 2017-08-30 16:05:1 1.554 INFO 5180---[ost-startstop-1] o.s.b.w.servlet.servletregistrationbean:mapping servlet: ' Dispatchers
cannot export data using INSERT INTO:
hive> insert into local directory '/HOME/WYP/WYP '
> select * from WYP;
Noviablealtexception (79@[])
At Org.apache.hadoop.hive.ql.parse.HiveParser_SelectClauseParser.selectClause (hiveparser_ selectclauseparser.java:683)
At Org.apache.hadoop.hive.ql.parse.HiveParser.selectClause (hiveparser.java:30667)
At Org.apache.hadoop.hive.ql.parse.HiveParser.regular_body (hiveparser.java:28421)
At Org.apache.hadoop.hive.ql.parse.HiveParser.queryStatement (hive
transactions
InnoDB Locked TablesThe number of tables locked by all transactions
InnoDB transactionsactive/lockedThe figure shows the number of states of the InnoDB transaction .
Active transactionsNumber of transactions being executed
Locked transactionsNumber of locked transactions
Current transactionsCurrent number of transactions (including not started,active,... various states)Not started # Transaction has been committed to diskACTIVE # transactions that are exec
then modify the port to enable it.VMS have two ports, one is the default of 443And there's a 902 port.Intranet penetration Tool Be sure to open these two ports.Otherwise you can connect to the host without opening the virtual machineConnect work startedServer name: IP address: Port? (Default 443 without modification, if modified to add port)The intranet penetration tool may be a domain name, or it may be an IP addressUser name: The user name of the h
.clear screenClear Screen2), File Operation command1.start and @Description: Run SQL scriptCase: sql>@ d:\a.sql or Sql>start d:\a.sql2.editDescription: The command can edit the specified SQL scriptCase: Sql>edit D:\a.sql, this will open the D:\a.sql file.3.spoolNote: This command can output the contents of the Sql*plus screen to the specified file.Case: Sql>spool d:\b.sql and input sql>spool offegSql>spool D:\b.sql;Sql>select * from EMP;Sql>spool off;3), interactive commands1.Note: You can overr
the current user name5.exitDescription: The command disconnects from the database and exits the Sql*plus5.clear ScreenClear Screen 2), file Operation command1.start and @Description: Run SQL scriptcase: sql>@ d:\a.sql or Sql>start d:\a.sql2.editDescription: The command can edit the specified SQL scriptcase: Sql>edit d:\a.sql, this will open the D:\a.sql file.3.spoolNote: This command can output the contents of the Sql*plus screen to the specified file. case: Sql>spool d:\b.sql and input sql>sp
901. CHAINED_ROWSStores the output of the ANALYZE command with the list chained rows clause.
902. CHAINGE_SOURCESAllows the publisher to view existing changed resources.
903. CHANGE_SETSAllows the publisher to view existing change settings.
904. CHANGE_TABLESAllows publishers to view existing change tables.
905. CODE_PIECESORACLE accesses this view to create a view on the object size.
906. CODE_SIZEORACLE accesses this view to create a view on the obj
from v $ sga_dynamic_free_memory;
The result is 208 M.
SGA_TARGET = 1200-208 = 902 M.
Cancel pai_pool_size DB_CACHE_SIZE LARGE_POOL_SIZE from the parameter file
In the automatic memory management mode, if spfile is applied to the database, after the database is closed, the system records the status of the Last Database shutdown, the value of each component of the adjusted memory parameter will be saved in the parameter file. Therefore, if you use a
Test environment:One router (R2) has three interfaces, one connected to the internal network, two connected to ISP1 (R1) and ISP2 (R3), and the two ISP outlets are connected to the same switch, then, a router (route) is connected outside the vswitch. Two ISPs (R1, R3, and router) use the ospf dynamic route, and then the policy route is made on R2, route is determined based on the next hop address. --- R3 ---Route --- ---- R2 ---- internal network--- R1 --- R3 # sh ru
How JavaScript obtains the file's suffix format:When uploading files, most need to verify the file format, then first get the file format suffix name, that is, the file format type, the following examples of how JavaScript implementation of this feature. The code is as follows://by Morewindows (http://www.51texiao.cn/)functionGetextensionfilename (pathfilename) {varReg =/(\\+)/G; varPFN = Pathfilename.replace (Reg, "#"); varARRPFN = Pfn.split ("#"); varfn = Arrpfn[arrpfn.length-1]; varARRFN = Fn
In Oracle, you can use the decode function to convert rows to columns. For example, if you have A student table named A: IDNAMESUBJECTSCORE1 Zhang San Language 902 Zhang San mathematics 803 Li Si.
In Oracle, you can use the decode function to convert rows to columns. For example, if you have A student table named A: id name subject score, 1 picture, 3 Chinese, 90 picture, 2 picture, 3 math, 80 picture, and 4 picture.
You can use the decode functio
) visited once
Time perrequest:5.411 [MS] (mean, acrossall concurrent requests) #一个人访问一次花费的时间
Transfer rate:37.18 [Kbytes/sec] Received
In addition, if we increase the number of concurrent numbers to 500, that is, the command is adjusted to Ab.exe-n 10000-c http://localhost/test/index.php it will appear the following results.[Plain]View Plain Copy
Apr_socket_connect (): Unable to connect because the target computer was actively refused. (730061)
Total of
+ @ updatetype, @ changetime, studentid, courseid, grade from inserted
/* The End Of The trigger definition */
Now, the entire trigger has been created. We can test this trigger.
Run the following statement:Delete from gradesDelete from auditInsert into grades values (19224,002, 90)Update grades set grade = 100 Where studentid = 19224Delete from grades where Fig = 19224Select * from audit order by changetime ASCThe following result is displayed:
We can see that the audit table monitors o
export a default character set.Utf8 version 4.0 data
Mysqldump-u ajin-P test_db -- compatible = mysql40-- Default-character-set = utf8 test_db> C: \ test. SQL
The so-called downgrade can be completed.-- Compatible = the following parameters can be obtained: mysql323 mysql40 Oracle MSSQL DB2And so on.
Export introduces these common ones, but there are many more .. Omit one thousand words .....
Data Import
This is relatively simple. It is used in command line and cmd.If your msyql/bin di
Description:
Use a one-dimensional array to store student IDs and scores, and then sort and output results by score.
Input:
The first line contains an integer N (1 Each row in the next n rows contains two integers, p and q, representing the student's student ID and score respectively.
Output:
Sort the scores of students from small to large, and print the sorted student information.If the scores of students are the same, the student IDs are sorted in ascending or
build hadoop on Windows 7. At this time, we need vmwarevm, ubuntu iso image file, Java SDK support, Eclipse IDE platform, and hadoop installation package;
1, vmwarevirtual machine, here is the use of VMware Workstation 9.0.2 for windows, the specific is the https://my.vmware.com/cn/web/vmware/details? Downloadgroup = WKST-902-WIN productid = 293 rpid = 3526, as shown in:
Save the downloaded file locally, as shown in:
It can be seen that there is a
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.