Most phones will accept SMS messages sent to them via email. For example, to send an SMS message to a Verizon phone, Compose a new email and use the recipient’s mobile phone number as the email address, with the addition of “@vtext.com” at the end. For example, if the phone number is 555-123-4567, type “5551234567@vtext.com.” Make sure you keep your message under 140 characters. (Remove your email signature before sending, if you use one.)
Perhaps we can address this from your business requirements. What integration points are required with IFS? What data needs to be exchanged? Is the integration inbound, outbound, or bidirectional? Are you looking for a real-time integration or batch mode using data files? Any additional information you can provide would be helpful.
It would be interesting to know what and how many objects are available for parallel execution. Most IFS objects have a parallel processing degree of 1, and therefore won’t start up parallel processes. SELECT owner, table_name, degree FROM dba_tables where trim(degree) <> '1' order by owner, table_name; Here’s q query where you can view parallel statistics should it still be enabled on other databases. Needs privilege to run this query. select * from v$pq_sysstat;
A couple questions,How many users would you like to lock out of the system? Are you identifying the users based no username, role, etc?You have a couple different options available. A simple PL/SQL script can be created if you have a list of the usernames you want locked. The script would perform an “ALTER USER <account> ACCOUNT LOCK;” command. When you want to unlock the accounts you have the script perform “ALTER USER <account> ACCOUNT UNLOCK;”. If you have thousands of users you could take away the “CREATE SESSION” from their Oracle roles. This is more complex because you have to make sure you leave the ability to create a session in place for the users you want to have access.
Try this one. I removed an inner select statement that displays the SQL_TEXT of the command being run. You can find the SQL commands being run by querying the v$sql VIEW and matching the SQL_ID being returned form the query shown below.select sess_cpu.con_id, sess_cpu.sid, NVL(sess_cpu.username, 'Oracle Process') username, sess_cpu.status, sess_cpu.logon_time, sess_cpu.machine, sess_cpu.program, sess_cpu.type, sess_cpu.event,round((sysdate - sess_cpu.logon_time)*1440*60) logon_SECS, sess_cpu.value/100 SESS_CPU_SECS, (sess_cpu.value - call_cpu.value)/100 LAST_CPU_SECS,round((sess_cpu.value/100)/round((sysdate - sess_cpu.logon_time)*1440*60)*100,2) Percent, sess_cpu.sql_idfrom(select se.con_id, se.sql_id, ss.statistic#, se.sid, se.username, se.status, se.program, se.logon_time, sn.name, ss.value,se.machine, se.type, se.eventfrom v$session se, v$sesstat ss, v$statname snwhere se.sid = ss.sidand sn.statistic# = ss.statistic#and sn.name in ('CPU used by this session') ) sess_cpu,(select se.
As an alternative to a $2,000 utility, here is a query that will show sessions ranked by CPU usage and shows helpful information about the session so you can track down the process/user. The query displays helpful information like username, machine, program, type, event, and the sql text/command being referenced. select sess_cpu.con_id, sess_cpu.sid, NVL(sess_cpu.username, 'Oracle Process') username, sess_cpu.status, sess_cpu.logon_time, sess_cpu.machine, sess_cpu.program, sess_cpu.type, sess_cpu.event,round((sysdate - sess_cpu.logon_time)*1440*60) logon_SECS, sess_cpu.value/100 SESS_CPU_SECS, (sess_cpu.value - call_cpu.value)/100 LAST_CPU_SECS,round((sess_cpu.value/100)/round((sysdate - sess_cpu.logon_time)*1440*60)*100,2) Percent, sess_cpu.sql_id,(select sql_text from v$sql sql where sql.sql_id = sess_cpu.sql_id) sql_textfrom(select se.con_id, se.sql_id, ss.statistic#, se.sid, se.username, se.status, se.program, se.logon_time, sn.name, ss.value,se.machine, se.type, se.eventfrom v$ses
Here’s a non-Crystal Report option for printing labels out of IFS. Crystal is pretty bulky for generating barcode labels, has margin control issues on smaller label sizes, and requires a larger print engine to render a label.Getting the data out of IFS and into a label printing engine. Some options include creating a small text file that label engines pickup and process or sending the data directly to the print engine via a TCP socket connection (fast and no file is required). Designing and printing the labels - there are several options available that are focused on printing barcode labels. Some of these include, Loftware - www.loftware.com BarTender - www.bartendersoftware.com DSI EPP - https://www.dsiglobal.com/product/add-on-products/enterprise-printing-platform/ I have sample PL/SQL code for generating the label data from any IFS object available. The sample code only sends fields that have one of the following datatypes; CHAR, VARCHAR2, DATE, NUMBER.The PL/SQL code learns from th
Pinpointing these issues may take several queries and a bit of monitoring to pin down. Can you please provide the following information.The server has 96 GB of memory installed. How much memory is being used by the “oracle.exe” process(es)? Please confirm that this server only hosts one database. What are the values of the following Oracle parameters? compatible cpu_count db_cache_size job_queue_processes optimizer_deatures_enable optimizer_index_cost_adj pga_aggregate_target processes sessions sga_max_size sga_target shared_pool_size sort_area_size How many cores are assigned to this server? Is the server physical or virtual? Are the table statistics current (withing the past week)? Have the indexes been validated lately? What is the operating system version? Do you have a utility installed to view the threads under the “oracle.exe” process to see what type of process (worker, execution, job, etc) is consuming the CPU? All sessions run as a separate thread under the “oracle.exe” proc
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.