I have been asked to explore the possibility of migrating our current
mobile application on 9i Lite to cellular technology.
I don't know where to begin. What are the hardware requirements (other
than the handheld units)? I probably need a subscription to a provider
that can facilitate this for us
Yes.
We are on our second SAN. Our first SAN had an untimely demise
and caused our vendor to make some normally unheard of concessions. :)
Aside from some HW problems with that first unit, SAN's are very nice.
Ours ( EMC CX600, about 750 Gig usable ) is quite fast.
There is currently a job
Saira,
If you have a Metalink Account do a search on CDPD. There is a forum
discussion on what your asking. May create more questions than answers, but that's
what the forums are for.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent:
Last year a U-Haul drove up to the parking lot and some guy came in
saying he had big computer stuff in there and we had to get it out. (I
think he was a FedX employee.) It turns out it was a NetApp for demo so
we rolled it into our little local data center. After lot's of phone
calls and even a
Thank you. As per your suggestion, I have been able to locate some
pertinent information and terminology starting with CDPD.
Thanks!
Saira
-Original Message-
Goulet, Dick
Sent: July 15, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
Saira,
If you have a Metalink
Dennis,
That's awfully kind of you - I'd love to write a book on storage and
Oracle (since I've dedicated a troubling amount of my life to those two
things), but I have the faint suspicion that the last 100 pages would be
nothing but All Stripe and No Parity Makes Matt a Dull Boy.
The try not
Yes, complicated with as simple a combination as tables and their indexes.
Consider even more variables introduced by using LOBs and interMedia Text.
In a past job, I used to make myself crazy analyzing and placing all the
segments involved with interMedia-indexed CLOBs. Here's what I came up
Hi all,
I have been struggling with the follwing query for hours with no avail.
This is oracle 8.1.7.4 on Tru64 unix with a data warehouse setup. Invc_line is the
fact table with about 267 mil records.
There is a bitmap index on shipto_key(invc_line_bix04) and another bitmap index on
Re-SPECT.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Washington, Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, July
And create pfile from spfile; does a similar job.
I'm rapidly beginning to think that spfiles are just not worth it. Now
how to reverse the policy decision having mandated them for 9i installs
:(
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Or indeed level 8 would do
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Niall Litchfield
Sent: 14 July 2003 21:49
To: Multiple recipients of list ORACLE-L
Subject: RE: Performance problems VMS 8i
Hi Barbara
After an upgrade
The products.jar file you need is in Disk1\install\stage.
--- Thomas Day [EMAIL PROTECTED] wrote:
Interim Patch: 2878462
DATE: May 7, 2003
Platform Patch for : Microsoft Windows NT
Microsoft Windows 2000
Microsoft
Hm, index rebuilding speed shouldn't have anything to do with table data
location, because when rebuilding, fast full scan is done on existing index,
data is sorted to temp ts and then copied back to index tablespace...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L
Hi!
I believe that you can allocate more virtual memory to Oracle than you got
physical. Never cared enough to try, though.
There's a init.ora parameter LOCK_SGA, if you set it to true, then Oracle
tries to hard lock all pages to physical memory, in that case you would
probably get error on
Absolutely! The idea of spfile as a uneditable file but maintained at the
runtime and the pfile is a text file but not maintained is confusing and
error prone - especially for junior DBAs who suddenly find that they changed
something on the init.ora but the effect was not there after the startup.
Tanel,
quotewhen rebuilding, fast full scan is done on existing index/quote
True; except in case of index rebuilding with ONLINE option; the data blocks
are read from the table instead.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Based on Cary's paper regarding when to use an index, would there not be value
in having index tablespaces with a smaller block size vs tables using a larger
block size?
AM PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list
why would an index necessarily need to use a smaller tablespace? is this
article on hotsos? Which one is it?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 6:14 PM
Based on Cary's paper regarding when to use an index, would
why is it useful to seperate different i/o pattersn? such as
multi-block reads and single block reads?
Because (assuming adaptive I/O subsystems like EMC's and
such) each gets optimized into different priority scales and
device queues. And of course if they are to the same device, they
Title: RE: upgrade to AIX 5
I know this is terrible design, but the GUI was
created by a software engineering group that is seperate from the database
group. Its not scalable. So Im trying to come up with a more scalable method. I
have no power to change their gui. It rides on the database.
Tracy,
I would have expected you to say the opposite: big blocks for index segments
(to reduce B*-tree height), and small blocks for table data (to improve
block selectivity).
It's a pretty expensive thing to implement though (assuming you're already
up, the downtime to rebuild a tablespace
Title: RE: upgrade to AIX 5
Ryan,
What would be much better is to create the single schema
and partition the tables so that each customer's data lands into it's own
partition. As for this other group, make some friends. It's a lot
easier to get your problems and concerns addressed if the
Title: RE: upgrade to AIX 5
Ryan,
It's alter session set current_schema =
name;
Tanel.
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 1:29
AM
Subject: security without using different
usernames
I
Title: RE: upgrade to AIX 5
management has handled it. namely my manager and
the answeris no. Partitioning cant be done. we are ingesting data to this
application via transportable tablespaces. So each schema has to be
self-contained.
- Original Message -
From:
Goulet, Dick
Title: RE: upgrade to AIX 5
yeah i think that might be 'viable'. its a big
kludge. but sometimes you have to deal with that.
send outpage that alters the name of the
executable, so each customer's executable has a different name
use program in v$session in a logon trigger to get
the
Ryan,
To make a particular schema the focus for a session:
Alter Session Set Current_Schema = TheSchema ;
Better yet, instead of proliferating the same schema for each client, convert the tables to partitioned tables in a single schema, with each partiion being for a specific client. That way
Title: RE: upgrade to AIX 5
you can create multiple roles also . So if you have
schema a,b,c and they use Z as userid to login then create role_a, role_b,
role_c where role_a has permissions for object in schema a and role_b has
permissions for schema b . Enable proper role at the time of
Could you maybe use v$session.osuser instead of program? That way you shouldn't even
have to rename the exe.
HTH,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Tuesday, July 15, 2003 4:19 PM
To: Multiple recipients of list
Ryan,
Segment Exchange is a very easy, instantaneous, method of moving data back and forth between standalone tables and partitioned tables. Transportable Tablespaces can ingest the data into your DB, but then it can be comfortably digested into partitions via Segment Exchange.
Jack C.
You'll appreciate spfiles if you're using RAC.
-Original Message-
Sent: Tuesday, July 15, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
And create pfile from spfile; does a similar job.
I'm rapidly beginning to think that spfiles are just not worth it. Now how
to reverse the
Title: Message
Consider DBMS_RLS for row level security (or as in some other Oracle
marketing-speak has been called the Virtual Private
Database.)
Essentially: you create a package/stored procedure function that returns
a predicate that can be plugged into a WHERE clause; in your case, in
Cary,
On the same line, I want to propose a different thought - smaller block
sizes for index tablespaces to reduce the chance that a single block is
contended for by two different sessions, which indices the wait event
buffer busy waits. Making them smaller, a typical index block will hold
less
partitioning is not an option. one of our ingestion
methods to bring data to the production database is transportable tablespaces.
It wont work. So we cant just cram everything into the same table. We ingest
data from different 'staging' servers. that have differing logic. this data is
then
And how, exactly?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 7:29 PM
You'll appreciate spfiles if you're using RAC.
-Original Message-
Sent: Tuesday, July 15, 2003 2:09 PM
To: Multiple recipients of list
Hi,
I think the performance requirement varies according to your application
profile.
Bandwidth data is valuable for DSS type database server, while IOPS is
valuable for OLTP systems. For bandwidth test, maybe simple dd can do the
trick?
For IOPS test, it is a bit difficult., you can
I don't appreciate spfile's much either, except in some cases of test
instances, wheres quite easy to type alter system command followed by
startup force to test effects of some parameters... But it all can be done
old fashioned way as well.
In RAC env I still use normal old-fashioned pfile
our application is deployed on multiple remote locations. this would mean we
would have to record the osuser of each each user in each company. This
limits the ability to scale. I believe our deployment process is we send a
CD to the client and their technical support group installs it. Plus we
Spfile is shared and can be modified dynamically without bouncing the
instances.
Eg. Alter system set db_cache_size = 800m scope = [ memory | spfile | both ]
sid = *
Without spfile, you can still make this change dynamically in memory, but
you would have to manually update init.ora file to
Matthew,
Thanks for the list of questions.Matthew Zito [EMAIL PROTECTED] wrote:
Okay, here are my favorites for senior candidates (I'm giving all mysecrets away...):1) What is an inode? Bonus: What important piece of file information isNOT stored in the inode?2) What is priority paging and how
I've only looked quickly at this query, but why do you think it should be
using the shipto_key index? There doesn't appear to be any kind of
filtering on the cust_shipto table so I don't know why an index would help
since every record would match. Am I missing something?
Also, what explain
one place to look would be your sort_area_size. your doing summing and group
bys... if this is too small your going to do that in a temp tablespace
instead of in memory.
your using bitmap indexes right? this implies that some of this data atleast
is non-transactional correct? if its
I think the idea was always roles plus setting current schema - not just
roles on their own. Heck, I'd be so paranoid that I'd make the default
schema empty rather than belonging to a specific site so that if the
executable isn't renamed then it connects to an empty database - it will
make it
AK,
I think this is because of your hot backup script. You
might be encounting these messages while using Alter
system archive log current from your RMAN script
(match the timings and see).
From your messages, you might be on 8.x. 9.x has
better messages :
ARC1: Unable to archive log# 2 thrd# 1
The ability to change the system parameters without bouncing the system is
not provided by spfile, neither in RAC nor single instance databas. It
depends upon the the parameter that can be changed dynamically or not.
I guess you wanted to convey the impression that the using spfiles the
you forgot to list the answers :)
Waleed
-Original Message-
Sent: Tuesday, July 15, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
Okay, here are my favorites for senior candidates (I'm giving all my
secrets away...):
1) What is an inode? Bonus: What important piece of file
Is there any tricks to removing Oracle 9iAS from a UNIX Solaris server, or is an rm -r on the directory structure sufficient?
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
Hello Gurus,
I'm working merging 2 databases which have sane structure of database objects into one database. However, after merging, the business policies and regulations force us to have 2 set of database objects; for example :
Database A has CUSTOMERS table.
Database B has CUSTOMERS
Some time in the past year or so I was reading an article about a similar
problem where they needed to change behavior based on where the connection
originated. I remember something about using IP addresses to drive the
different behaviors. Sorry I can't remember more. It didn't apply to
anything
You can drop or rename CUSTOMERS to, say,
CUSTOMERS_A, and then create synonym CUSTOMERS pointing to CUSTOMERS_B. Or
rename CUSTOMERS_B to CUSTOMERS.
HTH.
Arup Nanda
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent:
I found a document on metalink. I guess my brain is working slower then my fingers this evening."M.Godlewski" [EMAIL PROTECTED] wrote:
Is there any tricks to removing Oracle 9iAS from a UNIX Solaris server, or is an rm -r on the directory structure sufficient?
Do you Yahoo!?The New Yahoo!
Also, depending on your requirements (which I don't fully understand)
another approach may involve using views:
The CUSTOMERS view could point to either CUSTOMERS_A, CUSTOMERS_B or even
the merge of both tables (select * from customers_a union all select * from
customers_b) if required. Of
Hello,
Sorry I might not give all the problem corectly. I need to access to both CUSTOMERS and also CUSTOMERS_B. Not just only one. If only one table, my head will not spin like this.
^__^
Ukrit K,
Arup Nanda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/16/2003 11:59 AM
Please
Arup
My understanding is that Oracle felt if it was going to be a 24x7x365
database, it had to have more parameters that could be changed online. Some
parameters were made changeable in Oracle9i, with hints of more to come.
If the future is online changes, it doesn't make sense to rely on
Hi Friends,
I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some ofbig tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use
Thank you for your idea, Mark,
To explain more about the problem
Before we have 2 databases which they both have same sturcture and same database objects names. We have 2 set of D2K forms and reports to access to each database.
After merging, we looking for move data from database B
Well, then aview is what the doctor
ordered.
1. rename table CUSTOMERS to
CUSTOMERS_A
2. create view CUSTOMERS select * from CUSTOMERS_A
UNION ALL CUSTOMERS_B;
If you do not want to show the duplicates in these
tables, make the UNION ALL just UNION.
HTH.
Arup
- Original Message
Dennis,
My understanding is that Oracle felt if it was going to be a 24x7x365
database, it had to have more parameters that could be changed online
I couldn't agree more. 9i had more parameters that can be changed online;
hope there are more in line.
it doesn't make sense to rely on the
Ave !
Is there any reason not to
keep maxextents always unlimited :) Extentsize should
be reasonable of
course.
Br.
Jorma
-Original Message-From: ext venkat Rama
[mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:34To:
Multiple recipients of list ORACLE-LSubject: Rollback
Segs
Hi
I
think I understand ur problem. What u can do is Create New Users for both types
of form users and create private synonymsin both user schema for the
respective tables and grant relevant permissions.
For
e.g for Customers_A table in User_A schema create private synonym with the Name
In Oracle 8.1.7, a database can be configured with
LOG_ARCHIVE_MAX_PROCESSES = 1
which starts 1 archive process when the database starts.
If the I/O response time for archiving a log takes too long,
then Oracle will automatically start another archive process.
The alert log shows the various
101 - 160 of 160 matches
Mail list logo
