clicked. By default, you can play or pause a video when you click the show area.Linktarget * (FRAME): sets the Link Target. "_ Self" is displayed on the current page. "_ Blank" is displayed on the new page.Streamscript (URL): set this parameter to be compatible with the 'pseudo stream' FLV file.Type (MP3, FLV, rtmp, JPG, PNG, GIF, SwF, RBS, 3GP, MP4, and m4v): The Player determines the type based on the last three characters in the file name. This me
Today, I did a database experiment about creating new users and granting them permissions. Below are some of my summary:
In the lab, since oracle is installed on each machine, we all enter the system as a DBA. First, we must know some basic commands, such:
Select * from cat
Cat is a self-contained view in the Oracle database system. There are two fields: table_name and table_type. The table names you created are basically stored here, you can use this command to View tables in the system.
to divide users and applications. For example, the USER tablespace is used by general users, and the RBS tablespace is used by rollback segments. A tablespace can belong to only one database.
Create tablespace Syntax:
Create TableSpace name
DataFile tablespace data file path
Size tablespace initial Size
Autoextendon
For example:
Create tablespace db_test
Datafile 'd: \ oracle \ product \ 10.2.0 \ userdata \ db_test.dbf'
Size 50 m
Autoextend on;
View
During Oracle database management, tables are often locked due to unreasonable operations on data tables. The following describes how to find which tables are locked by which users, and how to unlock:
1. Find the locked table:
Select object_name, session_id, OS _user_name, oracle_username, process, locked_mode, status
From v $ locked_object l, all_objects
Where l. object_id = a. object_id;
If you want to know which process is blocked, you can view the following statement:
Select username, v $ l
LTE user documentation (if any, please correct me !)
12 radio environment maps by using the radioenvironmentmaphelper class, the radio environment map (REM) file may be output. For example, a uniform 2D mesh value indicates the downlink base station (with the strongest signal at each point) signal-to-Noise Ratio, you can specify whether REM should generate data or control channels. In addition, you can set rbid, which indicates that REM will be generated. By default, rbid is-1, indicating that R
In addition, this article uses several examples to quickly understand ZK content. These mature and large applicationsProgramIs a shortcut to quickly master these technologies.
Navalplan
Http://www.zkoss.org/demo/external various sites using ZK
Http://www.navalplan.org/
Navalplan is a Web-based project planning, monitoring, and control software developed based on the zk framework.
Main features include:
* Multi-project management.* Team Resource Allocation* Flexible calendar* Generate confi
named Fernando zanini. It uses its interface in the free version of sketchup to create a. X file. Visit http://tinyurl.com/skp2xto download this script.
This script supports the earlier version of sketchup. Of course, it must be later than version 6.
To install the export tool to sketchup, disable the applicationProgramCopy 3dradexported. RBS to the plug-in directory of sketchup (default: C: \ Program Files \ google sketchup 8 \ plugins. Restart
last 3 locks will always wait for the last 3 locks, weYou must release the previous one to continue working.
Level 4 lock: s lockThe corresponding SQL statements include: Create index, lock XXX in share mode
Level 5 lock: SRX lockThe corresponding SQL statements include lock XXX in share row exclusive mode. When the primary and foreign key constraints exist, update/delete...; may produce 4 or 5 locks.
Level 6 lock
The SQL statements corresponding to the X lock include ALTER TABLE, drop table, d
example in the SDK to add custom content sources.
Put:
(Sample for crawling logs: // Protocol)
(Search results. We can see that in addition to the sample protocol, we also found MP3, thanks to the ifilter of the previously written MP3)
TIPS:
Ifilter: ifilter is a plug-in that searches for files of this type based on the corresponding file type, CLSID, or progid. Moss provides some common ifilter, such as office documents, txt, HTML, and XML. You can search for these documents in full text. Th
store the space used in some experiment examples, and of course it can also be used to store the data of the application system. The old version does not have users tablespace. The current user tablespace is users.
5) data and index tablespace
Table spaces that store data and indexes are promoted in application systems after oracle7, especially systems with large amounts of data. Data and indexes should be stored separately in different partitions, this improves the query speed. After installat
saves the user rollback segment is called the rollback tablespace (or RBS undo tablespace )). In Oracle8i, It is rollback tablespace, Which is changed from Oracle9i to undo tablespace. In Oracle 10 Gb, only six tablespace sysaux, system, temp, undotbs1, example, and users are initially created. Temp is a temporary tablespace, while undotbs1 is an undo tablespace. Figure 2-5 shows the relationship between tablespaces and databases and data files. Figu
necessary rollback segments:
Create rollback segment Rb2 tablespace RBS;
6) edit the initsid. ora file of the initialization parameter file and add the following items:
Parallel_server = true
Instance_number = 1
Thread = 1
Rollback_segments = (R01, r02, r03, r04)
7) Create the data dictionary required by OPS, that is, run catparr. SQL.
8) Start the instance on all nodes.
6. How can I determine whether a database is running in parallel?
Show parameter
There are netizens on QQ to find me, said Oracle 7.3 database, because redo abnormal consultation I can restore
Check the database for the following information
The code is as follows
Copy Code
Svrmgr> select * from V$version;BANNER----------------------------------------------------------------Oracle7 Workgroup Server Release 7.3.2.2.1-production releasePl/sql Release 2.3.2.2.0-productionCORE Version 3.5.2.0.0-productionTNS for 32-bit windows:version 2.3.2
table space.
Iii. fragmentation calculations in the free range
Since free space debris is made up of several parts, such as the range, the maximum size, etc., we can visualize the value of the FSFI (free Spaces Fragmentation Index: Space debris indexes):
FSFI=100*SQRT (max (extent)/sum (extents)) *1/sqrt (sqrt (count (extents))
As you can see, the maximum possible value for FSFI is 100 (an ideal single file tablespace). As the range increases, the FSFI values slow down, and as the maximum r
The Oracle tutorial being looked at is the space management technique for Oracle databases. In an Oracle database, DBAs can make possible adjustments by observing a certain table or view to see how the current space is being used.
I. Free space in the table space
By observing the free space of the table space, it can be used to determine whether the space allocated to a table space is too much or not enough. Take a look at the following statement
Can see that in the Fileno 12 table space
RBSJF 3.220E+09 2.716E+09 504356864 15.662396
7 sfglts 2.146E+09 1.228E+09 918159360 42.776014
6 Sfsjts 2.146E+09 1.526E+09 620093440 28.889457
1 SYSTEM 523239424 59924480 463314944 88.547407
3 TEMP 523239424294912 522944512 99.943637
4 TOOLS 15728640 12582912 314572820
5 USERS 7340032 81927331840 99.888393
Rows selected.
Can see that in the Fileno 12 table space RBS, only 0.19% of the allocated space is not used, this proportion is too small, and
diagnostic events
1, determine the temp table space ts#
Sql> Select ts#, name from V$tablespace;
ts# NAME
-----------------------
0 Sysyem
1 RBS
2 USERS
3* TEMP
......
2. Perform cleanup operations
Alter session SET Events ' immediate trace name drop_segments level ts#+1 '
Description
The temp table space is ts# to 3*, so ts#+ 1 = 4
If you want to clear all the temporary segments of the table space,
ts# = 2147483647
[Q] How to dump the internal struc
additional tablespaces to divide users and applications. For example, the user table space is for general users and the RBS table space is used for rollback segments. A table space can belong to only one database. To view the table space statements owned by the current user: SELECT NAME from V$database CREATE TABLE space Syntax: Create tablespace tablespace name
datafile table space data file path
size table space Initial si
database. To facilitate management and improve operational efficiency, you can use additional tablespaces to divide users and applications. For example, the user table space is for general users, and the RBS table space is used for rollback segments. A table space can belong to only one database. CREATE TABLE space Syntax: Create tablespace table space name
DataFile table Spatial data file path
size table space Initial size
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.