oracle database sql expert certification

/*The CHUNKS column indicates the number of available idle blocks in the tablespace (each idle block is composed of several consecutive Oracle data blocks). If there are too many idle blocks, for example, if there are more than 100 data files on average, the fragmentation of the tablespace is serious.*/Select tablespace_name,Count (*) chunks,Max (bytes/1024/1024) max_chunkFrom dba_free_spaceGroup by tablespace_name; /*If the

return in conditional processing methodpublic static string InsertParameters (ref list{String Strparametros = String. Empty;for (int i = 0; I {Strparametros + = i = = 0? ":" + uniqueparname + I: ",:" + Uniqueparname + i;OracleParameter param = new OracleParameter (Uniqueparname + i.tostring (), oracletype.number);Param. Value = Lsids[i];Orclparameters.add (param);}return Strparametros;}Code calls use theliststring[] Strarray = state. Split (new char[] {', '});Int[] Intarray;Intarray = array.conv

--View Log filesSelect member from V$logfile;--View Table space usageSELECT SUM (bytes)/(1024x768 * 1024x768) as free_space, Tablespace_nameFrom Dba_free_spaceNBSP; GROUP bytablespace_name; Selecta.tablespace_name,NBSP; a.bytes total,NBSP; b.bytes used,NBSP; C.bytes Free,NBSP; (b.bytes *)/a.bytes "% used", (c.bytes *)/a.bytes "% free" NBSP; Fromsys.sm$ts_avail A, sys.sm$ts_used B, Sys.sm$ts_free c Wherea.tablespace_name = B.tablespace_name Anda.tablespace_name = C.tablespace_name;NBSP;

Label:--SDE User Login Execute the following statementGrant INSERT, UPDATE, delete on sde.table_registry to public; Grant INSERT, UPDATE, delete on sde.column_registry to public; Grant INSERT, UPDATE, delete on sde.geometry_columns to public; Grant INSERT, UPDATE, delete on sde.layers to public; Grant INSERT, UPDATE, delete on sde.spatial_references to public; Grant INSERT, UPDATE, delete on sde.st_spatial_references to public;Open permissions SQL sta

1. Download the agile client instantclient (about 40 MB, select the appropriate download) Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html 2, download and install PLSQL (16 m): http://www.onlinedown.net/soft/4902.htm 3, unzip Instantclient-basic-win32-11.2.0.1.0.zip to new folder, such as D:/oracleclient/instantclient_11_2 Create tnsnames. ora in a text document. The content is roughly as follows: # T

oracle| Data | database 1, view the table space name and size Set linesize 140;set pages 200;column tablespace_name format A30;select tablespace_name,min_extents,max_extents,pct_ Increase,status from Dba_tablespaces;select Tablespace_name,initial_extent,next_extent,contents,logging,extent_ Management,allocation_type from Dba_tablespacesorder by Tablespace_name; 2, view the table space physical file name a

1. view the table space name and size. Select T. tablespace_name, round (sum (Bytes/(1024*1024), 0) ts_sizeFrom dba_tablespaces T, dba_data_files dWhere T. tablespace_name = D. tablespace_nameGroup by T. tablespace_name; 2. view the name and size of the tablespace physical file. Select tablespace_name, file_id, file_name,Round (Bytes/(1024*1024), 0) total_spaceFrom dba_data_filesOrder by tablespace_name; 3. Check the rollback segment name and size. Select segment_name, tablespace_nam

largest companies use DB2 database servers, while the country accounts for about 5% of the 97. scalability, parallelism SQL Server Parallel implementation and coexistence models are not mature. It is difficult to handle the increasing number of users and data volumes. Scalability is limited. Oracle Parallel Servers Extend Window NT's capabilities by enabling a

When we operate databases, database tables may be locked due to improper operations, so we are often at a loss and do not know how to unlock these tables, the "sessions" in the menu "tools" of pl/SQL Developer can query existing sessions, but it is difficult to find that session is locked, it is more difficult to find the locked session. The following is a query statement that can query the locked session.

Tags: PL/SQL developer do not install client connection to remote Oracle databasePL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now that more and more business logic and applicatio

In many cases of development, for convenience or commonality of consideration, we first consider the SQL Server database for development, but sometimes the customer's production environment is Oracle or other database, then we need to transform the corresponding data structure and data script to the corresponding

oracle|server| Data | Database because the project needs to convert a database of previous Oracle to SQL Server, the database is migrated using SQL Server DTD today, but after import, o

connection succeeds.On the whole, it seems to be a sqlnet.authentication_services problem, but in the case of PL/SQL Developer Connection ORA-12638, useful navicat premium for remote connection Oracle, The connection is successful, so after PL/SQL developer Remote Connection succeeds, the file on the server is Sqlnet.ora sqlnet.authentication_services= (NONE) Ch

) service name" is the global database name of the database you created earlier. At this point, a service named Server_ip, Server_port, and db_name three features are configured to complete. Click Next. 5. Test or Complete: Click "Finish" to exit the wizard. Or click the "Test" button to test whether the above configuration is correct: Make sure that the user ID you used for your test is not locked. You

for LOAD mode: Alter DB mount;11: View Data File list: select name from V$datafile;View Temporary file list: select name from V$tempfile;View Log file list: SELECT * from V$logfile;You will see the following results:E:\APP\USER\ORADATA\ORADB\SYSTEM01. DbfE:\APP\USER\ORADATA\ORADB\SYSAUX01. DbfE:\APP\USER\ORADATA\ORADB\UNDOTBS01. DbfE:\APP\USER\ORADATA\ORADB\USERS01. DbfE:\APP\USER\ORADATA\ORADB\SDMS_DATA01. Dbf12: Modify the data file path and execute the following command in turn:sql> ALTER

Tags: image file src ase order html get GIF URLOracle's reverse engineering refers to importing databases in Oracle, or, of course, databases in SQL Server into PD, which requires a link to a database and then reverse-engineered operations.First step: Establish a link to the database:PowerDesigner establishes a connection to the

the rownum condition, that is, the first 5 data in the physical location, and then sorts the data according to the order by field, rather than the first sort, and then the number of specific records we expect.There are typically three different types of dynamic SQL methods that are executed: Use the Execute IMMEDIATE statement.In addition to not being able to handle multiline query statements, other dynamic